Hmm...if you have access to the SP you could create a temp table which includes an OrderBy Column. Then you pass in a parameter to the SP building the...

Personally I like Kerry's solution, and that's what I'm going to use. It's easy to fit into my ETL scheme, which is why I was looking at this in...

Hey, thanks for the pick me up! I'm getting ready to work on a big DW project, and have mostly been thinking how overwhelming it is while reading The...

"select * from contactEnquiries where Enquiry_id=@id or @id=''"

Maybe this is too easy (although I hope not because we do it this way in a lot of places!):

select * from contactEnquiries...

Wow, almost 4 years later...

I was reading this thread because it was a topic I searched for, and thought I would add my $.02:

It's always MUCH better to use LEFT...

Thanks Grant, this is a great article. Slightly on, and slightly off topic: I'm trying to convince my bosses that this would be a good idea. This being...

Rather than going into how our personal system works (which my boss would probably be mad at me for anyway!), I'm going to talk about how this users system could...

To expand a bit on what other people have said, it's best to take periodic transaction log backups, at least in synch with your full backups, if not more often....

I think when I've tried to do stuff like that in the past, I've had issues with scope between the dynamic SQL and the code that's calling it.

Again...

Thanks for the article (even when it's reposted!). I'm going to try using this technique for some problems we're having with mirroring in SQL2k5, with slq authentication users, where...

Don't forget our good friend UPDATE STATISTICS

That's a Top 10 gotcha!

There's pretty good documentation for OPENXML in Books Online. If you have problems, post a reply, and I'll try to help you out. I've done a fair amount...

Don't you actually want to sort by the sum of the quantity though? I think your current query would only give you rows where the individual orders for the...

I think this utility is pretty good. I'm going to test it a bit more. We have about 4500 objects (select count(*) from sysobjects where type in ('u',...

I don't do a lot with DTS, but isn't it actually controlled by jobs in SQL Server Agent, and therefor couldn't you use the sp_start_job stored procedure to start the...