Hi Lowell, thanks for your help so far. Yes the code works like this, but when I add the email part to send, it's still only the width of...

Sorry Lowell, I use that part at the end....heres the full script...I'm still not quite clear what I need to code when using this format.....sorry for the headache!!

DECLARE @tableHTML ...

Thanks so much for your help Lowell...almost there i think. Still getting syntax errors. My code is a little different from yours but I've added where I think...

Thanks for that useful input P!

Rgds, Simon

Thanks for your replies both.

Yes I had read that everything was contained within the DB so that when you restore the DB & Keys you should be able to use...

Natraj, thanks for your time on this, it works very well. Many thanks for that

Rgds, Simon

Just fyi....I changed the parameter name so it wasn't the same name as the column it was retrieving data from and now it works ok ?!!?! Another RS idiosyncracy??

Thank you for this very useful info. I've managed to fix my issue another way (good old RS) but your info will go straight into my toolbox! Thanks again

Springtown - Thanks, but thats exactly what I did and got the same message....see last paragraph re DS2 I set up. I also tried it using the Region column...

Hi, I just found this whilst searching my issue (Just posted today), I've been told to do this before too and it still doesn't work?? I'd appreciate it if...

Thanks for trying to help Sean but I still dont really understand......whats that 8k table you refer to that your joining on ??? Also I don't want to...

Cheers for that Sean I appreciate the info, although I've no idea where to start with that and what would need coding where!?

I've since done more tests and seen that...

Hi, really sorry that I haven't sent my thanks earlier. Very grateful for your answer and links. About to build a VM to 'play' with next week. Thanks...

Thanks for that. Do you know where this report will be?

Doh, what a schoolboy error on my part, yes I had renamed 'sa'! Thanks so much for the info re this and the uninstall notes. Now the repair...