if a stored procedure has 3 select statements how to execut

Question

if a stored procedure has 3 select statements how to execute a particular select statement from the stored procedure

Abhay Shanker · Answer

You can write a select statement in either way DECLARE @condition INT SELECT CASE(@intInput) WHEN 1 THEN Select First statement SELECT CASE(@intInput) WHEN 2 THEN Select Second statement SELECT CASE(@intInput) WHEN 3 THEN Select Third statement Other Way DECLARE @condition INT IF @condition = 1 BEGIN Select First statement END IF @condition = 2 BEGIN Select Second statement END IF @condition = 3 BEGIN Select Third statement END

Girish Sapariya · Answer

example Create Procedure GetDatatemp @casetype varchar(20)='' As Begin if(@casetype = 'case1') begin print 'case 1' -- select statement1 end else if(@casetype = 'case2') begin print 'case 2'-- select statement2 end else if(@casetype = 'case3') begin print 'case 3' -- select statement3 end End --exec GetDatatemp 'case3' Hope this helps you

Manish Kumar · Answer

You Should Pass A parameter and Use the cases in Your Procedure which case match with your parameter that was selected i Hope You Got Appropriate Answer

muthukumar · Answer

give any links to refer

Girish Sapariya · Answer

Hi muthukumar, you have to write the select statements in cases, and pass the case type as parameter to the procedure.

if a stored procedure has 3 select statements how to execut

Answers (5)