Viewing 15 posts - 1,156 through 1,170 (of 4,087 total)
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...
July 10, 2018 at 9:03 am
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...
July 2, 2018 at 3:19 pm
July 2, 2018 at 3:12 pm
July 2, 2018 at 12:59 pm
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. ...
July 2, 2018 at 7:14 am
Heading to my annual square dance convention. This year, it's in Seattle.
Drew
June 29, 2018 at 9:02 am
June 29, 2018 at 8:57 am
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...
June 29, 2018 at 7:17 am
June 28, 2018 at 12:15 pm
June 28, 2018 at 7:25 am
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...
June 27, 2018 at 2:44 pm
June 27, 2018 at 10:06 am
drop table temp1
June 27, 2018 at 9:26 am
I think the script can be improved. Specifically, you are reading the same table three times when you can do a simple "UNPIVOT" instead. Also, I think that combining the...
June 27, 2018 at 9:20 am
Viewing 15 posts - 1,156 through 1,170 (of 4,087 total)