its easy to combine and collect data between two dates but my problem is quet difficult and amazing as well. i have to collect data from 4 differet days which are in sequence means first from 6am to 6pm second day 6am to 6pm thirdday from 1800
to forthday 6am and from forth day 1800 to fifthday 6am meam collection of data for one shift. presenly i am calculating data from this query but only for one day either day or night. and seperatly. but on four pages but i want to collect all out
put on one page i know its not difficult for my expert brothers who will hepl me indeed.....................eric
my presend query is this.................
-- @EndDate Datetime
SELECT TOP (100) PERCENT COUNT(*) AS Quantity, dbo.System.Type, dbo.Room.RoomID, dbo.GetLineLU(RoomID)As RoomWrkIDID, dbo.GetDayDate(dbo.Room.Datestamp) As "Day_Date", dbo.GetShift(dbo.Room.Datestamp) AS "Date|D/N"
FROM dbo.Room INNER JOIN
dbo.System ON dbo.R
View Complete Post