Passing parameters to a UDF

• Shanalise

  Hall of Fame

  Points: 3188

  More actions

  May 10, 2010 at 11:25 pm

  #221458

  ProductIDNameProductNumberProductPrice

  1Adjustable RaceAR-5381

  2Bearing BallBA-8327

  3BB Ball BearingBE-2349

  4Headset Ball BearingsBE-2908

  I have a table like the one above in a stored procedure. A function that returns a table called GetProductPrice() which accepts the parameters ProductID, Name and ProductPrice, and returns a table like this

  DateProductNumberProductPrice

  20100511AR-5381 $ 7.95

  20100511BA-8327 $ 21.98

  20100511BE-2349 $ 159.00

  20100511BE-2908 $ 54.99

  Problem

  I want to pass the parameters one row at a time from a stored procedure to the GetProductPrice() function and update the ProductPrice in the first table with the ProductPrice from the function.

• Arjun Sivadasan

  SSCertifiable

  Points: 5902

  More actions

  May 11, 2010 at 2:53 am

  #1165403

  Mushana, read this article. It describes how to solve your problem.

  http://www.sqlservercentral.com/articles/APPLY/69953/

  - arjun

  https://sqlroadie.com/