Database

Myself I would first look for a commercial solution. Rolling your own requires dealing with all of the possible error scenarios and notifications that must occur when an error happens. But other than that there are two problems not one. So there should be two solutions. 1. Do the back up 2. Move the back up to the remote location.

STRING_AGG is the best approach for SQL Server 2017 or later. If you need to support earlier versions, you'll need an alternative: Concatenating Row Values in Transact-SQL - Simple Talk[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

I always use parens. Removes the question for me an future maintenance programmers as to what I thought the precedence was.

I like that one! very simple. If it ain't broke don't fix it Discover my world at jkirkerx.com

That's pretty clever. my mind was no where near thinking of it like that. And it runs pretty quick as well, and gives me exactly what I want with null records on a failed join. This opens up new possibilities for me with some of the business logic. On a side note, I'm surprised that I didn't get laughed at for wanting to craft something like this. I couldn't think of a better way to handle this without writing a bunch of extra functions that might not be fast and reliable. Thanks Richard! If it ain't broke don't fix it Discover my world at jkirkerx.com

I think you mean 'Securities' (financial) rather than 'Security' (keeping everything safe)

Brilliant! I can't believe I didn't think of that. :laugh: The difficult we do right away... ...the impossible takes slightly longer.

Thank you to those who gave suggestions!! I have successfully solved the problem and completed my project!

Thank you. The difficult we do right away... ...the impossible takes slightly longer.

I thought you could use TSQL in Azure Synapse - in which case I would implement it exactly as you have shown. Failing that, I believe there is a has_all operator where myString has_all (Pattern1, Pattern2)

If the vendor won't support their own product, which you have presumably paid for, then demand a refund and find a better alternative. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Yes it is bad. Always use the correct data type for the content. If you insist on using strings you can run into all sorts of issues with international settings

thanks for fast reply! version 12 ((