Viewing 2 posts - 1 through 2 (of 2 total)
If you are using SQL Server 2005 then there is a new ranking function that will help you. If you are using SQL Server 2005 then I have an...
October 30, 2007 at 6:26 am
#746597
Try this technique. It does not use an actual temp table but a 'dynamic or inline view' which is basically a table in memory.
SELECT COUNT(SUMS.SumFast), COUNT(SUMS.SumGood), COUNT(SUMS.SumSlow)
FROM (
...
October 11, 2007 at 6:45 am
#741169