Thanks, I had not found that one. I did read this one as well:

http://support.microsoft.com/kb/828526

But I'm not knowing how to plug the rows and columns into the equation, and...

Thanks Daniel,

I would like to be able to use a calculation in a report textbox. The main problem I'm having right now is the Excel GROWTH formula. I've not found...

Seems the left out rows problem may have been an SP issue. When experiencing the missing row problem we were running SP1. Since we have installed SP3 (SMS 2008), we...

Is this because SQL Server stores dates as a numeric value? Then CONVERT to VARCHAR() would cause an implicit conversion?

I frequently use SELECT CAST(FLOOR(CAST(<yourDateHere> AS FLOAT)) AS DATETIME)

Interestingly, rounding happens near midnight. The following returns '2010-04-08 00:00:00.000':

DECLARE @Date DATETIME = '2010-04-07 23:59:59.999'

SELECT CAST(FLOOR(CAST(@Date AS FLOAT)) AS...