I like Jeff's approach here, but my preference when moving large amounts of data from table A to table B on a different database is to do it outside...

That is the...

• This reply was modified 3 years, 9 months ago by  LinksUp.

From Donald Knuth & Sir Tony Hoare:

Computer Programming as an Art (1974)

1974 Turing Award Lecture, Communications of the ACM 17 (12), (December 1974), pp. 667–673

The real problem is that programmers have spent far too much...

You are mixing some keywords from the SQL case statement with T-SQL. Try this instead:

if condition1
   SET @Max2 = 1
else if condition2
   SET...

If fails because you have '9,T' in the column CPTFirst but you are only checking to see if CPTFirst is EQUAL to 9,D,G or H. I think you will need...

You just want ID's that are all W2's? Is that correct?

Is this what you are trying to do or is it more complicated than this?

This is a possible solution.

with amtsI
as
(
 select amountI, name, row_number() over(order by amountI desc) rowNum
 from test
)
select *
...