First you would have to find a way of eliminating those duplicates that you mentioned.

For that, you need to run a SELECT statement to catch records where the same value...

Thanks very much for the help, guys - much appreciated.

-Simon Doubt

Try DECLAREing your variable before your IF statements.

Then, SET in in the nested logic.

Try BOL for the difference between IF and IIF - it's a great resource.

Download here:

http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&displaylang=en

-...