Mr_Shaw
asked on
cae and select together
is it possible to use CASE and select together... For example
select CASE WHEN @Spec_Desc = 'All' THEN
(SELECT ID from TBL) ELSE .............
select CASE WHEN @Spec_Desc = 'All' THEN
(SELECT ID from TBL) ELSE .............
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can't have "SELECT" statement in CASE THEN statement. CASE THAN should be nested in SELECT.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks