Viewing 4 posts - 1 through 4 (of 4 total)
Nice logic. leaning TSQL from SQL Server 7.0, I am not thinking about rank functions.
Thank You.
I would like to keep this open to get another elegant solution.
September 21, 2010 at 1:17 pm
I got a nasty solution. I don't like this as this is time consuming with large data. I would like a set based solution.
DECLARE @MyRelations TABLE
...
September 20, 2010 at 9:59 am
ColdCoffee (9/20/2010)
Why would xyz come to 2 and abcde be at 1 ?
It can be other way around too. abcde are related and we give an id then we see...
September 20, 2010 at 9:56 am
sp_spaceused tablename will give the no of rows - much faster
July 2, 2004 at 6:20 am
Viewing 4 posts - 1 through 4 (of 4 total)