Skip to content
Advertisement

IF when zero result from another Stored Procedure

I have a Stored Procedure which contains an Insert statement on it.

create procedure Sp1
(@oName varchar(50), @Address varchar(100))
as
begin
     insert into Tb1(Name, Address)values(@oName, @Address)
end

From the above Stored Procedure, I want to have a condition from result of another Stored Procedure. With the following action:

select count(Branch) cBranch from Tb2 group by Branch

So, if cBranch is zero. Then execute Sp1 else do nothing.

Need advice please. Really appreciated.

Advertisement

Answer

Try This:

CREATE PROCEDURE SP_NAME
AS
DECLARE @Cndtn INT
SELECT @Cndtn=COUNT(Branch) FROM Tb2 GROUP BY Branch

IF(@Cndtn>0)
BEGIN
EXEC Sp1 @oName,@Address
END
ELSE
BEGIN
SELECT 'Else Clause' --Add an another SP name
END
User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement