>SELECT top 100 percent > meetings.BeginTime as ScheduledStart, > coDept.deptDesc, > isnull((select ltrim(rtrim(dbo.coPer.LastName))+', '+rtrim(dbo.coPer.FirstName) > from dbo.coPer where coPer.coPerID=meetings.AssistID),' ') as Assisting1, > isnull((select ltrim(rtrim(dbo.coPer.LastName))+', '+rtrim(dbo.coPer.FirstName) > from dbo.coPer where coPer.coPerID=meetings.Assist2ID),' ') as Assisting2, > isnull(dbo.Get_PrimaryProcDescByMeetID(meetings.meetingnumber),'No Proc. Asgn') as PrimaryProcedureDesc >FROM dbo.patients INNER JOIN > dbo.meetings ON dbo.patients.patientid = dbo.meetings.patientid inner join > dbo.codept ON dbo.meetings.deptid = dbo.codept.deptid INNER JOIN > dbo.corooms ON dbo.meetings.roomid = dbo.corooms.roomid >where meetings.begintime between @ltQueryFrom and @ltQueryTo >and meetings.iscancelled=0 >and meetings.isblock=0 >and meetings.RoomClosed=0 >and (meetings.assistID>0 or meetings.assist2ID>0) >