Jeff Moden (1/10/2011)
Craig Farrell (1/10/2011)
Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more efficient.
I haven't had the opportunity to use them at a business level yet, but they're dang handy. 🙂
Sounds like a "SQL Spackle" opportunity for someone... :w00t:
Agreed... Gus? What say thee?
I have used them in a business environment, and they worked great. I'll see what I can write up on it.
I will duck out, stage left, then. 🙂 I still need to get SQL 2k8 express installed at home.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]