Share
Report
879I hope to assist to make report to call sales days of the month
from 6:00 until 6:00 the next day by the month
To be the result of the report, such as the attached form
-----------------------------------------------------------------------
select @time1 = '2015-07-01 06:00:00'
select @time2 = '2015-08-01 06:00:00'
result
| Date | TOTAL |
| 01/07/2015 | 2234 |
| 02/07/2015 | 2245 |
| 03/07/2015 | 2256 |
| 04/07/2015 | 2267 |
| 05/07/2015 | 2278 |
| 06/07/2015 | 2289 |
| 07/07/2015 | 2300 |
| 08/07/2015 | 2311 |
| 09/07/2015 | 2322 |
| 10/07/2015 | 2333 |
| 11/07/2015 | 2344 |
| 12/07/2015 | 2355 |
| 13/07/2015 | 2366 |
| 14/07/2015 | 2377 |
| 15/07/2015 | 2388 |
| 16/07/2015 | 2399 |
| 17/07/2015 | 2410 |
| 18/07/2015 | 2421 |
| 19/07/2015 | 2432 |
| 20/07/2015 | 2443 |
| 21/07/2015 | 2454 |
| 22/07/2015 | 2465 |
| 23/07/2015 | 2476 |
| 24/07/2015 | 2487 |
| 25/07/2015 | 2498 |
| 26/07/2015 | 2509 |
| 27/07/2015 | 2520 |
| 28/07/2015 | 2531 |
| 29/07/2015 | 2542 |
| 30/07/2015 | 2553 |
| 31/07/2015 | 2564 |
*This post is locked for comments
All responses (
Answers (
