It should be noted here that the default frame is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW (probably because it is deterministic), but this performs much worse than ROWS BETWEEN...

I haven't used SSIS in years, but the following works in SQL and there should be a similar expression in the SSIS Expression Builder.  You may need to adjust the...

The problem here is that databases aren't necessarily trees.  The simplest example of this is the employee/manager relationship where the employee record has a link to their manager's employee record. ...

Heading to my annual square dance convention.  This year, it's in Seattle.

Drew

The inserted table is just that: a table.  For most purposes, it behaves exactly like any other table.

The bigger issue here is that you have designed your trigger to...

It really depends on what kinds of overlaps you have.  It's rarely as simple as two or more records having the same start dates, but I have coded something that...