Ohhh... that's an excellent idea, thanks!  Yes I'll get the devs to call a proc that records that it needs to be done and I'll have it picked up on...

Thanks Steve.  A web application (running on a VM in Azure) will as part of customer registration (frequently), make the decision to create a new database for that customer.  I'm...

Thanks Steve.  Yes that sounds as if it would work, but from the little I know of Azure MI I don't have access to the filesystem, how can I backup...

Thanks guys for all your help!  Sorry for the late thanks - I was on leave.  Everything works now as needed 🙂

Hi Brian, thanks for your detailed answer.  These instances will be accessed by a very limited number of users.  Admin access is literally the sysadmin/head DBA, so sysadmin is fine. ...

Perfect - that was it - and it worked.

Thank you so much!

Hi

Some updates. I've worked out how population works and I am now doing incremental population periodically, triggered by a job I've added to sql agent so that I've control...

Ok, here goes:

CREATE Function ChangeDelimiters(

@LINEvarchar(max),

@SEARCHchar(1),

@REPLACEchar(1))

Returns Table As Return

-- Replace @SEARCH with @REPLACE when found in @LINE between a...

Hi

I removed QuoteSplit as it is redundant, and I added an A4, to give me more than 10000 rows available to the tally table. That's it really, apart from...

Hi everyone

Once again thanks to everyone for all the suggestions. I have implemented Lynn's suggestion with one or two minor tweaks, and it's working like a charm 🙂

Thank you...

Lynn, won't QuoteSplit and ItemSplit always contain the same data? Isn't QuoteSplit redundant here, and QuoteRep could really just pull from ItemSplit?

Or have I missed something? 🙂

Hi.

Wow - the help on here is fantastic. I'm going to have to start offering my help to others more - I'm really starting to feel guilty 🙂

Lynn I'm...

Hi Craig

Well spotted on the placeholder piece, yes I've already hit the problem you mentioned and have not found a solution yet.

Here's ParseFile:

CREATE Function ParseFile(

@STRINGnvarchar(max),

@SEPARATORnchar(1)

)

Returns @PARSEDSTRING table(STRING nvarchar(max))

As

Begin

Declare@POSITION int...

Ok - I have it 🙂 And again many thanks to everyone, especially Dave Burrows. Excerpt below. Names changed to protect the innocent, and the not so....

@david-2 Burrows - THANK YOU 🙂

That is fantastic - that's exactly what I need. In the middle of writing horrible nested loops here and that has cut...