And, PLEASE... remember that the MVP award is a "Service Award".  Although a great many (for example) SQL Server MVPs (such as the author of this article, Kathi Kellenberger and...

Anything that you write for code can be changed by anyone with SysAdmin privs.  No pun intended, but if you want the STIG to "stick", you're going to have to...

It has no dependencies because it sorts the values again (as I understood the q).  If you have a lot of data that has already been sorted, that may...

This is one of the reasons why I use RAISERROR('Section: %s Duration(ms): %u',0,0,@SectionName,@Duration) WITH NOWAIT: in virtually ever section of stored procedures I write to write section name, duration and,...

I have a standing offer on LinkedIn to promote anyone looking for work. I'll double down on that for Threadizens. I can actually say I know that you know...

Step 1, get a much nicer picture for linked in and smile a little bit.

Step 2, update your recent history and make sure you list your major accomplishments!

p.s.  And what I was getting at is you could do your RowNum at the same time if you really need it but I'm thinking that sorting by ID is...

Ok... give this a try and let me know if this does the trick or not.  I left your RowNum in there instead of sorting by the ID.  I think...

Ah.. ok.  Thanks.

There are definitely rows without dupes. And in the full dataset that's the vast majority.  Any records that have a 1 rownum, (which are not followed by a 2...

And, to be sure, you said the following columns are what you used to identify dupes?

,ldate

,RIN#

,Provider_Name

,License#

,pick_up

,drop_off

,Modifier

,CALCULATED_FARE

If that's true, then there's trouble in paradise because there is no RIN# or License#...

Oh no... I'm NOT saying that Scotts...

This is what I'm trying to get at.  If you used the old standby of using ROW_NUMBER() to find dupes and...

try adding firstrow option to start data at row 2 - row 1 is headers so it would blow the size of the columns you defined on that table.

Actually, I used all of the values listed in the table as the values which identify duplicates (those are what the Row_Number used to create the RowNum column).  Does...