CLR functions for performing Regular Expression searches aren't SQL either, but they're useful. Where do you draw the line?

IIF is part of T-SQL and is more succinct than CASE,...

I don't see the need for all that, this is much simpler:

SET @ytdfrDate = DATEFROMPARTS(YEAR(@frdate) - 
    CASE WHEN MONTH(@frdate) < 4...

Only with a bad data model.  Parts from the same invoice line could be shipped on different dates.  You don't split...

I don't see the need for all that, this is much simpler:

SET @ytdfrDate = DATEFROMPARTS(YEAR(@frdate) - 
    CASE WHEN MONTH(@frdate) < 4 THEN 1...

I'm more confused than...

CONVERT works on a single value at a time.  Thus, the query should be more like:

and a.myDate BETWEEN CONVERT(date, '20201108') AND CONVERT(date, '20201116')

The strings will have to be converted to...

Either one can do the install.  The DBA will need to provide some settings for the Windows team, but that team should be able to do an install as well.

No.

If it's doing a lookup only (not modifying data, just reading it), you could also use WITH (NOLOCK) on the table to reduce overhead of the lookups.  I would argue...

View sys.change_tracking_databases returns the db names of all dbs that have change tracking enabled.

Thus, the db name will not be in the view if change tracking is off.

            
August 17, 2021 at 1:51 am
            
#3920565

            
            
                                                
        

You could do some major clean up on your existing code:

1. Don't use nvarchar unless you absolutely must have it, use varchar instead.

2. Don't use (MAX) unless you absolutely must...

There are only two processes involved in the deadlock.

Make sure you have an index on

dvd ( bed_id, wns_id, dvb_id )

Actually, all these tables should almost certainly be clustered first on bed_id,...

...

N'<th>Count of Records Successfully Uploaded Today: </th></tr>' +

-- Below is the query of which the results are passed into the rectangle

CAST((SELECT COUNT(*) FROM .[dbo].[Stage_SMSLog]

with (NOLOCK) WHERE datestamp = CONVERT(nvarchar(10), GetDate(),120))...

You need format 120 rather than 20: 20 will leave off the century, so you'd get 21 for yy instead of 2021, therefore it won't match.

A trigger would be more consistent than using a proc, unless you only want to do this for certain, specific INSERTs:

USE tempdb;

IF OBJECT_ID('dbo.FirstTable') IS NOT NULL
 ...

AT TIME ZONE clause.