Hi Luis,

I have a parent stored procedure which is executing the child stored procedure without any condition. Before calling the child sp, I want to put the check that If the data is available in that variable then only execute that child sp.

I have a parent sp name saveproduct_QP

and it is calling savepricing_QP

for that child sp, they assign some table valued parameters

exec savepricing_QP

@productdetails = @productdetails

@Orderdetails = @orderdetails

@customerId = @customerid output

In the sp I added that

Alter saveproduct_QP

IF EXISTS (SELECT 1 FROM @ProductDetails)

begin

exec savepricing_QP

End

Now, I want to test sp that it doesn't have any functional changes