select *, 
    case when last_bar = 0 or next_to_last_bar = 0 then ''
         else SUBSTRING(serialnumber,...

I'd be surprised if an index on a computed column ultimately helped the query plan at all.  Unless you have a fully covering index, which would likely duplicate most of...

Yes, it would.  I took:

i want to select from 00:00:00 - 06:00:00

to mean a contiguous range from 00 to 06, but I likely should have used 00 and 05, if...

To keep the query on the remote server "sargable", you shouldn't use any function on its columns in the WHERE, so something more like this (I may not have the...

Glad it helped!  Here's the 2nd version I mentioned: if you don't have more than 2 total dups, this might be easier to use.

--(2)
SELECT ID, 
 ...

WHERE DATEPART(HOUR, datetime_column) BETWEEN 0 AND 6

If you want the details too, you can either:

(1) join back to the main table to list all rows <or>

(2) list the min, max and count

--(1)
SELECT t1.*
FROM...

SELECT ID
FROM #tst
GROUP BY ID
HAVING 
    MIN(FNAME) <> MAX(FNAME) OR
    MIN(LNAME) <> MAX(LNAME) OR
    MIN(DOB) <> MAX(DOB)

Each location can't be completely separate if email addresses must be unique.  You need to replicate the email addresses across all tables, or have a "master" email table that contains...

You could also explicitly define ("format") the column as "Text" data type in Excel.

Here's a quick way:

DECLARE @JobDomain int
SET @JobDomain = 1

;WITH cte_Type_B AS (
    SELECT *
    FROM dbo.TestTable
    WHERE JobDomain...

Is the clustered index on the table on BaseID?

You can also use:

'20211130 00:00:00.000'

The only special chars you need are in the time, no - no T.

I've never heard of anything like that in SQL Server.

Part of the QotD is knowing defaults. This was left off, as many people do this and the default is to allow NULLs.

As a good practice, however, I...