You've got AchieveLevel in the Group By. That in turn impacts which records contribute to the SUM() at each AchieveLevel.

Your formula is conditional, based on column AchieveLevel:

,'TeamSalesAmount' =

...

A bookmark lookup is not necessarily a bad thing - it indicates a non-clustered index is being used, which may be preferable to a table or index scan.

In this case,...

A screen capture by itself is not sufficient to provide feedback:

1) The plan when displayed in QA has context-sensitive windows that pop up over each step - these aren't captured...

I believe it's confusion regarding the data column in the table, versus the column alias in the query:

SELECT Convert(Char(15),LastUpdate,106) as LastUpdate..

...

ORDER BY LastUpdate desc

The 2 "LastUpdate" references above are...

Your code comments state this:

>>get the Client_PK_ID value from tbl_Clients_ClientBasicInformation based on value of ClientNumber

But you're not "getting" the Client_PK_ID. You're selecting the column, but not assigning it to anything.

If...

>>Heh... I'm thinking that's not quite true, PW... see David Jackson's post. Only limit is the 8K barrier in SS2000.

Right, it is dynamic, but it doesn't avoid a cursor...

With SQL2K, the only way to avoid cursor (or 'hidden' cursor in a function) is to accept a non-dynamic query where the number of lines of text queried is capped.

Here...

Why are you resorting to a RANKing function, period ?

Do you have cases where 2 records are tied based on SSN and Date ?

Typically this would be a join to...

>>If you are on 2000 you could use select into with column identity.

That is how I would do it on SQL2K, but if and only if, there is no...

>>Arithmetic overflow error converting numeric to data type numeric.

The data type is already numeric, so it's not a type conversion due to anything that IsNumerci() will help you with.

You've got...

For each GROUP of ID_1 and Version, you want to locate the MAX() Value and return that row ?

Correct ?

If so, why are you not requiring the row with...

>>if it was up to me I wouldn't even do this in the DB, I would do it in the app

And that will likely lead to an even worse situation...

>>Another one which one is faster IF EXISTS or IF NOT EXISTS...

There is no correct answer. As always ... "it depends".

Both of these contructs execute a query, and whichever...

>>Which one to compare 1'st string or integer in a where clause for better performance

It doesn't make any difference. The optimizer makes a decision based on indexes, statistics etc.

Also,...