Which type of DBA? If it's the "System" DBA, you'd better trust him/her... they need total access to really do the job correctly. If it's an "Application" DBA,...

I agree with Steve in avoiding ## Global Temp Tables... if two procs (or the same proc running more than once) attempt to create a GTT (Global Temp Table) of...

Although you can have only 1 Primary Key (hence the word "Primary"), you can, in fact, have multiple UNIQUE keys in the form of UNIQUE indexes. Keep in mind...

Without seeing the offending code, the short answer would be simply to rewrite the code so that it's performance enabled. Step 1... avoid cursors. Step 2... avoid 99.9%...

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!