Thanks guys, here is some code. As you'll see its part of an overall extract not just a one off query in itself..

SELECT a.trans_code

,asize.adjustmentsize_id

,'LG'

,s.movement_type

,s.store_code

,...

Hi thanks for that but I cant see that the result of that query is the same as I need. Have you an actual example of what I need please....

Christopher, that works a treat!! Thanks v much guys.

I've searched the cross tab reports and found nothing similar, a precise example would be much appreciated.

ZeyNep, I've also got a little further with your query but whichever way I...

SQL2000, I put the question in the 2000 forum as I suspected 2005 would have an easier method. Useful tip anyway though 😉

Thanks Chris but isn't that SQL2005 only ?

Sorry, I should have confirmed that...

When the highest d.line_type within a transaction group is 2 THEN return 'Return Order' FOR ALL THE ROWS THAT MAKE UP THAT TRANSACTION...

Thanks for your help on this guys but please bear with me as cross tabs is something I've not dealt with before.

ZeyNep, unfortunately I cant get this to work...

Thank you very much for your replies guys, all of them have assisted in this issue and my general t-sql development. Ten Centuries, thanks for the additional tip, you...

Thanks for that guys. The first column isn't a key its just called key, like I say there is no PK on the table. I think this has...

Hi Andras, thanks for your input. Am testing this now as I'm not 100% sure if its giving quite the correct result (as theres other things I need to...

Thats interesting, I have both set on about a dozen servers and all are fine with it. I didn't think the OS would allow anything else running on the server...

Hi, just out of interest, why haven't you set the 3gb switch on the new server?