loveindia Posted January 6, 2016 Report Posted January 6, 2016 Int column lo varchar values using case statement ki oka bug undi bro ... Conversion failed wh converting the varchar value 'Full' to data type int ani Select case when deduct = 0 and state = 'FL' then 'Full' else cast (deduct as varchar(10) end from tables joins conditions ..... Else tarwatha aaa casting aaa error ki fix.::. Blog lo rasko help avtadi vere vallaki Nuvvu akkadey beer lo leg ettav.. Asalu casting enduku cheyalsi vachindo neeku teliyaledu first.. Ur result set is returning first output value as an int so total derived column is set to int data type .. This is a specific issue to your query and straightforward man...
teaspoon Posted January 6, 2016 Report Posted January 6, 2016 Nuvvu akkadey beer lo leg ettav.. Asalu casting enduku cheyalsi vachindo neeku teliyaledu first.. Ur result set is returning first output value as an int so total derived column is set to int data type .. This is a specific issue to your query and straightforward man... It's ok
RangeRover Posted January 6, 2016 Report Posted January 6, 2016 Nuvvu akkadey beer lo leg ettav.. Asalu casting enduku cheyalsi vachindo neeku teliyaledu first.. Ur result set is returning first output value as an int so total derived column is set to int data type .. This is a specific issue to your query and straightforward man... pelli ayindhi .. enjoy seyyaka malla db endhi man.. Sql sangha seva seyyalsindhena
loveindia Posted January 6, 2016 Report Posted January 6, 2016 pelli ayindhi .. enjoy seyyaka malla db endhi man.. Sql sangha seva seyyalsindhena Pelli aindi kada ani pranam in vidichipettalem kada man... Family is my prapancham but Idi naa passion... That's it man...
teaspoon Posted January 6, 2016 Report Posted January 6, 2016 pelli ayindhi .. enjoy seyyaka malla db endhi man.. Sql sangha seva seyyalsindhena Pelli pelle sql sql e
loveindia Posted January 6, 2016 Report Posted January 6, 2016 Pelli pelle sql sql e Anyhow India lo unna so enjoying from here...
teaspoon Posted January 6, 2016 Report Posted January 6, 2016 Anyhow India lo unna so enjoying from here... Pelli ela jarigindi??
k2s Posted January 6, 2016 Report Posted January 6, 2016 checked ur stats and ur pathivratyam is proved daddy man... you are ahalya the amayakuraalu.... yes man ..ahalya is very ammaikuralu
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts