ok - i'll give that a whirl and let you know how I get on.

ok - i'll post the last part of the procedure .... but even worse now that I have created nvarchar(100) is that the padding is now much bigger (my guess...

It seems to me that whatever the size of the columns regardless of the data within them it outputs that size.  e.g. if i have varchar(10) and the field is...

Hi

I have sa on the server and I can change the procedure.  I have tried rtrim on the final select, I have also tried outputting the results to a new...

Hi

Already tried rtrim and it doesn't have any affect.

The query is just calling a stored procedure called systemwatchrun and I do have the rights to edit the SP.

I've also just tried...