SELECT @CloneOfferIDs=STUFF((
SELECT ','+CONVERT(varchar(10),OfferID)
FROM OfferPubInfo
WHERE ParentOfferID=@OfferID
FOR
XML PATH('')),1,1,'')