Hi,

I have a solution.

Due to the select working for the conversion, I ended up selecting into a #temptable, joining that on to the query and then using that in the...

Hi,

Thanks for the help. Unfortunately it seems that this worked fro parts of the script (multiple reports are run) but for one last bit it didn't.

Essentially it is:

select *...