I'm receiving an error: Conversion failed when converting the varchar value 'Yes' to data type int.
I'm using the code:
INSERT INTO ...
CASE WHEN @IsAllDay = 'Yes' THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END
How do use CASE to convert Yes to a Bit value of 1?
CASE WHEN @IsAllDay = 'Yes' THEN True ELSE False END