Posted by Maury on 07/26/06 11:17

Hugo Kornelis ha scritto:
> WITH DeDupe (Id, rn)
> AS (SELECT Id, ROW_NUMBER() OVER (PARTITION BY date, idsens ORDER BY Id)
> FROM mytable)
> DELETE DeDupe
> WHERE rn > 1;

This is very very interesting (I didn't know these commands)
I have to search a good reference
or stored procedure language manual
for sql server 2005
some hints?
thanks!!!!
M.A.

[Back to original message]