The data was by day and growing vericaly down the page with only one hour showing on the horizontal line. What I resolved to do was in a view:
select CONVERT(char(10), ORDER_DATE, 101) As Order_Date, DATEPART(hh, ORDER_DATE) As Order_Hour, COUNT(1)As Order_Cnt, SUM(ORDER_TOTAL) As Order_Sum
FROM...
I need to have a count of items per hour through the day in a row and a colume by day
12/1 12/2 12/3
12am 1 2 5
1am 0 1 3
2am 0 0 0
...
8am 9 12 15
...
2pm 6 8 9
I put the date in the row ascending by hour and the...
I am getting the message "No Export DLLs Found" when I try to export a file. The program was working find until a coworker deleted some programs they had loaded when they left the company. I have reloaded Windows98 and repaired and then reloaded Office2000 without any success. Any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.