This question is strikingly similar to this one.

Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to the...

Whoever asked you to do this needs to...

This possibly means that there is a 32-bit version of the driver installed on the server but not a 64-bit version.

I suggest you get out of the habit of writing = NULL. Instead, write IS NULL. NOT is very useful, do not discard it!

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...