Problem With SQL Query Not Moving Through Every Record

I was wondering if anyone could quickly identify why the query is not parsing through each line in the temp table? I am sure its something stupid and easy, but if anyone has an idea, I would greatly appreciate the help!





My results are the same row repeated exactly the same for the number of rows in the temp table.




















Declare @Topic varchar(150)


Declare @CustomTitle varchar(150)


Declare @FullName varchar(100)


Declare @starttime datetime


Declare @endtime datetime














select


TOPIC = t.TopicName,


CustomTitle = e.ssCustomTitle,


StartTime = v.StartDateTime,


eFirstName = FirstName,


eLastName = LastName,


eEndTime = ssEndTime





INTO #tmpwork





FROM


brSession e


INNER JOIN v_SessionStartDateTime v on v.ssSessionId=e.ssSessionId


LEFT OUTER JOIN Topic t on t.TopicId=e.ssTopicId


LEFT JOIN brssPresenter ep ON (e.ssSessionID = ep.prSessionId)


LEFT OUTER JOIN Personnel p on p.PersonnelNbr=ep.prPerNbr


LEFT OUTER JOIN brVirtualRoom vr ON vr.vrBriefingId=e.ssBriefingId AND vr.vrVirtualRoomId=e.ssVirtualRoomId


LEFT OUTER JOIN brLocation bl ON bl.loBriefingId=vr.vrBriefingId AND bl.loVirtualRoomId=vr.vrVirtualRoomId


LEFT OUTER JOIN location BR ON BR.LocationId=bl.loLocationId


LEFT OUTER JOIN brssDetail1 dt on dt.dt1SessionId=e.ssSessionId


LEFT OUTER JOIN Competitor c on CompetitorId=dt.dt1CompetitorId


LEFT OUTER JOIN PresentationStyle ps ON ps.PresentationStyleId=dt.dt1PresentationStyleId


WHERE


e.ssBriefingID = 11749


and((not prConfirmModeId = 0) or (prPerNbr is null))


ORDER BY ssStartTime





SELECT @Topic = Topic,


@CustomTitle = CustomTitle,


@FullName = eFirstname + ' ' + eLastName,


@StartTime = starttime,


@EndTime = eEndTime


From #tmpwork














IF (@CustomTitle is not null)


IF (not @CustomTitle = '') --correct problem of ZLS


Begin


set @Topic = @CustomTitle


End





SELECT


Topic = @Topic,


StartTime = @StartTime,


FullName = @FullName,


EndTime = @endtime





INTO #Final





FROM #tmpwork








select * from #Final








drop table #tmpwork


drop table #Final