The best way is to use > the next day rather than <= the end day.  Like this:

DECLARE @StartDate datetime
DECLARE @EndDate datetime

SET @StartDate = '18 Nov 2021'
SET...

I would think it would be.  Why not try it with a small table and see?

SELECT DISTINCT GRPID, PLNCD, XPLNE, EXTNO, EffDate, TermDate FROM History WHERE MBRNO IN (SELECT MBRNO FROM dbo.Member_MRN_lkupAllMBRNOs(@strMBRNO)) ORDER BY EffDate ASC

How large (MB/GB) is the "History" table?

How is...

Keep in mind that the view is being created in the same db as the proc is in.  Although presumably that is what you want to do.

What does "doesn't work"...

I'd clean up the prod problem first.  You can use a backup and research to research the other stuff, if you think it's necessary.

Also, once you get the table reduced...

Don't rely on the DB_ID() to reference a db.  Assume it could change at any time.

If you'll notice, in its system tables, MS stores the db name rather than the...

As Jeff noted, you should be able to do this with dynamic SQL.

But be aware that you cannot have any GO statements in the code.  Just the main statement itself:

CREATE...

SELECT C1
FROM #Base
WHERE C2 IN ('122', '123')
GROUP BY C1
HAVING SUM(CASE WHEN C2 = '123' THEN 1 ELSE 0 END) > SUM(CASE WHEN C2 = '122' THEN 1...

Jeff,

You're right this is not ok. Just this morning I alse remembered myself, I have some scenes implemented, which are turning off particular lights even if the light are...

It actually does matter because two on times without an...

If Member_MRN_lkupAllMBRNOs is a multi-statement table-valued user-defined function, that alone is going to cause pretty massive performance heads. Either switch it to being an in-line function, or eliminate the...

It doesn't matter if the 'on' is followed by 'on' or 'off', just add up all the 'on' times.

;WITH cte_switches_with_next_time AS (
    SELECT friendlyName,...

I provided the exact command to do that in my earlier code.

That's a lot of images at one time.  I suggest starting at 10K or even 5K and see how that goes first.

Btw, be sure to use sp_tableoption before UPDATEing the...

I kinda wondered why the column data needed to have 'MB' in it when the column name said 'MB'?!