SqlServerTimeZoneSupport
SqlServerTimeZoneSupport copied to clipboard
SetIntervals proc: Wrap Delete/Insert in a Tran to avoid momentarily empty
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
Thanks. I'll consider it further.