Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET DATEFORMAT ymd
- DECLARE @datevar datetime
- if (SELECT COUNT(*) FROM _YearOffset WHERE Offset=2000) > 0
- set @datevar = '4016-04-17' --print 'Есть смещение'
- Else
- set @datevar = '2016-04-17' --print 'Есть смещение'
- select COUNT(*) as DoUdaleniya from _InfoReg4206
- BEGIN TRAN
- BEGIN TRY
- select reg.* INTO #tmp_InfoReg4206_20161017113542 from _InfoReg4206 as reg
- where _Fld4207_RRRef IN (
- SELECT _IDRRef as _Fld4207_RRRef FROM _Document9915 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4625 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7991 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6846 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document9227 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7408 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document9549 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4896 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4629 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4989 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5072 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6306 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document8430 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document117 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6950 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document8553 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7411 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document9090 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6181 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6417 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4627 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4628 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6502 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7206 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6599 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6322 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5124 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5095 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7207 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document60 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5043 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4956 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6540 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4843 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10522 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document64 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4503 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7177 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document118 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document65 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7056 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4007 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3686 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4009 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document108 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document114 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document105 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3685 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3577 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document104 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document109 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document119 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document115 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3754 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3719 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document110 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3663 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document116 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document112 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document113 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document120 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document107 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3864 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3865 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4327 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4008 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4326 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document3544 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document111 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4436 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document106 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10350 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6644 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10063 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6752 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7634 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6246 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4552 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5916 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5684 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5446 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7409 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7069 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5444 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6575 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6751 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document8555 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5998 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10546 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document9429 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6247 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6248 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5445 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7410 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document8556 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7632 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document97 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document98 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document9428 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4527 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4553 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document4626 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7633 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5822 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document9817 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5627 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5524 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document7992 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document5823 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document6879 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10769 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10837 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document10838 WHERE (_Date_Time >= @datevar)
- UNION
- SELECT _IDRRef FROM _Document11331 WHERE (_Date_Time >= @datevar)
- ) and
- _Fld4208RRef in (SELECT _IDRRef as _Fld4208RRef
- FROM _Node4016
- where _Marked=CAST(0 as binary(1)))
- TRUNCATE TABLE _InfoReg4206
- INSERT INTO _InfoReg4206 SELECT * FROM #tmp_InfoReg4206_20161017113542
- END TRY
- BEGIN CATCH
- SELECT ERROR_MESSAGE()
- ROLLBACK TRAN
- END CATCH
- IF @@TRANCOUNT > 0 COMMIT TRAN
- select COUNT(*) as PosleUdaleniya from _InfoReg4206
- SELECT @@TRANCOUNT as NezakonchennieTRAN -- должно быть 0 !!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement