Heh... sorry... don't see the connection 😛

What do you do when the requirements change and the datatype...

Yuh huh... you watch... the next thing the boys from ops will ask for is a summary of the files sizes 😉

Thanks, but still doesn't answer my question... what type of data would those "arrays of values" contain?

Gotta ask... WHY?

I'd just BULK INSERT into a table and go from there.

Not enough answers in the Poll... for the reasons you stated, I simply don't allow 3rd part software into my database without a full peer review for form, fit, function,...

I'd like THAT a lot... the Google search seems pretty much out of whack when searching the forum.

Anyone ever hear of sp_HelpFile? 😉

That's just not nice... now we have an answer with no question.

I guess my question would be... why does anyone pass more than 8000 bytes of parameters to a stored procedure... what is the purpose?

If it's that critical, create a "token table" where you set a row to identify if the job is already running. Check for that token at the beginning of...

No, it's not different......

Ok... sure...

In order to do what you wanted, you wrote a loop to have a variable (@InitialValue) count from 1 to 6 in your first example. Then you...

1. What is the best way to show rows of data here? I am sure the way I did it can add to confusion if a lot of columns of...