Great code and explanations, but no test data...

First, dunno how to post CF code on this forum mostly because I've never used CF.

Still need to see code... I see that you've created a function to use the...

Outstanding! Thank you so much for the feedback, Troy. Very happy to have been able to help.

Then, unfortunately, you're gonna need some form of loop and some dynamic SQL with a...

jacob sebastian (12/25/2007)

---

Jeff Moden (12/25/2007)

---

I know a lot of people hate the idea but this is where I'd say "enough is enough" and drop the proc into the Master database...

Post the code that you tried, Tony... it's the only way we can see what might be wrong...

I know a lot of people hate the idea but this is where I'd say "enough is enough" and drop the proc into the Master database and be done with...

Heh... then look up anything by the user known as "Rog Pike"... 😉 A bit more than casual spam.

Ummmm... Not quite true... you can pass in a single delimited variable with named parameter pairs using either a delimited string or XML and split it in the proc....

Perfect... thanks for the feedback, Serqiy! And, long time no see... Happy holidays!

Heh... you're a sick man, Mr. Jones! MERRY CHRISTMAS!

Heh... still at it even late on Christmas Eve, huh, Steve?

Merry Christmas, my friend...

Provided that you haven't disabled the built in administrator account...

Log into the WINDOWS server as the Administrator of the server.

Open Query Analyzer using the Windows NT authentication mode.

Run sp_password to...

What do you want to do to the stored procedures?...

I'll go a little further to help practicing on indexes... here's how to build a million row table of test data... the details are in the comments...

--===== Create and populate...