declare @sqlstr nvarchar(max)
declare @sessions nvarchar(max)
set @sessions ='ABC123456_000001'

set @sqlstr='select e.id, e.title, e.created, e.itemcount, e.itemtotal, e.recordswritten, e.errors, e.excluded, e.partiallyexcluded, e.incomplete, e.size as SizeBytes, e.size/1024/1024/1024 as GBSize, count(d.id) as DocCount'
set @sqlstr=@sqlstr + ' ' + 'from tbldoc d right join tbledsessions e on e.id = d.edsessionid'
set @sqlstr=@sqlstr + ' ' + 'where left(e.title,15) In (' + @sessions + ')'
set @sqlstr=@sqlstr + ' ' + 'group by e.id, e.title, e.created, e.itemcount, e.itemtotal, e.recordswritten, e.errors, e.excluded, e.partiallyexcluded, e.incomplete, e.size'
execute sp_executesql @sqlstr

create procedure sp_Session_Summary @sessions nvarchar(max) as
Select e.title as Session, 
count(d.id) as SessionDocuments, 

case when sum(d.filesize) is null 
then '0' else sum(d.filesize) 
end as SessionSizeBytes, 

case when cast(sum(d.filesize)/1024.0/1024.0/1024.0 as decimal(10,5))is null
then '0' else cast(sum(d.filesize)/1024.0/1024.0/1024.0 as decimal(10,5)) 
end as SessionSizeGB

from tbldoc d
right join tbledsessions e on e.id = d.edsessionid
where left(e.title,16) In  (select item from fnSplit(@sessions, '|'))
group by e.title