Need to EXEC a stored procedure from a CASE statement

[MrJRW]

Good Morning

I would like to EXEC stored procedures as a result of flow control.

My code:

SELECT
CASE
WHEN Count(*) = 0 THEN EXEC Proc1
WHEN Count(*) > 0 THEN EXEC Proc2
END
FROM Table1
WHERE Table1.flag = 'Y'

Any Ideas ?

 

[hmckillop]

SELECT
CASE
WHEN Count(*) = 0 THEN EXEC Proc1
WHEN Count(*) > 0 THEN EXEC Proc2
END
FROM Table1
WHERE Table1.flag = 'Y'

As the count is dictating the flow, then use a variable
i.e.
DECLARE @v_Count bigint
SELECT Count = Count(*)
FROM Table1
WHERE Table1.flag = 'Y'
If @v_Count = 0
THEN EXEC Proc1
ELSE Exec Proc2

I think it should do the same thing as you are asking.

 

[swampBoogie]

if exists (select * from table1 where flag = 'Y')
   exec proc2
else
   exec proc1

 

[MrJRW]

Thanks !!

I got it working

JRW