Presumably BACKUP/RESTORE is not an option.

For the volumes of data you are talking about, I'd probably use a pipe-delimited...

FORMAT is not 'tricky',...

It seems that you're not trying the suggestions here with any great application.

Instead, you appear to be waiting for someone here to write the solution for you. Unless you can...

Use something like this to generate the statements for changing DB ownership to sa

USE master;
GO

SELECT name
      ,SQL = CONCAT('ALTER AUTHORIZATION ON DATABASE::',...

Yikes, a WHILE loop. No wonder it's slow.

The following query should do the UPDATE in a single hit. But please test it thoroughly before running it anywhere important.

            
June 24, 2022 at 9:01 am
            
#4054262

            
            
                                                
        

To answer your other question, CROSS APPLY is one way:

DROP TABLE IF EXISTS #SomeXML;

CREATE TABLE #SomeXML
(
    Col1 VARCHAR(50) NOT NULL
   ,Col2 VARCHAR(50)...

Hi Phil ,

First thank you for your reply and yes it works thankyou..... you are a champion!!

Phil  what is the best way to apply this logic to a sql...

Updating the column by matching on UniqueId should not take such a long time. Can you show us your UPDATE query? Approximately how many rows of data need to be...

OK, too many columns called vacation hours.

WITH mx
AS (SELECT TOP (1)
           VacHours = 'Max_Hours'
   ...

WITH mx
AS (SELECT TOP (1)
           VacationHours = 'Max_Hours'
         ...

You are using terminology which is confusing me.

There are no variables in my code. Zero.

Nor is there a 'header' called Max_VacationHours.

The second you put, "Min_VacationHours", but doesn't bring it.

No I...

Does this help?

SELECT ItemParam = T.c.value('Item[1]/@param', 'nvarchar(50)')
      ,ItemValue = T.c.value('Item[1]/@value', 'nchar(10)')
      ,DefaultRpx = T.c.value('DefaultRpx[1]/@value', 'nvarchar(40)')
FROM @XML.nodes('/SelectionCriteria') T(c);

I've tried everything I can think of and I can't figure it out, either!

Blimey....

Can you confirm the exact format of JObject? It looks like

{"View"true,"Edit"true,"Admin"true}

Is that right?