All Forums Database
dlayten 3 posts Joined 01/13
06 Aug 2013
Strange error regarding data type

All,
When I use this query select CASE WHEN TOTAL_PASS = 1 THEN 1 ELSE  0 END as COMPLIANCE....It seems to work, however when I use this CASE WHEN TOTAL_PASS = 1 THEN 'Y' ELSE  'N' END as COMPLIANCE... I get this error  "Output Schema does not match data from SELECT statement". I am guessing it does not like the string datatype. Does anyone have any ideas as to what could cause this?
 
Thanks,
 
Dan

TD_Raj 50 posts Joined 05/10
07 Aug 2013

Hi
Kindly share the complete scenario.
If it is simple insert select then this should work fine.
 
--
Raj

You must sign in to leave a comment.