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