whenriksen (10/13/2016)

---

Another benefit to using the calendar table rather than the Select DateAdd, performance is much better when used for filtering/grouping.

One request I received at my work was to see...

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