No needs,
just check my answer :-)
It is for 2000.
I hate subqueries in Field section :-) They slow down the whole query, because the are executed for every row.


>What SQL Server version you're using? I re-read your requerements and slightly adjusted my original code (using ROW_NUMBER()) I have ideas how to make it work for SQL Server 2000 - do you need me to think in this direction or you're all set already?
>
>>The case seems to work well.
>>
>>Thanks
>>
>>

>>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
>>