...FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')
print @cols;
set @qry = '
select * from
(
SELECT DISTINCT dbo.WalkItems.ItemCode, sbr.itemdata.description,SUM(dbo.WalkItems.Quantity) AS Total, convert(char(10),dbo.PickWalk.BookingDate,121) as dt
FROM...