Trying to execute a procedure within another procedure 1

[mbcmike]

I want to execute a procedure depending on whether or not a paramater is in a particular table:


execute procedure
where not exists
(select * from table
where ssn = @p_ssn
)


Obviously I am doing something wrong here...

 

[SQLBI]

Hi,

Declare an int variable and assign its value based on the result of your query, then execute your proc based on the variable value.

DECLARE @var int

IF NOT EXISTS (SELECT * FROM Table WHERE ssn = @p_ssn)
BEGIN
SET @var = 0
END
ELSE
SET @var = 1

IF @Var = 1
EXEC pr_YourProc

Or something similar...

Hope this helps.


Cheers,
Leigh

Sure, if it has a microchip in it, it must be IT... Now what seems to be the problem with your toaster...?

 

[mbcmike]

That's it, thanks!