This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Multi-dimensional parameter in T-SQL

Question
0

Sign in to vote
I'm trying to build a multidimensional array to store a series of values to be used later in the code. I've been in VBA for the last decade, and I'm having trouble adjusting. It gives me an error message of 'Incorrect syntax near ',''. What am I missing?
- Moved by Fanny Liu Tuesday, June 4, 2013 9:35 AM better support
Friday, May 31, 2013 3:08 PM

Answers

1

Sign in to vote
You need to post your query in order to get help. We would not be able to figure out this error without seeing your code.
For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles
- Proposed as answer by Kalman Toth Wednesday, June 19, 2013 11:16 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Monday, January 18, 2016 7:49 AM
Wednesday, June 5, 2013 3:27 AM
1

Sign in to vote
T-SQL supports table-valued parameters:

http://www.sqlusa.com/bestpractices2008/table-valued-parameter/
Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
- Marked as answer by Ed Price - MSFTMicrosoft employee Monday, January 18, 2016 7:49 AM
Wednesday, June 12, 2013 3:55 PM

All replies

0

Sign in to vote

Should this go in the T-SQL forum?

Thanks!
Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

Tuesday, June 4, 2013 5:20 AM
1

Sign in to vote
You need to post your query in order to get help. We would not be able to figure out this error without seeing your code.
For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles
- Proposed as answer by Kalman Toth Wednesday, June 19, 2013 11:16 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee Monday, January 18, 2016 7:49 AM
Wednesday, June 5, 2013 3:27 AM
1

Sign in to vote
T-SQL supports table-valued parameters:

http://www.sqlusa.com/bestpractices2008/table-valued-parameter/
Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012
- Marked as answer by Ed Price - MSFTMicrosoft employee Monday, January 18, 2016 7:49 AM
Wednesday, June 12, 2013 3:55 PM