There is nothing special about flag='y'... it's text. It could be anything He's just aliasing the table.

The point is that by using square brackets you can alias something to...

// commentware

// where there is more

// commented-out code

// than there is

// actual stuff

// that does any work!!!

Hey there,

If you already have Ops Manager, you're going to have a very difficult time writing something that's better from scratch. If you want something that's very lightweight, consider...

Use... Regular Expressions / Wildcards in the SQL Server Management Studio in the Find/Replace dialog.

I am definitely guilty of retrieving more data than I need to, and using UDFs that make my code simpler and more reusable, but perform badly.

I am going to rationalize...

Also, be sure to only give the user ID which your application uses, or any regular users, the minimum access required. If security trimming is not realistic, db_datareader and...

As far as your question with "how do I deal with commas in a name?" goes, that's a common thing with names.

The answer is to put a " character in...

I definitely thought you were talking about UNION statements too...

I think that standardized training might be one of the few benefits.

I would be concerned about what might happen to people...

Wild guess, but it could be a permissions issue. Is SQL running under the system account? If so, does the SQL Server computer account have access to the...

Congratulations! Thanks for running such a great site with fantastic content.

Completely agreed here. Being in a development role, I have learned equal...

Thanks, Jeff. I was wondering what I was going to have for dinner tonight.

Thanks Lynn,

I think you answered my question about as well as possible. Sure enough, a search for CTE brought up plenty of results for how I could do this...

At some point we're going to have to evaluate having a "permanent" tally table in the DB. For now, it's only used in reporting and since it can generate...

Thanks. The Select Max() in the join was the magic I was looking for.

I do actually have a tally table, but it's a calendar tally. I modified your...