Select statement with Stored Procedure

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  November 13, 2012 at 1:18 pm

  #393596

  Is it possible to do write statement like :

  select item, dbo.StoredProcedure1(QtyAvailable)

  from Item.

  One of the column is executing dbo.StoredProcedure1(QtyAvailable)

• kl25

  Hall of Fame

  Points: 3752

  More actions

  November 13, 2012 at 1:27 pm

  #1558634

  You may want to look into user defined functions. See BOL or this MSDN article on UDFs for further details.

  You may also find this article by Erland Sommarskog helpful.