The conversion of the varchar value overflowed an int column in sql server 2012 -


i'm getting error query data... error message is: msg 248, level 16, state 1, line 1: conversion of varchar value overflowed int column... cant resolve problem, if 1 can me, in advance, here sql:

this happens when inserted 3 new joins in query, made them bold, otherwise works perfectly...

select distinct     acr_art_id, des_texts.tex_text criteria_des_text,    coalesce(des_texts2.tex_text, acr_value) criteria_value_text,    (des_texts.tex_text + ': ' + coalesce(des_texts2.tex_text, acr_value)) cel_opis                  inventory.dbo.article_criteria left join     inventory.dbo.designations designations2 on designations2.des_id = acr_kv_des_id  left join     inventory.dbo.des_texts des_texts2 on des_texts2.tex_id = designations2.des_tex_id left join     inventory.dbo.criteria on cri_id = acr_cri_id  left join     inventory.dbo.designations on designations.des_id = cri_des_id left join     inventory.dbo.des_texts on des_texts.tex_id = designations.des_tex_id inner join     inventory.dbo.art_lookup al on article_criteria.acr_art_id = al.arl_search_number     , al.arl_kind in (1,3) inner join     inventory.dbo.articles on al.arl_art_id = a.art_id , (a.art_sup_id=21 or a.art_sup_id=11091) inner join     inventory.dbo.suppliers on suppliers.sup_id = art_sup_id**      (designations.des_lng_id null or designations.des_lng_id = 25)    , (designations2.des_lng_id null or designations2.des_lng_id = 25);

as commented @t i

the varchar col implicitly converted int , overflowing (i.e. >larger 2,147,483,647). resolve try casting columns bigint

you can cast column value data type 

select cast( max(columnname) bigint)+1 atable ;

but if varchar fail, error better change db schema. use approach if sure numeric string present.


Comments

Post a Comment

Popular posts from this blog

Linux vanilla kernel on QEMU and networking with eth0 -

i have downloaded , compiled vanilla linux kernel (3.7.1) used busybox ramdisk booted using qemu. qemu command line qemu-system-i386 -kernel bzimage -initrd ramdisk.img -append "root=/dev/ram rw console=ttys0 rdinit=/bin/ash" -nographic -net nic -net user everything goes well. however, can't use networking on vanilla kernel busybox. 'ifup eth0' tells me / # ifup eth0 ip: siocgifflags: no such device i googled internet can' clue... advice nice thank in advance. most there no driver (in example should e1000) loaded or device has name. in /sys/class/net/ should find listing of available net-devices. if there none (besides lo) driver not loaded. in qemu monitor type "info pci" , show pci-address of ethernet card. should this: ... bus 0, device 3, function 0: ethernet controller: pci device 8086:100e ... this device corresponds /sys/devices/pci0000:00/0000:00:03.0/. files "vendor" , "device" must c...
Read more

rdbms - what exactly the undo information lives in oracle? -

some docs says, there "undo tablespaces" implies should create tablespace undo imformation. some docs says, there "undo segment" implies undo information lives in normal tablespaces , use of it's segment. so, undo information lives , organized? earlier releases of oracle database used rollback segments store undo. oracle9i introduced automatic undo management, simplifies undo space management eliminating complexities associated rollback segment management. oracle recommends (oracle 9i , on words) use undo tablespace (automatic undo management) manage undo rather rollback segments. when creating undo tablespace, these automatically created: n undo segments (based on sessions parameter value) named _syssmun$ owned public (usable ops configuration) not manually manageable
Read more

javascript - RequestAnimationFrame not working when exiting fullscreen switching space on Safari -

request animation frame stops working when exiting fullscreen clicking on original space's safari window. fine if fullscreen mode canceled escape key or calling cancelfullscreen(). steps reproduce: open https://dl.dropboxusercontent.com/u/769042/prezi/safari-fullscreen.html click "draw raf", kittie appears click "fullscreen", go fullscreen click "draw raf", kittie appears go space original safari was, showing "click exit fullscreen mode", click anywhere, out fullscreen click "draw raf", nothing happens what handling click calling: window.requestanimationframe(draw); which draws on canvas context: function draw() { ctx.drawimage(img, math.random()*500|0, math.random()*400|0, 100, 100); } i checked .hidden , .visibilitystate, updated correctly. tested on osx 10.9.3, safari 7.0.4 (9537.76.4). has workaround/solution other switching old settimeout? this sounds webkit bug 88940 : using reque...
Read more