What answer is wrong?  The one that states It Depends or the one where this has no relevance to discussion about rounding.  You talk in half sentences and abstractions that...

The answer to your question: It Depends.  It depends on what you are tracking, why you are tracking it, so you can determine the approriate way to track it.

So that...

And you have been asked what does this have to do with rounding?

You obviously don't know how to do anything but attack people that disagree with you.  And your twisting of the phrase "minor in mathematics" is so tiring.  All that means...

I'll check with my co-worker. He does a lot of our SSIS package development and we have talked about standards, but I don't know if we ever got to the...

That version of SQL Server 2005 does not have SP 2 installed.  In the @@version, the service pack 2 mentioned, I believe, is for the OS you are running on. ...

Sergiy,

You must be living in your own world.  Anyone who takes the time to read all 126+ posts will come to the conclusion that we all gave up on you. ...

As another of the 5, here are my results of ten runs (sorry if it doesn't fit on one screen or wraps):

InitialTotal                            ConvergentTotal                         Traditionaltotal                        TotalRecords ConvergentCountDown ConvergentCountUp ConvergentCountSame ConvergentDifferene TraditionalCountDown...

Forgot about DATABSEPROPERTYEX, another good catch.

Any SSIS packages in 64-bit environment that using scripting will need to be precompiled before they are deployed.

Its been there.

No.  It is not.  I have installed SQL Server 2005 on several servers that do not have IIS installed.

Start with this:

--create function dbo.fn_BucketNum(@InDate datetime)                                                                           

--returns smallint                                                                                                             

--as begin                                                                                                                     

--    return (select isnull(nullif((datepart(hh,@InDate) * 12) + ceiling(datepart(mi,@InDate) / 5.),0),288))                   

--end                                                                                                                          

declare @tablenums table (bucket smallint)                                                                                     

declare @shiftdata table...

It is my understanding the Reporting Services is the only component of SQL Server 2005 that requires IIS.

I have installed SQL Server 2005 on several production and develpment servers and...

Or you can do this in the where clause:

(status & 512) = 512

This will be true for any status value where the database is offline without having to figure out...