I'm having a little trouble understanding what you're asking for? Say a user selects a start date of 08-23-2013 and an end date of 08-28-2013, are you looking for data between '08-23-2013 07:00' and '08-28-2013 07:00'?
If so how about something like:
SELECT Heat_Number, Heat_Idx, Furnace_Idx FROM HeatData
WHERE Turn_Date BETWEEN DATEADD(hh, 7, @Start_Date) AND DATEADD(hh, 7, @End_Date)
No comments:
Post a Comment