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

Here is a TVF:

CREATE FUNCTION myFunctioname
(
    @LdryCode as varchar(100),
    @InvtAcctCode as varchar(100),
    @CustName as varchar(100),
   ...

Why don't you take the loop out and do it all in one statement?

It isn't the ASCII function that's causing your error:

Try these statements:

SELECT ASCII('.');
SELECT ASCII(NULL);
SELECT ASCII(42);

All of them return a valid value.

But these all cause the same error you...

If you want a load into a new table, then create the empty table AND create the Clustered Index.  Then, forget SSIS... use BULK INSERT with the...