I would use a NOT EXISTS in some form

;WITH CTE AS
(
    SELECT cs_subscription.cs_contactyominame AS 'Contact Name',
        ...

• This reply was modified 5 years, 7 months ago by Jonathan AC Roberts.

Yeah, as you mention Jonathan, I could have multiplied from same table. Thats what i went on to do, but stupid as I am I then realised that I...

Can't you multiply two matrices together from the same table?

I don't see why you need two different tables?

https://knoema.com/FREDIR2017Aug/u-s-interest-rate?tsId=1033510

https://knoema.com/FREDIR2017Aug/u-s-interest-rate?tsId=1033450

Remarks

STRING_SPLIT inputs a string that has delimited substrings, and inputs one character to use as the delimiter or separator. STRING_SPLIT outputs a single-column table whose rows contain the substrings. The name...

You need to speed up the statements that run after this stored procedure is called that are contained in the same transaction. Or, if you can, rearrange the calls to...

Could it be that the SP is called by long running processes (transactions) that are updating the same row (with the same [object_name]) and one of the transactions hasn't finished...

You could do it with a SQL Agent job and a call to DBMail.

;WITH cte AS 
(
    SELECT Revision_ID, 
           COUNT(*) CountParts
     ...

Another option is to use dynamic SQL. For any input parameters that are null the AND clause could be removed.

For example, if @PatientID were null you could remove this line...

You could try one of the following hints at the end of the SQL:

OPTION (OPTIMIZE FOR UNKNOWN)
OPTION (RECOMPILE)

Given that the table had no index at all, I didn't think in this case that making the clus index unique was necessary, particularly to the extent...

I don't know,...

Well, the issue with MONEY is that who's to say monetary amounts should always have 4 decimals? Often it's too much, and sometimes it's not enough. And if you...

To some extent, it gets worse with larger numbers. Try this:

DECLARE @tmp1 FLOAT = 10e27;
SELECT CONVERT(decimal(38,2),ROUND(@tmp1, 2)*100),
       CONVERT(decimal(38,2),ROUND(@tmp1, 2))*100,
 ...