Instead of creating a temp table and inserting rows into it, just create a CTE and select values into it. Your temp table is removed now..?

You'll have to go match by match or else use cursors

First: select all rows with same column values

Hold a suffix variable

update each row and increment suffix when updating

I guess Convert(Len()) does it all

Ex:

U can also use sql server 2005's with clause.

See Sql server 2005's Common Table Expressions for more.

First:

Define a function that maps employeeID to col1's value.. If you can create such a function all you have to do is:

Secondly: Updating data for...

WIth temp table and Row_Number()

Row_Number() numbers the rows on the basis of the "order by.." as specified by the over clause.

select Row_Number() over (order by id) as No,*...

Hi SSC!

If the row you need is at number 40 when the result is in ascending order, u don't need to sort the rows in descending order 🙂

Also, using a...

What u can do is:

Remember the order by clause determines your ans...