>select det.DateValue, > det.RoomID, > det.SchedItemID, > det.TimeValue, > det.SlotOpen, > dateadd(mi,det.TimeValue,NormalizedDate) as NormalDateTime >from >( >SELECT dbo.DateRoom.DateValue, > dbo.DateRoom.RoomID, > dbo.SchedItem.SchedItemID, > dbo.SchedItem.TimeValue, > dbo.SchedItem.Meetingnumber, > dbo.SchedItem.SlotOpen, > dbo.SchedItem.ResourceType, dbo.SchedItem.ResourceID, > dateadd(dd,DateValue,'01/01/1900') as NormalizedDate >FROM dbo.DateRoom INNER JOIN > dbo.SchedItem ON dbo.DateRoom.dateRoomID = dbo.SchedItem.DateRoomID >where DateValue = @nStartDate >and RoomID IN ( > SELECT distinct dbo.corooms.roomid > FROM dbo.coproc INNER JOIN > dbo.coProcRoomGrp ON dbo.coproc.procid = dbo.coProcRoomGrp.procID INNER JOIN > dbo.coRoomToGroup ON dbo.coProcRoomGrp.coRoomGrpID = dbo.coRoomToGroup.coRoomGrpID INNER JOIN > dbo.corooms ON dbo.coRoomToGroup.RoomID = dbo.corooms.roomid inner Join > dbo.coProcStartTimes on coProc.ProcID=coProcStartTimes.ProcID > WHERE dbo.coproc.procid = @tiProcID and dbo.coRooms.Isactive=1)) det >where TimeValue >= 360 >order by SchedItemID > >