Heh, Phil's name is not, nor ever has been, Sean! And the query was deliberately written in that way, as the OP did not specify the need to...

Sure, you can break down the merge into its constituent INSERTs, UPDATEs and DELETEs.

Once you have done that, you will be in a better position to work out which statement(s)...

This is one way.

DROP TABLE IF EXISTS #SomeTable;

CREATE TABLE #SomeTable
(
    Col1 VARCHAR(5)
   ,Col2 VARCHAR(5)
   ,Col3 VARCHAR(5)
   ,Col4 VARCHAR(5)
);

INSERT...

I started watching a YouTube video on Azure DevOps. I can't have the sound turned up where I am, so I turned on subtitles. This is as far as I...

Heh, Phil's name is not, nor ever has been, Sean!

And the query was deliberately written in that way, as the OP did not specify the need to see aggregated results...

What makes you think that this is a memory leak?

SELECT [13latam] = IIF(rc.TYear = 13 AND rc.Region = 'Latam', rc.RowCnt, NULL)
      ,[14latam] = IIF(rc.TYear = 14 AND rc.Region = 'Latam', rc.RowCnt,...

Your answer is here.

There's no way I know of doing this.

Your likely alternatives would appear to be

1. Ensuring that T1 and T2 are well indexed and querying them separately, or
2. Combining T1 and...

Here's a quicker way. And are you sure you want to allow NULLs?

DROP TYPE IF EXISTS dbo.ColumnTableType;

CREATE TYPE dbo.ColumnTableType AS TABLE
(
    Column NVARCHAR(MAX) NULL
);

HI, and thanks for the reply. I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there?...

There's only one column and it...

Defining the column as NVARCHAR(MAX) would be a safer option. I'm sure that you'll need Unicode support for some of the characters in those languages.

--Edit: you should also probably read...

• This reply was modified 6 years, 8 months ago by Phil Parkin.

There is no fast way of doing this. As Eric mentioned, DOCX files are zipped XML files.

Searching through them would involve unzipping them first.

So you want to search the text embedded inside a DOCX file that has been stored inside a VARBINARY column, is that right?

So, notionally, like this?

SELECT cols...