[dba-SQLServer] Thanks for the help

Thanks Arthur, worked like a champ.  

There are times I feel (and appear, I am sure) so stupid.  I was so focused
on getting the WITH clause functioning that I completely missed the * down
below.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Monday, May 14, 2007 10:23 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Thanks for the help

Just replace your SELECT * part of the statement with an explicit list of
the columns you want. Leave out the Row_Number() one and include all the
others.

hth,
Arthur