Convert to Logical Data Type

[only412c]

I am trying to get Supply Field in the Select Statement to read as Logical Field, so that it can get into the Sample.dbo.2009_PharmacyData

Getting this message Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'N' to data type bit.



INSERT Sample.dbo.PharmacyData(MemId,PDaySup,Supply,PrServDate, PDiscIng, PDisR,PDispFee,PAdmFee,PMemberCo,TotalCost,NDC,
Clmstat,MetricQNTY)
Select (LTRIM(RTRIM([Family ID]))+Suffix) As MemID,[Days Supply] As PDaySup,
Case When [Generic CD] = 0 Then 'Y' ELSE 'N'END AS Supply,

 

[gmmastros]

In code, bit types should be 0, 1 or NULL. What is the data type of the [Generic CD] column?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Use 1 or 0 instead of 'Y'/'N' for Supply

PluralSight Learning Library