Do you want each individual date difference or do you just want an average days' difference between orders? The latter is much less work to calc :-).

Good article, but there's a much easier way to calc the nth given day of a given month. Also, btw, Thanksgiving is the fourth Thursday of the month not...

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