how can i insert a CHAR(10) after every second loop in t-sql stuff function in my query SELECT STUFF( ( SELECT ‘, ‘ + new_name FROM new_subcatagories FOR XML PATH(”), TYPE ).value(‘.’, ‘VARCHAR(MAX)’), 1, 2, ”) so the result should by record1,record2, record3,record4 >Solution : You could use a CASE expression to see if the… Read More how to insert a line break after every second loop in t-sql stuff function