GilaMonster (5/19/2015)

---

Pretty much. By adding one day to the end of the range, you're getting all the date-times on that day, right up to just before midnight at the end...

GilaMonster (5/19/2015)

---

cms9651 (5/19/2015)

---

GilaMonster (5/19/2015)

---

Declare @RangeStart varchar(20) = '01/01/2015 00:00:00', @RangeEnd varchar(20) = '01/01/2015 00:00:00' -- these come from the application

WHERE toDate >= CONVERT (datetime,@RangeStart,103) and toDate < DATEADD(dd,1,CONVERT (datetime,@RangeEnd,103))

Even...

GilaMonster (5/19/2015)

---

Declare @RangeStart varchar(20) = '01/01/2015 00:00:00', @RangeEnd varchar(20) = '01/01/2015 00:00:00' -- these come from the application

WHERE toDate >= CONVERT (datetime,@RangeStart,103) and toDate < DATEADD(dd,1,CONVERT (datetime,@RangeEnd,103))

Even if you...

Thank you.

In the doTable in...

GilaMonster (5/19/2015)

---

cms9651 (5/19/2015)

---

But I have tried this syntax in sql query and the output is always empty:

AND doTableDate BETWEEN CAST('01/01/2014 00:00:00' AS DATE)

AND CAST('01/01/2014 00:00:00' AS DATE)

....

AND doTableDate >= CAST('01/01/2014...

GilaMonster (5/19/2015)

---

Well the problem has the same form, same cause and same solution as the one you discussed in there.

Your upper and lower bounds of the between are the same....

Thank you Sir.

Not Sir, is a...

Thank you very much for help.

ChrisM@Work (5/14/2015)

---

cms9651 (5/14/2015)

---

Hi all, hope in your help.

I have problem to execute query with interval date.

If try this query I don't have problem and the output is correct:

SELECT * FROM...

I tried this:

SELECT

case when ([ENER1] + [ENER2]) / 1000000 > 1 then

cast(Cast(Round(( [ENER1] + [ENER2] ) / 1000000, 2) AS NUMERIC(9, 2)) AS VARCHAR(10))

else

'0' + cast(Cast(Round(( [ENER1] + [ENER2]...

:doze:

7.89

3.07

1.78

1.68

1.59

1.36

1.09

00.97

00.92

00.82

00.81

00.79

00.79

00.77

thank you, is better but still without a leading zero before the decimal point ...

7.89

3.07

1.78

1.68

1.59

1.36

1.09

.97

.92

.82

.81

.79

.79

I tried this but :

SELECT

ROUND((

[ENER1] + [ENER2]

) / 1000000,2) AS pG

FROM

[dbo].[doTable40]

WHERE

(

[ENER1] > 0

OR [ENER2] > 0

)

GROUP BY

[ENER1],

[ENER2]

HAVING

YEAR (MAX([theDate])) >= YEAR (GETDATE())

ORDER BY

pG DESC;

7.89000000

3.07000000

1.78000000

1.68000000

1.59000000

1.36000000

1.09000000

.97000000

.92000000

.82000000

.81000000

The numbers of SUM are correct.

My question is in output of this SUM:

7.88528800 ====> I need 7.89

3.06978700 ====> I need 3.07

1.78070800 ====> I need 1.78

1.67984500 ...

1.59402600 ...

1.36468000 ...

1.09013200 ...

.96727700 ...

many thanks for help !!!!