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

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?

TD_Raj 50 posts Joined 05/10
07 Aug 2013

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

You must sign in to leave a comment.