General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Report By Date range, Grouped into days
SELECT
Ksnr as 'Cust No', Artnr as 'Intier No', count(*) as Quantity
FROM
JITWork_Archiv
WHERE
(NOT (Sequenznr LIKE '0%')) AND (Letzte_Prioritaet = 11) AND (Zeitstempel BETWEEN CONVERT(DATETIME, @StartDate, 102) AND CONVERT(DATETIME, @EndDate, 102)) and (NOT( Artnr LIKE 'Dummy'))
Group by Ksnr, Artnr
This works 100%, however I need the result to be by day between 21:40:00 hours and 21:39:59 hours. for a month(Given within the query).
Can someone help?
Thanks
Brian