try this (not tested)

SELECT 	meetings.BeginTime as ScheduledStart,
	    coDept.deptDesc,
	    ltrim(rtrim(dbo.coPer.LastName))+', '+rtrim(dbo.coPer.FirstName) as Assisting,
	    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.coPer    ON dbo.coPer.coPerID	  = dbo.meetings.AssistID
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)
UNION ALL
SELECT 	meetings.BeginTime as ScheduledStart,
	    coDept.deptDesc,
	    ltrim(rtrim(dbo.coPer.LastName))+', '+rtrim(dbo.coPer.FirstName) as Assisting,
	    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.coPer    ON dbo.coPer.coPerID	  = dbo.meetings.Assist2ID
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.assist2ID>0)
ORDER BY Assisting

>Top 100 percent was for a subquery I was trying, no need for it currently.
>
>Below is the sample data the current query (modified for width) returns
>

>ScheduledStart       DeptDesc   Assisting1                Assisting2                PrimaryProcedureDesc
>-------------------- ---------- ------------------------- ------------------------- ------------------------------
>Sep 20 2005 12:30PM  CATH LAB                             EGBE, PATRICK             LEFT HEART CATH
>Sep 12 2005  9:00AM  GIDU                                 OKOLO, CHARLES            COLONOSCOPY WITH FORCEP POLYPE
>Mar  9 2005 12:30PM  SURGERY    MCCARTER, FREDA                                     RADICAL PROSTATECTOMY
>Feb  4 2005 11:00AM  SURGERY    ASCHE-CROWE, PEARL, PA-C                            RIGHT AV FISTULA WITH VEIN TRA
>Feb 14 2005  7:30AM  SURGERY    ST. JULIAN, TRACEY                                  EUA / TOTAL ABDOMINAL HYSTEREC
>Mar  7 2005  7:30AM  SURGERY    ST. JULIAN, TRACEY                                  LAPAROSCOPIC TUBAL LIGATION
>Feb  8 2005  7:30AM  SURGERY    TUCKER, GEORGE                                      ABDOMINAL MYOMECTOMY / MATT FL
>Feb 14 2005  2:00PM  SURGERY    ST. JULIAN, TRACEY                                  DEBRIDEMENT OF VULVA / DR SIMM
>Feb 28 2005  7:30AM  SURGERY    DURALDE, FERNAND          ST. JULIAN, TRACEY        TOTAL ABDOMINAL HYSTERECTOMY /
>Feb 23 2005  1:00PM  SURGERY    COLON, LOREN              MONDAY, LAWANNA           CLOSED REDUCTION METATARSAL FR
>Mar  1 2005  7:30AM  SURGERY    ST. JULIAN, TRACEY                                  TOTAL ABDOMINAL HYSTERECTOMY
>Feb 25 2005  7:30AM  SURGERY    BURTON, AIYANNA           ST. JULIAN, TRACEY        SUCTION DILATATION AND CURRETT
>Feb 24 2005  1:00PM  SURGERY    NURUDIN, A. IBN                                     LAPAROSCOPIC APPENDECTOMY
>Mar 14 2005  8:30AM  SURGERY    ST. JULIAN, TRACEY        CARMEN, DARREL            EXPLORATORY LAPAROTOMY
>Mar 14 2005 10:00AM  SURGERY    ST. JULIAN, TRACEY                                  DIAGNOSTIC LAPAROSCOPY
>Mar  4 2005  2:15PM  SURGERY    ST. JULIAN, TRACEY        MATTHEWS, ROLAND,         TOTAL ABDOMINAL HYSTERECTOMY B
>Mar 22 2005  7:30AM  SURGERY    PATEL, VIJAY              SIMMONS, LORENZO          TUBAL ANASTAMOSIS
>

>
>St.Julian, Tracey is an example who is both an initial and secondary. So I need the final result set to list all his cases together where he is one or the other. I would prefer to have one field come back called assisting no matter if they are the initial or secondary.
>
>Kirk