chris-860960 (11/30/2010)
Just switched to WayneS' non-RBAR function. Now that's FAST!
It's not "my" function - it comes from Jeff Moden. It's just what is in use around here, with little tweaks here and there to make it as fast as it possible can be.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes