Thanks for the additional explanation on sp_executesql.  That's essentially the same info that I found.  I ultimately went with a variation that also includes "STRING_AGG" and "CAST".  So far, this...

• This reply was modified 3 years, 1 month ago by  RMason - eLIMBS, LLC. Reason: Correction to naming scheme

Thank you both for your feedback.  I totally understand, accept and am prepared for the consequences of such a practice.  That being said, I am using a number of other...

Thank you for taking the time to read and respond to my question.  I am sorry for the delayed response.  I had to leave town for an industry convention, and...

Thanks for the quick response, Luis!  So far, this seems to work very well for my needs.

Thanks again!  😀:D:D:D:D:D:D

edit:  I will say that I'm a...

I believe you can use an Aggregate Transformation[/url] to accomplish this.

In my case, it was the first result from this page.

If you're looking to avoid adding in rows that already...