<p>Oops, sorry...forgot my aliases.</p> <p> </p> <p> <p>-- Generate row numbers using a triangle join; must have a primary key and select and group by all columns</p> <p>select count(*) as RowNum, a.PrimaryKeyColumn, a.OtherColumn1, a.OtherColu...

<p> <p> <p>-- Generate row numbers using a triangle join; must have a primary key and select and group by all columns</p> <p>select count(*) as RowNum, PrimaryKeyColumn, OtherColumn1, OtherColumn2, OtherColumnN</p> <p>from Table1 a</p> <p><span> </...

<p>I couldn't get this to run on SQL2000</p>...