I have an SP that accepts a single input param.
I want to run a different select based on it's value.
create procedure blahblah
select case @type
when 'all' then
when 'unassigned' then
but it's riddled with errors.
Syntax error or trying the impossible?