Hey Paul
A little side question:
You work with this row-number function:
ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
Is there any difference to this:
ROW_NUMBER() OVER (ORDER BY (SELECT 1))
Sure, the results are equal but do you know if they work equal? Both work with constant expressions but my thought was NULL is always something special.
Cheers
Flo