Here is the sql that I am currently using.

open tranno3

fetch next from tranno3 into @ejtranno

while @@fetch_status = 0

begin

select @strXML = tranxml

from ejsummary

where ejtranno = @ejtranno and lower(transactioncode)in ('tlrtmtravelck1', 'tlrtmtravelck2', 'tlrtmtravelck3',...