Ah, I missed the fact that you are using SQL 2012.

The other option is to just force the AnchorDate to DTO (knowing that SQL assumes that it is UTC)

            
February 22, 2022 at 3:14 pm
            
#3986951

            
            
                                                
        

You can also use the AT TIME ZONE functionality for the test

/*
Queries tested on SQL Server 2012 with default timezone of Eastern Standard Time.
*/

DECLARE @ComparisonDateAsDTO datetimeoffset(7) =...

This is easily achieved with a cross-tab query

CREATE TABLE #Animal (ID int, Animal varchar(20), Number int, [Year] int);

INSERT INTO #Animal ( ID, Animal, Number, [Year] )
VALUES (...

This is very easy to achieve using the LAG function

Depending on the actual data in the xml as well as the xml structure of the various records, you find storage improvements by storing the xml as [n]varchar(max).

Here is a link to a post by Drew Allen https://www.sqlservercentral.com/forums/reply/2031829 which covers islands

You have not provided any usable data or a base query to be able to test against.

The following code should get you moving in the right direction

WITH...

When assigning values to a string data...

• This reply was modified 3 years, 7 months ago by DesNorton. Reason: Fixed copy/paste error (Thanks kaj)

The following code should do the trick

SUBSTRING(part, LEN(part) - CHARINDEX('-', REVERSE(part)) -1, 2)

HAVING SUM([FileSize]) > 104857600 - This returns 15 ROWS

What is the value of [SumOfFileSize] for the 15 rows? How many of them are greater than 10485760000?

Based on...

There is no issue with letting SQL generate the PK name for the temp table.

That said, there is no guarantee that your script will run any faster when running 2...

That's a rather selfish thing to do.

Rather leave your question up, and feed back with what you did to resolve it.

That way, other people can learn from your efforts.

Google is your friend

https://www.google.com/search?q=c%23+exec+sql+stored+procedure+with+parameter&rlz=1C1GIGM_enZA726ZA726&oq=c%23+exec+sql+stored+procedure+with+parameter&aqs=chrome.0.69i59j0i22i30l3j69i58.256j0j7&sourceid=chrome&ie=UTF-8

You need to include your variable assignment in the query

SELECT @NUM_RECORDS = COUNT(*)
FROM DBO.DataImportFileImportHistory AS T1
WHERE T1.FILENAME = @FILENAME;

A simplified query to return dateStamp as datetime, and wkStamp as 1st day of teh week.

You can then use the value in wk_stamp to do your grouping by

            
January 28, 2022 at 3:59 pm
            
#3978401