Fraid not.  The official line from Microsoft is that they're aware of the problem.  They're not going to fix it as that then causes problems with word wrapping and searching.

None...

Still no joy, the following string

        4.50      0.59     23.73

comes out on the report exactly as that!  However it's not shown in the designer.....

Unfortunately that's made no difference.  I don't see the ; in the text, but it's still stripping away the spaces. 

Any more ideas?

Thanks for that.

The stored procedure will have to perform an EXEC sp_executesql, as I'm passing dynamic INSERT statements.  The SP cannot be table specific.

Therefore, it would seem the INSERT is...

The SQLAgent service needs to be logged on as a user that can send email.  If the service is started under the LocalSystem account, then I would assume that it...

We use a bigint type, with the identity set to generate unique IDs for each row, and we have no problems with that - I'm not sure off your reasoning...

We replaced Crystal with RS about 3-4 months ago, and I'm happy to say it was the right move.  Whilst RS is still in beta and therefore has niggles and...

OK, my TSQL isn't the best in the world - but this took 5 minutes instead of 3.

CREATE PROCEDURE dbo.VMR_BenchMark 
AS

DECLARE @iMaxUID Int
DECLARE @iMinUID Int

PRINT 'Start Time: ' + cast(...

PINTABLE did little to improve the performance, even after several runs to ensure that the pages were residing in memory.

Which indicates to me, that SQL isn't the bottleneck here?  That's...

Thanks for your help guys,

The UID field has a clustered index, and I've tried out the view idea, and it had no performance benefit.

I'm going to give the DBCC PINTABLE...

UID is a Unique ID - which it's using to single out one record.

I would indeed appreciate any help, I still have the problem. 

Ahhhh good.  There are others out there with the same reservations. 

Thanks for the replies.  Much appreciated

What I can't get my nuts around, is the fact that it's so blinking ardous to write a SP that performs queries on a parameter driven table name......

Is it because...

It was the RetVal INT OUT on the SELECT that I was missing out on.   So close, and yet so far 🙂

Now I've just got figure out how to pass...