I don't think you have to do all that. Just change the first SELECT ... INTO statement:

...

PTS_QA_CE = CAST(Null AS decimal(10, 2)),

...

Btw, don't use decimal(10, 2) unless you really...

Instead of a "CROSS JOIN" on the tally table, use an INNER JOIN, specifying the WHERE conditions relating to tally values as ON conditions instead.

Quite true. A valid point.

3 of them are exactly the same function. Unfortunately, I...

Technically, I think the first calc can be reduced ever so slightly 🙂 :

DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), -1) AS LastDayOfLastMonth

I think you can do that more easily, like so:

SELECT SUBSTRING(col1, (CHARINDEX('Website is', col1) + 11),

CHARINDEX(' because', col1, (CHARINDEX('Website is', col1) + 11)) -

...

You're pulling data from the comma forward, so you need a leading comma as well as a trailing one.

Yes, but I think someone made that point that legally in some jurisdictions, a person with...

It's not even guaranteed to be unique, which would be a bigger problem .

Use EXIST with OR between to check the other tables; check the most likely table...

Hmm, but if a user bulk inserts several rows at once, many of them could get the same datetime value (at least if we're talking about std datetime accuracy to...

I agree; one single, keyed INSERT should not take that long.

(As an aside, though, that is a fairly long row (in bytes). If you do not update rows after...

--CREATE VIEW viewname AS

SELECT

COALESCE(sel.id, defaults.id) AS Id,

COALESCE(sel.name, defaults.name) AS Name

FROM (

SELECT 10 AS id, 'NotAvail' AS Name

)...

I was reading the textual plan, not the graphical one, which at a quick look I thought was using IX_sysValidationList index.

I never said it was doing a seek, I said it...

Hmm, so a given item can't go to a different status *and back* on sequential weeks:

SELECT 'B100', 1, 'FFF', 1, '2009-04-04 00:00:00.000', '2009-04-10 00:00:00.000', 0 UNION ALL

SELECT 'B100', 1, 'FFF',...