I have seen temporary shortages of specific instance configurations in specific regions, but It seems odd that AWS couldn't supply the EC2 instances you need in the long run. Are...

"else 0"

Try changing 0 (zero) to '0' or some other string

Sure, it could happen.

I'm not aware of any TSQL functions, since it involves nslookup, telnet &  SMTP EHLO commands. You can certainly do email address syntax validation in TSQL, but that doesn't guarantee...

The error is telling you the problem -- all the columns used in a foreign key must be all the columns in a unique index on the primary table. If...

If it's only that combination we want to exclude, I think we'd want

SELECT ...

FROM t

WHERE NOT (EMPLOYEE_ID = 123 AND WORKSITE_ID = 22)

(EMPLOYEE_ID != 123 AND WORKSITE_ID...

Use LEFT OUTER JOIN to the lookup tables.

In the past, table variables would have been another red flag. But SQL Server 2019 did improve row estimates for table variables, so they aren't automatically suspect.

Temp tables created in...

With cursors, I think it's usually not about unpredictable plans so much as whether it's more efficient to do many, many small transactions vs. a few larger transactions. That said,...

Is it critical that it completes in 12 seconds instead of 24? Are you experiencing blocking or other issues due to the longer execution time? If not, and especially if...

Retracted following OP response

Parameterize your subcategory parameter available values query to use CategoryID parameter as a filter:

SELECT  SubCategoryID, CategoryDesc
FROM #sc
WHERE CategoryID = @CategoryID

You will set the Dataset parameter @CategoryID parameter...

Looks like a repeat of

https://www.sqlservercentral.com/forums/topic/pivot-split-column and

https://www.sqlservercentral.com/forums/topic/pivot-split-column-2 and

https://www.sqlservercentral.com/forums/topic/pivot-split-column-3

Here's an approach using SSIS that looks promising: https://social.msdn.microsoft.com/Forums/SECURITY/en-US/8c114455-19c3-405f-8234-c83690dc3450/ssrs-export-separate-pdfs-from-ssrs-generated-report-subscriptions?forum=sqlreportingservices

And an approach using Powershell: https://www.sqlservercentral.com/forums/topic/ssrs-export-to-separate-pdfs

Because, as far as I know, SSRS can't export pages as separate files, if you want to...

The right answer would indeed be to have <Entity>Note tables. I wouldn't make those tables just an association table to Note table w/ a NoteID -- I would actually put...