OPRAG-OPREG

Select multiple rows data then show in one row this is how to do that : select DATA=stuff(( select top 2 '/' + supplierpicname from TABELSUPPLIERCONTACT where supplierid = 'SUP006' for XML path('')),1,1,'') select DATA=stuff(( select  top 2  ' / ' + supplierpicname from TABELSUPPLIERCONTACT where supplierid = 'SUP006' for XML path('')),1,3,'')