Select meetproc.procID,coPerID,
         (Select description from dbo.coProc where dbo.coProc.ProcID=meetproc.ProcID),
         case sysorder when (Select min(sysorder) from dbo.meetproc mp where mp.meetingnumber=meetings.meetingnumber) then cast(1 as bit) else cast(0 as bit) end as isPrimary,
         meetings.meetingnumber,
	 meetproc.Sysorder,
         (Select specdesc from dbo.coSpec where dbo.coSpec.SpecID=meetings.SpecID),
         ltrim(dbo.Get_FirstSurgeonOnCase(meetings.meetingnumber)),
         (Select dcode from dbo.coProc where dbo.coProc.ProcID=meetproc.ProcID),
	 begintime,meetings.EnterOR,meetings.ExitOR,meetings.ProcStart,meetings.ProcEnd
from dbo.meetings inner join
     dbo.meetproc on dbo.meetings.meetingnumber=dbo.meetproc.Meetingnumber
where meetings.deptID=@DeptID
and   meetings.iscompleted=1
and   meetings.begintime between @begintime and @EndTime
order by meetings.meetingnumber,sysorder