loveindia Posted January 5, 2016 Report Posted January 5, 2016 man, you can do this many different ways.. one way is use a cte ;WITH CTE AS ( write your join tables query here and get desired output first ) SELECT state, deductible, CASE WHEN state = 'FL.' AND deductible = 0 THEN 'FULL' ELSE deductible END AS newColumnName FROM CTE; you can write the same using simple select statement in the same query also.. just because I dont have the query I can write this but this is also much better and faster... good luck man...
k2s Posted January 5, 2016 Report Posted January 5, 2016 man, you can do this many different ways.. one way is use a cte ;WITH CTE AS ( write your join tables query here and get desired output first ) SELECT state, deductible, CASE WHEN state = 'FL.' AND deductible = 0 THEN 'FULL' ELSE deductible END AS newColumnName FROM CTE; you can write the same using simple select statement in the same query also.. just because I dont have the query I can write this but this is also much better and faster... good luck man...wrong
loveindia Posted January 5, 2016 Report Posted January 5, 2016 wrong machine arustundi ikkada man... 2 months back 77k lo unnav, ippudu 92k lo unnav... families india went aa kompateesi daddy man...
k2s Posted January 5, 2016 Report Posted January 5, 2016 machine arustundi ikkada man... 2 months back 77k lo unnav, ippudu 92k lo unnav... families india went aa kompateesi daddy man...:O Nope ikkada machine kevving 2 months back 90k, now 92k...write a query & Check stats rey Howz married life ?
loveindia Posted January 5, 2016 Report Posted January 5, 2016 :o Nope ikkada machine kevving 2 months back 90k, now 92k...write a query & Check stats rey Howz married life ? checked ur stats and ur pathivratyam is proved daddy man... you are ahalya the amayakuraalu....
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 man, you can do this many different ways.. one way is use a cte ;WITH CTE AS ( write your join tables query here and get desired output first ) SELECT state, deductible, CASE WHEN state = 'FL.' AND deductible = 0 THEN 'FULL' ELSE deductible END AS newColumnName FROM CTE; you can write the same using simple select statement in the same query also.. just because I dont have the query I can write this but this is also much better and faster... good luck man... 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
150bryant Posted January 5, 2016 Report Posted January 5, 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 enti data conversion ni and case statements kuda blog lo ki ekkinchaala ?
AFDBAbhimanini Posted January 5, 2016 Report Posted January 5, 2016 SELECT state, deductible, CASE WHEN state = 'FL.' AND deductible = 0 THEN 'FULL' ELSE to_char(deductible) END AS newColumnName
BeerBond007 Posted January 5, 2016 Author Report Posted January 5, 2016 enti data conversion ni and case statements kuda blog lo ki ekkinchaala ? http://blog.sqlauthority.com/2015/07/29/sql-server-error-msg-245-conversion-failed-when-converting-the-varchar-value-inactive-to-data-type-int/ Mana pinal Dave ekkiste lenidi neeku noppi Enti bro ... Thopu lu Kosam kaadu beginners Kosam elkinchamani antuna... With scenario ... I know you thopu
150bryant Posted January 5, 2016 Report Posted January 5, 2016 http://blog.sqlauthority.com/2015/07/29/sql-server-error-msg-245-conversion-failed-when-converting-the-varchar-value-inactive-to-data-type-int/ Mana pinal Dave ekkiste lenidi neeku noppi Enti bro ... Thopu lu Kosam kaadu beginners Kosam elkinchamani antuna... With scenario ... I know you thopu kool raaki
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts