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...

David M.

I just wanted to let you know I that I copied the code you provided, made a few changes to see how many records rounded up and down using...

Getting nasty isn't going to get rid of me.  It is, in fact, a sign of desperation on your part.  Just answer the questions that have been posed to you. ...

Sergiy,

Honestly, I'd take you more seriously if you'd take the time to answer ALL the questions that have been put to you that you have chosen to ignore.

Mean while, the price of tea in China just went up!

Sergiy,

This is getting really rediculous.  What in the world is a 'midnight event' and if it is something that occurs at 'midnight' then it occurs at 'midnight', not 10 picoseconds...

David F.

If you still have the code you ised to test the Bankers Round function, it would be interesting to see it compared to the standard round function.  Willing to...

I know you asked this of David, however, I wouldn't care what time the order came in on, only what day.  If I have to choose based on a time,...

Actually, we didn't calculate taxes on a line item basis, but at the order level.  round(sum(LineItemAmt) * TaxRate, 2) = round(sum(LineItemAmt * TaxRate), 2).  The issue was distributing the taxes...

Know what, you win for all the wrong reasons.  I am not going to continue this inane argument with you any longer.  You aren't even willing to consider that the...

And wether the earth is the center of the universe or not has no bearing on the use or validity of the Bankers Round function.  They are not related in any...

Sorry, again, you failed to answer all my questions.

Also, your numbers were wrong: go back and read.  You collected 0.50 in taxes, and you need to distribute these amount to three taxing authorities: .250, .125, .125.  .25  +...