How Create a store procedure from another store procedure

• muntasiriub

  SSCommitted

  Points: 1810

  More actions

  January 11, 2004 at 2:07 am

  #107349

   i can create a view from another view for example :

  create view viewX

  as

  select o.Locationid,o.Itemcode,o.openingdate,o.openingQty

          from view1 as o

         ………..

         left  join view2 as MR on o.Locationid=MR.Locationid

         left join  view3 as TR on o.Locationid=TR.Locationid        

         left join view4 as TI on o.Locationid=TI.Locationid …….     

        where .......

  so if i use here store procedure, how can i do this as above?

  
  
  ..Better Than Before...

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  January 11, 2004 at 4:21 am

  #489534

  Yes there is a way to create a stored from from an another SP

  create proc sp1

  as

  declare @STR varchar(1000)

  set @STR = 'create proc sp2 as select * from t'

  exec (@str)

  go

  
  
  Bye
  Gabor

• muntasiriub

  SSCommitted

  Points: 1810

  More actions

  January 11, 2004 at 4:26 am

  #489535

  ok, let it more clear!

  I have a view view1 where material receiving information is summarized along with location id ,date and other necessary info

   

  I have another view view2 where all sales information is summarized along with location id with location id ,date and other necessary info

   

  I have another view view3 where all sales return information is summarized along with location id with location id, date and other necessary info

  ……

  in this way I have several views

   

  now finally I have a Summary view "viewSummary" where previously created views are linked

  with locationid , date and other necessary info to produce  the current stock.

   

  Now, user can watch stock with in a date period. so I need to pass a parameter to the view to minimize the data and to fill the user req. But passing parameter to a view is not possible so I wants to make it a store procedure SP1,SP2…. Similarly view1,view2….

  And like last summary view ” viewN” – summary store procedure “SPSummary”

  to  produce  the current stock.

   

  But in the store procedure how to do this one?

   

  
  
  ..Better Than Before...