Viewing 5 posts - 1 through 5 (of 5 total)
I was investigating the thought process on the 2nd query (using row_num) and I was impressed how Lynn came up with the grp field "TN - row_number() over (partition by...
August 28, 2012 at 1:55 pm
Thanks Lynn:exclamationmark: Kudos.
August 28, 2012 at 12:58 pm
I'm using SQL 2008. I tried the 3rd version and it works too. Which version do you recommend the 2nd or 3rd one specially dealing hundreds of thousand records? Thanks.
August 28, 2012 at 12:51 pm
Lynn,
I tried your second query and it works perfectly. Great work. Will I run to a maxrecursion with this too? What is the max data for the maxrecursion happens? I...
August 28, 2012 at 12:40 pm
I tried your query but it came out like this. The 3rd row is not correct.
TNID TNMIN ...
August 28, 2012 at 11:15 am
Viewing 5 posts - 1 through 5 (of 5 total)