Assign variable to CASE statement with nested variable

[larrydavid]

Hello,

I am trying to assign a variable in an insert into statement value as such:

@Base_ID = (CASE @Category_Type WHEN 'GENERAL' THEN 1 END)

I keep getting syntax errors so I know this is wrong. I've been searching for examples and cannot find this so if anyone could tell me what I'm doing wrong or steer me in the right direction i would greatly appreciate it.

Thanks,
Larry

 

[gmmastros]

I think you should post the whole code, not just the single line.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom