Is SQL Replication available to you?

Not really. Keep in mind that a function must consistently return the same value for the same input...

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