February 9, 2009 at 9:58 pm
I would like to create a table valued function that takes a table variable as an input. Anyone know if that is possible? Or how to do it? Thanks.
Courtney
February 9, 2009 at 10:23 pm
You have table valued parameters in 2008, not 2005.
February 10, 2009 at 8:14 am
Thanks. I was afraid of that.
February 11, 2009 at 2:12 am
Take a look at this, it may help:
http://www.codeproject.com/KB/database/PassingArraysIntoSPs.aspx
February 11, 2009 at 9:40 am
I think Erland has the definitive documentation on this topic:
http://www.sommarskog.se/arrays-in-sql.html
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 11, 2009 at 9:53 am
You could also pass in an XML string and parse it into a temp table or table variable.
Greg
February 11, 2009 at 10:36 am
G² (2/11/2009)
You could also pass in an XML string and parse it into a temp table or table variable.Greg
That is covered in the document I referenced, with example code. LOTS of other options covered too. The link is a tremendously valuable resource if you need that type of functionality.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply