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...

(1) Not guaranteed, but you could try looking at sys.dm_exec_input_buffer.event_info (SQL 2016+ only, I think).  I would issue this command immediately upon entering the trigger, to have the best chance...

It may fragment some indexes and not others.  You certainly don't want to automatically rebuild every index.  Also, rebuild from smallest to largest of the indexes that do need rebuilt.

Liked Rune's comment.

And that is why you should always explicitly specify NOT / NOT NULL when creating a table.  From the context of the q, I could work out that...

Shrink only the file(s) that are part of the PRIMARY filegroup:

DBCC SHRINKFILE(1, 512)

DBCC SHRINKFILE(?, 512) --if you have additional file(s) in the PRIMARY fg

SELECT CAST(SUM(OrigWeight/2000.0) AS decimal(10,2)) Tons

SELECT OBJECT_NAME(object_id) AS object_name
    SUBSTRING(definition, CHARINDEX('##', definition) - 20, 200) AS definition_first_match,
    definition
FROM sys.sql_modules
WHERE definition LIKE N'%##%'
ORDER BY 1

Edit: Sorry, I...

• This reply was modified 3 years, 3 months ago by ScottPletcher.