Database

SELECT *
FROM dbo.Table
WHERE ((CAST('5/6/2006 5:08:00 AM' AS DATETIME) > StartDateTime)
      AND (CAST('5/6/2006 5:08:00 AM' AS DATETIME) < EndDateTime))

DotNetDominator wrote:

My Query is Long and involves join of two table. But, I found this perticular area where problem lies. I do not understand why it is not comparing with time. I want it to compare with date as well as time.

select 28.50 - ROUND(28.50 * 0.25, 3)  returns 21.375 (which will round up to 21.38)
select Round(28.50 - ROUND(28.50 * 0.25, 3),2) returns 21.38 (rounds up to 21.38)
If the precision in the rounding is chaged to 2 for the 'price*percent' term:
select 28.50 - ROUND(28.50 * 0.25, 2) returns 21.37
select Round(28.50 - ROUND(28.50 * 0.25, 2),2) returns 21.37

myNameIsRon wrote:

It looks like I shouldn't use ROUND, in my SQL because I'm wanting cash register type of rounding (always round up). It's too bad they don't have parameter options to select the type of rounding you want.

select Round(1.5,0,0)  -> 2.0 round up .5+
select round(2.5,0,0)  -> 3.0 round up 2.5 and greater
select round(2.4,0,0)  -> 2.0 round down 2.0 to 2.5 exclusive
select Round(1.5,0,1)  -> 1.0
select round(2.5,0,1)  -> 2.0