What a great article - hands down.  Thank you.  I too am working on something similar.  I was using word-counts and Loreum Ipsum replacements.  I think this approach is far...

I concur with GPolelo.
Another thing about SP_HelpText - and maybe its just me or some weird config that I am rolling, but SP_HelpText, when printing to GRID and copy/paste...

I have been spooked by OVER() and PARTITION for too long now. You made it EZ for me - especially by using a VERY real world example. I...

Thank you Mr. Factor!

This article was one of the better reads I have had in recent memory.

Regarding the FKRelationshipsFor procedure, Line 59 there is a bug whereby I think you...

Nice article! I like how you incorporated the tally table logic - "RBAR IS BAD". I like the holiday logic too using "merge". Someone already suggested it...

In retrospect, I do not have full rights to fire off all the SYS tables - That is more than likely my issue.

eg.: sys.dm_tran_database_transactions

I know there was a...

Interesting article. I could really use something like this. I attempted to run the TSQL and it blew up:

Msg 102, Level 15, State 1, Line 28

Incorrect syntax near...

Great article. Thanks for sharing.

-Mike

I always get a warm and fuzzy feeling when I see XML and TSQL so kudos for your solution. Since you are using XML, you can also pass in...

WOW. What a great read!

WOW

I have not seen this article in a long time. IT is pretty cool to see that it is still out there.

I had a bit of problem as well with "invalid object name #temp" AT FIRST - wierd.

I changed it to #ttt and it worked right away. Dropped #ttt and...

Bravo! What a great catch. You have my 5 star vote.

-Mike

Scott:

Excellent article! Your insight to the configuration issue is spot on and brings with it a tremendous amount of merit.

When you mentioned that you started with the...

Duncan Ray could not have said it better.... "gold", "diamonds", "debris", " breath of fresh air".

Thanks a million.

-Mike