calling a function from storeproc

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  October 25, 2013 at 1:17 am

  #299654

  HI all,

  I am coding a cript and need your input,

  I wanted to call a function which should retun me the index name and I want do further action on it

  How do I call a function from proc to handle this?

  "More Green More Oxygen !! Plant a tree today"

• Johan Bijnens

  SSC Guru

  Points: 134873

  More actions

  October 25, 2013 at 1:42 am

  #1661539

  it depends:

  A scalar value function (SVF ) is called like

  Select SVFSchema.SVF( value_to_be_used )

  A table value function (TVF ) is called like

  Select x.col1, ...

  from TVFSchema.TVF( value_to_be_used ) x

  -- or

  Select x.col1, T.columnA, ...

  from mytable T

  cross apply TVFSchema.TVF( T.columnY ) x

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me