dwain.c (2/5/2014)
SQLRNNR (2/5/2014)
Nice solution.Actually, I am not too proud to admit that solution stunk up the house! Not sure what I was thinking there.
Well, it worked with limited information. Besides, tuning the query could have been a good exercise for the OP.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events