to reproduce the error, set strType to a value other than AAA or BBB. This is easy to do in the debugger (breakpoint, add a watch on "strType" and change...

That I am not entirely sure.  Best guess - I am wrong on how it is matching things up with the recursive query which I was actually able to prove...

Nice!  Thanks for the followup!

Only thing I see that may be of concern is that if cmd.ExecuteScaler() throws an exception, that exception is going to be passed back to the...

To confirm, you SEE this blocking?  The reason I ask is that a SINGLE SQL query, even a recursive one, will use the SAME SPID for the lifetime of the...

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale.

did you get this sorted out?

looking at the graphs doesn't mean much if you don't have a reasonable scale.  your scale of 0 to 100 doesn't really tell us much as 0 to 100 bytes...

Looking at the execution plan images (as we have no actual execution plan to review) your biggest hitters are the DELETE and the INSERT, so I too am wondering if...

First step to troubleshooting this is to look at the error message.

Can you post that?

Doing a differential backup should be very similar to a tlog backup or a full backup,...

If you have the RDL file, you can open that in Visual Studio.

Alternately, if you don't want to open a report URL, you could build a tool that essentially opens...

it looks to me like you declare one variable, but use one that never existed a few lines later:

i think you declared "SQL", but dynamically create "strSQL" a few...

Priority 1 and 2 should be trivial if I understand this right - for Priority 1, TargetDate = DATEADD(hour, 2, CreatedDate).  And for Priority 2, you change the 2 to...

This may or may not help, but if you turn Main_CTE into a table (temp table, table variable, physical table... not sure which will be the best for your use...

Just to add to Sergiy's response - the "01" indicates that the value is positive.  If the value was -126, then you'd get "00" in that octet instead.  the "00"...

I see one big glaring red-flag in that bit of code - you are calling ExecuteScalar() TWICE!  So you are running the command against the SQL database TWICE!  That will...

How about something like this:

CREATE TABLE [#Temp]
(
[ID]  INT
, [Status_ID] INT
, [StartDate] DATE
, [EndDate]  DATE
);

INSERT INTO [#Temp]
SELECT
101
, 1
, '01/02/2020'
, '01/28/2020'
UNION ALL
SELECT
101
, 1
, '01/29/2020'
, '01/31/2020'
UNION ALL
SELECT
101
, 5
,...