What you're asking to do really isn't logical. Walk through this.

You're telling SQL, with the FK: "Do not let me add a row to this table unless a matching...

No need to shrink below a certain minimum size, even if you can. I've used 1GB below, but adjust it as needed for your environment.

EXEC sp_MSforeachdb '

IF ''?'' IN...

The IDENTITY property can't be added to an existing column nor removed from a column.

You could add an identity column to the table, if it doesn't have one, and then...

As long as the file name is the only YYYYMMDDHHMMSS string in the file, I think you can just check for that pattern:

SELECT input, SUBSTRING(input, PATINDEX('%[2][01][0-9][0-9][01][0-9][012][0-9][0-5][0-9][0-5][0-9]%', input), 14) AS extract

FROM...

I assume you mean "sys.dm_exec_procedure_stats" although you never really stated that.

I suspect it has something to do with SSRS. Maybe the proc is being called from the SSRS web...

Prior to updating the table, put the username in a known place, and the trigger can retrieve it from there and use it.

Sean Lange (10/6/2016)

---

ScottPletcher (10/5/2016)

---

Sean Lange (10/5/2016)

---

Thom A (10/5/2016)

---

Sean Lange (10/5/2016)

---

Be careful if you use this code as a starting point. It has scalar values being populated from the inserted table....

Just in case you want to touch it up a bit:

CREATE Trigger [dbo].[Test_UpdateTrigger_1]

ON [dbo].[Department]

AFTER UPDATE

AS

SET NOCOUNT ON;

IF UPDATE(Department)

BEGIN

INSERT into Department_Audit (

...

I didn't go that route...

I interpreted the OP's requirement differently, i.e., a given personID cannot have more than one row with a value of '17' and an attributeID of '9875'. If so, then...

Sean Lange (10/5/2016)

---

Thom A (10/5/2016)

---

Sean Lange (10/5/2016)

---

Be careful if you use this code as a starting point. It has scalar values being populated from the inserted table. This is very...

I assumed a physical tally table, column name "N" (ugh!, but most common I guess), to avoid having to use an inline CTE:

DECLARE @start_date datetime

DECLARE @end_date datetime

SET @start_date = '20160101'

SET...

My best guess is something like this:

UPDATE sc

SET column_x = ISNULL(sot1.value, '') + ISNULL(sot2.value, '') + ISNULL(sot3.value, '')

FROM dbo.SaltoCardholders sc

LEFT OUTER JOIN dbo.some_other_table1 sot1 ON sot1.lookup_col = sc.loc

LEFT OUTER JOIN...

The most important thing is to:

Cluster the dbo.FreightRate table on ( SourceKey, CompanyKey, PackingType ).

But you could adjust the query slightly also:

SELECT COALESCE(fr1.FreightRate, fr2.FreightRate, fr3.FreightRate, 0)

FROM dbo.Sales s

LEFT JOIN dbo.FreightRate...

To be fair, the number of databases would have an impact here. I've got servers with hundreds (and hundreds) of dbs. Even small files add up to a...