query on the base of itemno in stored procedure

• sukhoi971

  SSCarpal Tunnel

  Points: 4833

  More actions

  June 3, 2004 at 6:40 am

  #108451

  i have 4 queries in stored procedure i want to fire them on the basis of parameter

  if para=1

  then fire sql1

  if para=2 then

  fire sql2

  how do that ??

  <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

  *Sukhoi*[font="Arial Narrow"][/font]

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  June 3, 2004 at 7:21 am

  #508827

  Maybe something like this:

  CREATE PROCEDURE usp_runproc

     @procparam  INT

  AS

     IF @procparam = 1

       BEGIN

         EXEC usp_procedure1

       END

     ELSE

     IF @procparam = 2

       BEGIN

         EXEC usp_procedure2

       END

     ELSE

     IF @procparam = 3

  <Rest of script>

  -SQLBill