autoexcrement (12/9/2010)
So, all that remains to be explained is...are you guys some kind of freaking sql wizards or what?
But of course! :w00t:
What hope is there for us normal people with you lot lurking around? 🙂
Well, you see, that's the whole point. By lurking around, you are hopefully acquiring this knowledge transfer that's going on. Reinforce it by practice (aka, help out here on the forums). Don't get upset if what you come up with isn't "the best"; instead, learn from it. (If you look into the forums here, you'll find that most learning really goes on after the first answer was posted, with even well-versus folks learning from others. Even "the guru himself" (Jeff) recently learned a new safety check that can be applied to the infamous "quirky update" to guarantee things were processed correctly. (The learning never stops.....)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes