Nakul beat me to it!! Here was my suggestion: WITH cteID(Requestid) AS ( SELECT DISTINCT Requestid FROM @Reviewers ) SELECT B.Requestid, STUFF((SELECT ',' + A.ApproverName FROM @Reviewers A WHERE A....

Nakul: Your comment about XML is valid enough and the STUFF operation on top of that does take additional time. I agree that the COALESCE option is the most efficient but only when you have the luxury to use a variable. In most cases when I've had a s...

Nakul: Your comment about XML is valid enough and the STUFF operation on top of that does take additional time. I agree that the COALESCE option is the most efficient but only when you have the luxury to use a variable. In most cases when I've had a s...

Another possibility is to avoid both the variable AND the CTE: SELECT STUFF((SELECT (',' + nt.Name) FROM @NamesTable nt FOR XML PATH('')), 1, 1, '');...

Another possibility is to avoid both the variable AND the CTE: SELECT STUFF((SELECT (',' + nt.Name) FROM @NamesTable nt FOR XML PATH('')), 1, 1, '');...

I have also been a big fan of DFDs since I was in college back in the 80's. I don't understand why it's usage has dropped because I still find it it to be very relevant and useful. I have also been looking for a good DFD program that will not only let...

I have also been a big fan of DFDs since I was in college back in the 80's. I don't understand why it's usage has dropped because I still find it it to be very relevant and useful. I have also been looking for a good DFD program that will not only let...

I wish to clarify a point you made about the "VB-like syntax used in the SSIS expressions." It actually utilizes C-like syntax in expressions such as && for AND, || for OR, and the ? : construct for conditionals....

I wish to clarify a point you made about the "VB-like syntax used in the SSIS expressions." It actually utilizes C-like syntax in expressions such as && for AND, || for OR, and the ? : construct for conditionals....