Can you post the part of the code which sets up the connection and calls the proc? I know nothing about Omnis, but presumably it's not too alien.

Ok. Is the app calling the proc in a loop?

Where is the CURSOR?

Pardon my slow reply.

The storage key is used to autenticate the SSIS Azure Components with the Storage Accout. We have files (text files, csv, etc) on these accounts which...

Steady on!

Assuming all of the DBs are in source control, you can do a simple string search.

Redgate's SQL Search?

Excuse my ignorance, but...

Thanks, Brian.

To be clear, 'qwerty' was an attempted joke. The actual password will be long and complex. We store stuff like this in an Azure data vault, to ensure it's...

I think that XML does have legitimate uses, but large-scale data storage and retrieval is not one of them. I presume a lot of people spent a lot of time...

Brian, thanks for the response. This is very much at the proof of concept stage right now. To give you an idea of how I was thinking of setting things...

I am not arguing nor disapproving anyone and fully appreciate the time people took to reply.

My concern was if the proposed solution, with several SELECT statements from the same...

Not sure...

Welcome to the wonderfully non-intuitive world of XQuery! Here is some T-SQL which does the job. If you want to understand exactly how it works ................ ([Phil starts whistling and...

My German is not good enough to understand all of your screenshots, and as you have not provided any usable sample code, I cannot provide a coded solution. But I...