Passing a table variable to a multiline table-valued function

• lallen-661487

  Mr or Mrs. 500

  Points: 531

  More actions

  July 10, 2008 at 10:24 am

  #190355

  I am trying to pass a table variable into a multiline table-valued function, and SQL doesn't seem to like it. How can I pass a table variable? Or can I?

  Thanks for any insight anyone can provide!

• Lorrin Ferdinand-328944

  SSC Enthusiast

  Points: 130

  More actions

  July 10, 2008 at 10:43 am

  #840970

  You can't pass table variables into functions or sprocs.

  BOL:

  "The nonscalar types cursor and table cannot be specified as a parameter data type in either Transact-SQL or CLR functions.

  "

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 10, 2008 at 12:53 pm

  #841060

  You can't pass a table variable, but you can pass an XML variable. Pretty easy to set up.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon