Let's take for example Nothwind database. There are tables Products, [Order Details], and Orders. We need to insert new batch of orders. My sample below doing that in two steps....

Great article. However, it could be even better, if you add OUTPUT in combination with MERGE statement to provide INSERT for third normal form. Do you have such as example?...

What SSRS version do you using, this problem was corrected in SSRS 2008

To send a table from .NET, you need to use DataTable. I wrote number of applications using this technique, now issues were found. If I have any issues, then I...

I have tested CLR to split a delimited string, much slower and take bigger resources. This why I did include CLR option in my posting.

On this article, my goal was to bring different varieties on techniques how to work with multiple values sent to a stored procedure. The final choice on the reader. I...

INSTALL function (code below) and use it to split a value

CREATE FUNCTION [dbo].[StringToTable]

(@RawString nvarchar(4000), @Delimiter nvarchar(10) )

RETURNS

@VList TABLE (RowID int...

Just declare as many variables as you need, convert report parameters to delimited string send to sproc ... use the same scenario. Let me know if you have any problem.

For internal SQL only - Yes.

Irina, I will research this problem for you. I believe that you need to check array count, Then throw an error when count greater then expected value.

Most of my fellow audience miss the point. For some reason your focus comes to how to parse a string, however this article how prevent array passing to stored procedure.

In real project I never used comma. I am using any non-keybord character, for example ASCII = 135. The comma was used for simplisity.

You could use select * from sys.objects where is_ms_shipped = 0 as well. I am not INFORMATION_SCHEMA fan. This is personal preference.:D

Thanks to everyone for good response (and bad as well). Sorry for broken C# link, but it’s nothing to do with the article.

Believe it on not – I did. This is was while ago, but when I joined to project, all sprocs named as SP_. It took about a month to convince...