SqlServerTimeZoneSupport icon indicating copy to clipboard operation
SqlServerTimeZoneSupport copied to clipboard

SetIntervals proc: Wrap Delete/Insert in a Tran to avoid momentarily empty

Open dc2k5 opened this issue 10 years ago • 1 comments

When SQLTzLoader is running the [Intervals] table is momentarily empty for a given ZoneID which breaks the conversion functions. (Argument data type void type is invalid for argument 2 of dateadd function.) Recommend wrap DELETE/INSERT in a transaction

dc2k5 avatar Jun 22 '15 22:06 dc2k5

Thanks. I'll consider it further.

mattjohnsonpint avatar Jul 11 '15 06:07 mattjohnsonpint