Consistency didn't stop 20 inch wheels from coming out nor has it prevented the use of 13" wheels on some small cars.

Whatever... we could go on forever... our ideas of...

ntaylor (5/21/2008)

Again, though. How do you measure when it's being properly done? You can easily measure...

Don't need Q1 ... nothing to join it to Q2 with.

Properly done, written enforced standards won't prevent someone from trying something new, but a process outside the standards should be approved for use. For example, we have a standard...

While researching this, I found out that the default replication process is to split it up into multiple single-row inserts. This behavior is a problem for us. Instead...

Heh... see what I mean? Couple hours went by for the original post... 10 minutes after the working table and data was posted in executable form, WHAM! Two...

Not a problem... but you really have to get in the habit of making things easy on me... post the Create Table statement and the Insert/Select/Union All's that are requried...

Nice and simple, pleasure to read. Well done, John! 🙂

I'd bust up the query and store interim answers in a Temp Table instead of doing such a large group by... especially since the GROUP BY is to support 1...

You bet... the columnname > '' keeps out Nulls and Blanks and still allows an index to be used.

Is the handheld VARCHAR(MAX) capable or VARCHAR(8000) capable? Will the "commands" fit all in a VARCHAR(8000)? Might be able to plow up an old trick or two in...

By "Yes", I meant yes, I know a good reference... it starts with your code... I wanted to see your trigger to see if I could help.

The trigger you posted...

Heh... guess that's what they call it now... we used to call it a "software training aid". 😀 The bat I kept at my desk was the "hardware...

If I remember correctly, NOT EXISTS can actually be a bit faster in the presence of the correct index. Still, it uses correlation which is hidden RBAR.

Correct...