What happened to the times 2023-01-01 01:23:45 to 2023-01-01 02:34:56 in your input?

Shouldn't they also be in the output?

So what is the expected output, that you don't know how to get, from your script above?

TechnicianID StartTime EndTime BlockStart BlockEnd TotalDurationSeconds ProductiveSeconds 1 2023-10-01 05:00:00 2023-10-01 05:10:00 2023-10-01 05:00:00 2023-10-01 05:15:00 600 600 1 2023-10-01 05:10:00 2023-10-01 05:25:00 2023-10-01 05:00:00 2023-10-01 05:15:00 900 300...

I asked ChatGPT to script it:

-- Drop the temporary table if it exists
DROP TABLE IF EXISTS #SomeTab;

-- Create the temporary table
CREATE TABLE #SomeTab (
   ...

From ChatGPT:

It seems that you need a workaround for the "calendar" table that is going away. In your updated code, you tried using @mydate and a "currentdate" table without populating...

sys.dm_exec_requests  and sys.dm_os_waiting_tasks dynamic management view provide more detailed information about the wait types and wait resources, making it easier to diagnose performance issues.

Have you got a clustered index on the table? You can do a single table scan and insert the values of the clustered index key that need to be deleted...

You can just shrink it a bit at a time. So instead of trying to shrinking it from 2.6 TB to 500 GB in one go just try making it...

SELECT *
FROM [Prod_ShiftSummary]
WHERE  entrydate >= (
   SELECT CONVERT(date, MAX(EntryDate))
     FROM [Prod_ShiftSummary]
 where office = 'baytown'
) ;

SELECT ap_claim_idM,
       MAX(CASE WHEN ap_claim_icd_prcdr_sequence_number = 1 THEN icd_prcdr_code END) AS Code1,
       MAX(CASE WHEN ap_claim_icd_prcdr_sequence_number...

Thanks all. I can confirm that the code is not being called in a loop, or in an explicit transaction. The parent procedure sproc_ValidateUser just performs some basic validation...

This XML snippet represents information about a database deadlock in SQL Server. Let me break down the key elements:

1. <deadlock>: This is the root element that contains information about the...

If you look at this post there is a stored procedure that will generate the inserts for any table: https://www.sqlservercentral.com/forums/topic/generate-script-for-table-contents#post-4184688

Just install it and call it:

            
October 8, 2023 at 12:16 pm
            
#4303870

            
            
                                                
        

Or even...

One way of doing it is to right click on...