Applying SP1 has resolved the problem

Thanks everyone

Its definatly how data is being interprated as I am not returning any data from databases in the example above.

The only difference I can see on the machine is the...

Thanks for that, was hoping to do it as one bit of SQL but can do it that way.

cheers for your help

regards

Tom

Looks like the forumn deleted my XML from previous post!

Attachment uploaded as requested, saved as .txt as forum does nto allow uploading of .xml types.

regards

Tom

Doh - Thanks