There should be no need to copy data to a temp table; just replace #t with the name of your table/view and adjust the column names accordingly.

Consumable test data:

CREATE TABLE #t
(
    ID int NOT NULL
    ,SomeDate datetime NOT NULL
    ,Flag char(1) NULL
  ...

• This reply was modified 2 years, 2 months ago by Ken McKelvey.

ZIP files are binary files so will not save correctly as a string. Binary can be encoded as a string although the size will obviously be increased. One way to...

Please ignore this. I have just noticed that some of the production servers still have a GDR dated January and some have a GDR dated July.

I think Windows Update must...

One qustion: whats the purpose of

THEN DATEADD(minute, DATEDIFF(minute, '2020', T.StartDateTime), '2020')
ELSE DATEADD(minute, DATEDIFF(minute, '2020', T.EndDateTime), '2020')

instead of

THEN T.StartDateTime
ELSE T.EndDateTime

Looks like it produces the...

Try something like:

WITH InOuts
AS
(
    SELECT T.GroupingId, X.InOut
        ,CASE
         ...

• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 2 years, 3 months ago by Ken McKelvey.

What I remember from testing a few years ago:

1. A backup will not work with an expired certificate.
2. A restore will work with an expired certificate.

ie You should should leave...

This may...

Thanks for the information. Our oldest backups are...

You can restore a SQL2000 backup into SQL2008. An evaluation version of SQL2008 is available here:

Download Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals from Official...

SQL Server Data Types - Decimal, Numeric, Bit, Money, Date, Int (mssqltips.com)

Anyone got any ideas how I can get around this limitation.

You can use the CLR. The paid version of the following has File_GetDirectoryListing .

SQL# (SQLsharp) - Expanding the capabilities...

• This reply was modified 2 years, 3 months ago by Ken McKelvey.
• This reply was modified 1 years, 4 months ago by Ken McKelvey.

There is probably a better method:

SELECT J.spotterId, FD.indexKey, FD.frequency, FD.df, FD.varianceDensity, FD.direction, FD.directionalSpread
FROM OPENJSON (@JSON, '$.data')
WITH (
    spotterId nvarchar(25)
    ,frequencyData nvarchar(max)...

• This reply was modified 2 years, 4 months ago by Ken McKelvey.
• This reply was modified 2 years, 4 months ago by Ken McKelvey.

post to get over display bug

The following comment from https://techcommunity.microsoft.com/t5/sql-server-blog/update-hotfixes-released-for-odbc-and-ole-db-drivers-for-sql/ba-p/3848484 might help.

DavidEngelMS

Microsoft

‎Aug 10 2023 04:58 PM

@james Auman

 

This answer has some subtleties, so bear with me.

...

There is an additional scenario I'd like to describe for SQL Server...