Yeah, I noticed that. Sorry about the original.

Glad you found this useful.

Good ideas. Just remember that this is still unsupported so don't call Redmond if you have problems with it.

That's what we're all here for anyway.

Take out the sid>1 conditional from the where clause.

One of the readers, Scott, pointed out that the SID=1 means sa created the database and that this isn't a good...

I'm not sure how the optimizer would handle them. It would be easy enough to come up with a test query and then execute it via xp_execresultset and a dynamic sql method.

Make sense. Thanks for the explanation.

Well, on general principle I wouldn't let developers use sp_execresultset as it is undocumented. This means Microsoft may choose to change or remove it, as they did in SQL2005, or...

You have Pub and Northwind on a production server?

Typically, they can be removed as they are demo data and really have no place on a production SQL server. Is there...

Thanks for taking the time to raise questions, Scott. Glad to help.

The SID column is the SID of the creator. Scott pointed out that some servers may have databases that...

Hard to argue with either of those points, the first mostly. Yeah, usually I was unaware the wheel existed until I got fed up trying to make my own wheel...

I really wasn't trying to recommend a product. Instead, I was asking whether it made sense to use native SQL to do what I see as a pure reporting function...

The latest version of Crystal Enterprise could probably do that. Something to look into.

Raise your hand if you have never inherited a system, program, database from someone else, taken a look at it, said one or more WTFs, and then found out later...

"I don't know if you have ever dealt with date issues, globalization, time offsets, etc, all simultaneously, but it's not a pretty site. As example test of your globalization skills,...

Going back to Steve's original point: That, generally speaking, many developers simply don't know how to design good databases; I present the following real-world example of bad design. Or, what...

Well, logically, yeah. But it doesn't "read" the same:

"While at first you don't succeed, try, try again"?

Then again, maybe that does work.