I have the following SQL:
A short version
INSERT INTO Table A
SELECT CASE Response
WHEN 0 THEN 'N'
FROM Table B
Response is a tinyint field in Table A
Response is a char(1) field in Table B
I get a conversion error when I run the SQL:
"Conversion failed when converting varchar to 'N' to data type tinyint"
How do I fix this?