API tools faq
paste
Advertisement
pathed1969

Timeout when executing MERGE-statement in SQL Server 2016

pathed1969
Dec 28th, 2016
495
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 93.57 KB | None | 0 0
raw download clone embed print report
  1. /* 01: In SQL Server 2016, create a database and set it to simple recovery model */
  2.  
  3. /* 02: Create a source and a taget table in the new database */
  4.  
  5. IF OBJECT_ID('TargetTable', 'U') IS NOT NULL
  6.     DROP TABLE [dbo].[TargetTable];
  7. GO
  8.  
  9. CREATE TABLE [dbo].[TargetTable](
  10.     [SK] [int] IDENTITY(1,1) NOT NULL,
  11.     [RK] [int] NOT NULL,
  12.     [Date1] [date] NULL,
  13.     [Date2] [date] NULL,
  14.     [FK] [int] NULL,
  15.     [Char1] [varchar](32) NOT NULL,
  16.     [DateTime1] [datetime] NOT NULL,
  17.     [DateTime2] [datetime] NOT NULL,
  18.     [Bit] [bit] NOT NULL,
  19.     [HashedBK] [varbinary](64) NULL,
  20.  CONSTRAINT [PK_TargetTable] PRIMARY KEY CLUSTERED
  21. (
  22.     [RK] ASC,
  23.     [DateTime1] ASC,
  24.     [Char1] ASC
  25. ))
  26. GO
  27.  
  28. ALTER TABLE [dbo].[TargetTable] ADD CONSTRAINT [DF__TargetTable__DateTime2] DEFAULT ('9999-12-31 23:59:59.000') FOR [DateTime2]
  29. GO
  30. ALTER TABLE [dbo].[TargetTable] ADD CONSTRAINT [DF__TargetTable__Bit] DEFAULT ((1)) FOR [Bit]
  31. GO
  32.  
  33. IF OBJECT_ID('SourceTable', 'U') IS NOT NULL
  34.     DROP TABLE [dbo].[SourceTable];
  35. GO
  36.  
  37. CREATE TABLE [dbo].[SourceTable](
  38.     [RK] [int] NULL,
  39.     [Date1] [date] NULL,
  40.     [Date2] [date] NULL,
  41.     [FK] [int] NULL,
  42.     [Char1] [varchar](32) NOT NULL,
  43.     [DateTime1] [datetime] NOT NULL,
  44.     [HashedBK] [varbinary](64) NULL
  45. ) ON [PRIMARY]
  46. GO
  47.  
  48. /* 03: Add 2 rows to the taget table (the first row will match a source row when merged) */
  49.  
  50. SET IDENTITY_INSERT [dbo].[TargetTable] ON
  51. INSERT INTO [dbo].[TargetTable]([SK],[RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[DateTime2],[Bit],[HashedBK])
  52. VALUES(1,1,CAST('20171231' as DATE),NULL,56,'String1',CAST('20160307 00:00:00.000' as DATETIME),CAST('99991231 23:59:59.000' as DATETIME),1,0xE8BBBC7C8B06A535C3E59875BA92D821F1167B316D671A00AA44FCDB82F5A4FD)
  53. INSERT INTO [dbo].[TargetTable]([SK],[RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[DateTime2],[Bit],[HashedBK])
  54. VALUES(2,2,CAST('20160630' as DATE),NULL,NULL,'String1',CAST('20160309 00:00:00.000' as DATETIME),CAST('99991231 23:59:59.000' as DATETIME),1,0x8D246156EA099942A949A6477AA391DFBEF68BE61A12846D6F9D3F6CCDCE9690)
  55. SET IDENTITY_INSERT [dbo].[TargetTable] OFF
  56.  
  57. /* 04: Add 327 rows to the source table  */
  58.  
  59. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  60. VALUES(1,CAST('20171231' as DATE),CAST('20160201' as DATE),56,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE8BBBC7C8B06A535C3E59875BA92D821F1167B316D671A00AA44FCDB82F5A4FD)
  61. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  62. VALUES(25,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA756340412236469DD33F53E06A574CB46EB341A443CA1FAC4797D15357FFB12)
  63. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  64. VALUES(26,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7AFA0C6CF428321E3A896EC033E5D6FC6C507020D353E73D7C600D578F20E50B)
  65. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  66. VALUES(27,CAST('20150328' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x705FF71346AA5AE12B445866BCF85584182579F828F45F69ABCC6BC4FD0F8BEA)
  67. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  68. VALUES(28,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE9FDE1F7ACFD0ECC840ACE1DAE05E4203EA177E33EDB2F4E31A1955317D5F766)
  69. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  70. VALUES(29,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE0A1A22104CFD5C26082B5248413036EC764A81E7238C7C2F690EF333BC2B3F5)
  71. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  72. VALUES(30,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC6BC0592FFEB8FAE1FE88F02A1FAEE9CC49C9836D9638A8036A75D1EEA79739B)
  73. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  74. VALUES(31,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7AB609F6C2D6A397ACD202B956E863F8E0AFCD1A58381B305833256C154ACE26)
  75. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  76. VALUES(32,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD67980C63C378C5BE3FAEA684D824E3A6F0B0E49A851324B1C9AC1FCC83C578A)
  77. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  78. VALUES(33,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5DCB5FF4AE05AC6C321D91B3548559848D3D8F2772D7B216492665B23B4AEAAD)
  79. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  80. VALUES(34,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x61158E2413D2207D7A875C9ACDAD5AF751815C42E5F9A83CB48994B82D15C35C)
  81. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  82. VALUES(35,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x62B47A2D96272B29F7B6CAE554E2E13DB6E7DF1F408AE68D472C6EFE9C31A7CB)
  83. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  84. VALUES(36,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x08BEEE814354AD3DB74795A9A7778FAF220625AD700629673A08AA7B86401EB3)
  85. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  86. VALUES(37,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x65BE6602D8F3F0B4FFE8D272A4DF8726711F2A69A56B98A67570D98E4DD8447B)
  87. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  88. VALUES(38,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xAEB7EF86817E81C2CEB9D127ED3A3EA33258668CF0A9C14906D16C241BDE98CB)
  89. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  90. VALUES(39,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x787A5E3AEAC401E6FFE6AE946718547DDBFFC2B0DD4A3E0854536C8B92E0E939)
  91. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  92. VALUES(40,CAST('20151228' as DATE),CAST('20131201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEA189D1AF680DF73E84B5CB450F2BF8AF49580021FA0D548CB9C401362B0D42F)
  93. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  94. VALUES(41,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE5059EF6066F9A909C8131D78003F09EFBEE954A17E26CF83E9F87DDFBB736E8)
  95. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  96. VALUES(42,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x718F9DAC39A23F51191A6775E18AA6571F2102FE00287E55941A414C7987385F)
  97. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  98. VALUES(43,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBBC33BA29E458450677597240D13610D40DA3932382030D1ED671F661FA15A13)
  99. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  100. VALUES(44,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x28054B2671301F6E4F9E40A358FE9BFADCC647646F9F6D1FC729F769990BB95D)
  101. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  102. VALUES(45,CAST('20151228' as DATE),CAST('20131201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD954F05178640D9F7ED6A32060FFD048AF1DC74312A6A51792B514CE50BC0E95)
  103. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  104. VALUES(46,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBA32DF42FDECD6F8E5CD2248D0CA97F8EE5929F9AE921E2DDCFE6D07D7D8158B)
  105. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  106. VALUES(47,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1B22058C7765CFCE379C4AECEF1F7F3C56BB823499D319381B40FCF5E828F58C)
  107. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  108. VALUES(48,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB121F3DD05E580D7AA3FE0CA64881888489A02123CAC6384D1019889C889AD62)
  109. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  110. VALUES(49,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9C32D872154561C76A109698DFB71AD934D480C7922358DA37397F2955A780FA)
  111. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  112. VALUES(50,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xED745FF36323A03F3A05F04E76B3B7917421889890AA2855054938F86C5A284D)
  113. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  114. VALUES(51,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x82764741454DCB88E3D69F20786388B11985CAD7F91468BB2CF3C01A19C313B5)
  115. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  116. VALUES(52,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA1D8D61189FE418D81792A568F47A32E7BD25B4E8514159148AD5A3918C033C4)
  117. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  118. VALUES(53,CAST('20151228' as DATE),CAST('20130901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x91EAB9979B5F9091A16CE2A1807F402A6880D4A6CB9B5A33A8375076D2217115)
  119. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  120. VALUES(54,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x309B8285769CDD889A9E11061CB379160615E948CBAC8FF4568160BB91C406AE)
  121. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  122. VALUES(55,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x67928321145B8FD3EE68CA1D8D1C4F1194B8D44BF0C88271145D5DBCD842758D)
  123. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  124. VALUES(56,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD8FEE714E0C247DE93E7110A8283E5EA25CD2D23C717FCAA69EB9040031DB846)
  125. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  126. VALUES(57,CAST('20151228' as DATE),CAST('20131201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x61B57B31DDDABF77C1036750510ED8CE49D96323E52CF3BBBC0EC3BECE6E5B85)
  127. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  128. VALUES(58,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB37815DF2B7AC7A44357F9FEB1A8981F35CA66256483ABC42F1C0B1449E8F4ED)
  129. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  130. VALUES(59,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBD8785725341CFF73BD2BE4835F2AA328DBD991F38D976C869009E89345F1D01)
  131. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  132. VALUES(60,CAST('20151228' as DATE),CAST('20140301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x237E9743F2D6BC35D428B006B552C67D7780DC343FAA2E2116AF4D3C0BB99B37)
  133. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  134. VALUES(61,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC0909A172E7B6FA7D2265427B5142395307360E0A9768BDCC89505D1BFAFDEB4)
  135. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  136. VALUES(62,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD018320FC30F7A73C49C6F456910C7ABD849B1D36823F0754B34C1211F2A28AB)
  137. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  138. VALUES(63,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE0D95269068A8BB574A57FAB3B38F12A313B23CA3F70906F24621FB7452A7401)
  139. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  140. VALUES(64,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5C7C2C6C4F881ECF518336CD3970E0B6CD030E79C05A3B92FE7264E827509F4D)
  141. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  142. VALUES(65,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8257D48D8323A745DE12397D91D6B8596111DC9661ADD8908842E3DAC04C5D95)
  143. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  144. VALUES(66,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x15E69026DB2BFA5FFB291CC3D4984B99D4B93A5BD6F48D1BDDC5DFF3DCA4DE68)
  145. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  146. VALUES(67,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9576D71D0763ABC74B17957BEFEB3668BFB0AED634D6D1129E2ED73A0A71D886)
  147. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  148. VALUES(68,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x4A7ECA4D3B0EBB47A3A3573652F2A5116BAF26A1C687310DAA7E9E3A36783B62)
  149. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  150. VALUES(69,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x30C74FAC42BA6BB061532F516AD60F4BF76857E80C0D28703DF3FE714F977A01)
  151. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  152. VALUES(70,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x010E90D5E17D819E2149BB96A895C7C6A864590DA973112416B0656105543CF3)
  153. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  154. VALUES(71,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB04320BA5F9C47230EDC64F0E6AC8009315BF6F09D1DB1AE3916093AECA69F41)
  155. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  156. VALUES(72,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x91B7ECD38FBF1F3E10339E202881F36D45EE0ABD712D83003C07A18D22C48892)
  157. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  158. VALUES(73,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD1DCDFF56CA8C8C84D6F9ACBAC418FA44BDB92C5233D0EC35D21E855F5BA1F95)
  159. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  160. VALUES(74,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0FE489B10AFAFEE0082B119252DBD3AFBFA0630904C1401FB9B978B76AE96F14)
  161. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  162. VALUES(75,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEDE4E6E47A3D78264604E0E71C6C87FD1634BB9B930A87B68B4B22396F46F61F)
  163. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  164. VALUES(76,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8746E445AEA67F87CAE5534F36C895088A9AA9A44DF75AEB5FF7E58D9E475AF6)
  165. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  166. VALUES(77,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5FD62E2F8B62ED6429529EC3AFABC19CA32DA917CC1CCA037B392B5A408914B5)
  167. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  168. VALUES(78,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x343118B702A27E86708E1D7966CF7A3722D51355F7E6BB74B171A5DA2AC3D7E3)
  169. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  170. VALUES(79,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x24377AB03C68B1035A6765FE82A531F6B43622B41AD67A28234D5A7BB54ACCC4)
  171. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  172. VALUES(80,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x65219941A2CACD363FE021E36502ED91AFB1FEE7D80A3645E8122F9AF05D3EA6)
  173. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  174. VALUES(81,CAST('20150328' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB861FD76EEE0E6316CE220B9868538738FBA3A5CEB9A9D41094D7B39909E74B9)
  175. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  176. VALUES(82,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xF40F2580688E9FA0B484030A1C1A3B0308A876F6D322E7997A7585A79EBFD4D6)
  177. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  178. VALUES(83,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE3F021A18B087E2DE5A8FD024DD3C5DEE84CE18905A4042A305DD8055AA2A1F8)
  179. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  180. VALUES(84,CAST('20150328' as DATE),CAST('20140501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD734FD0E8B1456446363B77362707D74B9CE26D863232CF1EAD8CABB2E00C12C)
  181. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  182. VALUES(85,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7DD2304C7FFD0B3A8AD357FB19A2C1AFF74170EDC9815F503F9E6F3BB4D02F84)
  183. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  184. VALUES(86,CAST('20150328' as DATE),CAST('20140601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x461EB271FF54E1DAC372168C2CE4BF98493ACCFBF673B57C277CD6CD0081C77E)
  185. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  186. VALUES(87,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD57899DA8F9FABB7B6A355A26438850AFBE4D974F71EA57D19DAE3F4140C716A)
  187. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  188. VALUES(88,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x610645E442FD8E9413EB15150B534C0657C601FEA4DFF02B2BA328369CB26267)
  189. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  190. VALUES(89,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5AA3EC3993ACB1FD78108BC4A7233F718903D051B65E3348942EABA7293E4C7B)
  191. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  192. VALUES(90,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1B68B2D3AA8825B518F8F4AFCB822A9CD88193AA3AB1AE0BB113E0958CA39083)
  193. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  194. VALUES(91,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5988D45553BA642104B334B0B72298374EC4A2EEE7370A003785E98B925990DE)
  195. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  196. VALUES(92,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE82660042EABF6C437CABB8B6746599609B40F6CA5962A8EBD37B8CD8C0D3BC3)
  197. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  198. VALUES(93,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x65CAFFED42725593A91DA85147C797D6F531F1ED9A380821C4D77F31D4BE0C96)
  199. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  200. VALUES(94,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBCB758B992AE513AF113D0CFD987A64F9AD658DC204919E7E276AF1FF7C5564D)
  201. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  202. VALUES(95,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x608EDCB18BD1F06826988E2D33C1CB8B3569A1328BF37BA1DD09024783AAFFEC)
  203. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  204. VALUES(96,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0071EBD0412F085ED5A0DDFC96B563C43B3C4506683D52F344925540C96FCD60)
  205. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  206. VALUES(97,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA50DF090244458F42956C4D91D9962765023B74B83DBD06714B7C3CE79D924AC)
  207. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  208. VALUES(98,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x233D99596264F29EE7AC8617D068490D0E7FDF7FA316803800F401837145BB7D)
  209. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  210. VALUES(99,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xFFC77CAFF91E066C55EF131F146F110821F67F15C27B089569A6540F976D0B53)
  211. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  212. VALUES(100,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x14635CFDE517DE39ECA6FE1607991D4B345B7589F9C6B12A812FD67A3B13B1EB)
  213. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  214. VALUES(101,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x876609067F78378ED532D762298C5B16612F6FC783CE0D65D18D9C55AD9A3DE6)
  215. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  216. VALUES(102,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x751A3F04F1547367132643DB8403E6F5D958F6B08FF8E7AB71E0AB896E2D7158)
  217. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  218. VALUES(103,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA12DB9FD8C941ED4C12C300FB2A6B2D5FD9AD3EAB40EF17BAEAB767FDBEBF697)
  219. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  220. VALUES(104,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0089975A998D9AA4C6B91D839244CE7BEF92A866BCE9FBF9C51549F8CA695984)
  221. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  222. VALUES(105,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0268E18C6002B2082036DB82D40B47D28D092DD7D34138A2A95CA22BE18E4B98)
  223. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  224. VALUES(106,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCDF7041AAA1CCDD88ED58D0E22788A43427EA28B519DCBDEB9C6D7A6CAC8D943)
  225. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  226. VALUES(107,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0C42C4DEBDBB73DF822F9DA5971B3BE834CD8594BB22CD6C71519FA0FA61AC22)
  227. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  228. VALUES(108,CAST('20160131' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB4A65E1976D5878CE22D7F9BF23F38326D0FA351395BB6274ED8E4E7CA59761C)
  229. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  230. VALUES(109,CAST('20160131' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1123F6C8AD670E80691E4519666D254D5685A8819DDB4823FC2BAFE267D00D50)
  231. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  232. VALUES(110,CAST('20160131' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7C85F292656F4C31491E44AA91B9C8C851CD96B875EE082EDA8E3D1B79D59929)
  233. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  234. VALUES(111,CAST('20160131' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC45D336114E61B0BE633AB6E146AFC7743E8684DEDCF4DCA63BAD5115F370AAF)
  235. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  236. VALUES(112,CAST('20160131' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6B8BE8D5A7D07DF231FD88B9CB1A2681753157E4C380462F8B7D3C8AFF5516DC)
  237. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  238. VALUES(113,CAST('20160131' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x713CD69E526EA791EA44E44E10012C4C1F04E772D494A9A48B843B9DDE3515DC)
  239. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  240. VALUES(114,CAST('20150728' as DATE),CAST('20150501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7B88029BFFDC4D74F5AD4A8E78E87C871E7E7617BB62BD7FED745BBD0452F667)
  241. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  242. VALUES(115,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCA5580ABEA0339BA2060B8CC44678379B8EAD04B94397E1BBE2AD7C293A40B35)
  243. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  244. VALUES(116,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2AFCF571CEC2AA9CDF73E6D3B7D294BF40AD58FE9F9B2CC67046DDD3B603586C)
  245. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  246. VALUES(117,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3B8347D323ACE25D9594D22AEB5655B3E394075A6FCD33C7FBAA764509B11424)
  247. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  248. VALUES(118,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7F1E1E71DF0DA75605D37878FD30A4549157C1BB3AEFB413BBF15D9CBDFE5C68)
  249. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  250. VALUES(119,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x91D5F9C446E31D9692936AF74C7BAAACC516D5EAD6C2127ADF47279E770BF22B)
  251. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  252. VALUES(120,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBD110294CD8602C239683486BC09D0992BFE4CFBE6BFC546FD17E7453D21941E)
  253. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  254. VALUES(121,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1B97C2C0443366413818537CAD7A1F8BD356185BB374CDC445726CA5CBFD0807)
  255. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  256. VALUES(122,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x135830794FCDE90FE888A9EC4725A14E464850FAB0B52E2A3BCA6BCFD1CE8514)
  257. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  258. VALUES(123,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x81E766EE3D721E652C70D4644E5D053A8594DE5D2CB7C28F2301086A0296B6E8)
  259. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  260. VALUES(124,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3A9B5C1010956144170C7C8A2217187C83E362697989A394B602CF3D6EB9FA38)
  261. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  262. VALUES(125,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x60EE87D53B34D095105FECB7A2F9E7B432069E77C5F671F90CE9F0ED3C64CBCB)
  263. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  264. VALUES(126,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x493E74053F72479C16006B9A3DA1FBD50CFD47418809B4F2DAE800597292C535)
  265. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  266. VALUES(127,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x689BEE29D53E38AD2886267EA12145CC94611C85A15B24BB3003732524D4EBE6)
  267. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  268. VALUES(128,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x220E63DE8F9B97606D88DABABAD4EF392A608290B1E23D8CDDF0F7247307F51D)
  269. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  270. VALUES(129,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6D96AB3EBAF4C3C02A309FDCCDA5A96D719929F5DF08FD8A67246A54066F6FD7)
  271. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  272. VALUES(130,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC813FD1BEACCC253E6558653946A60A823DFDCF7126880588FC6FE6DFCA9FDA8)
  273. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  274. VALUES(131,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x52642BE75DF21AB229B043F65665FD2405E50461B5FAE1690E71D9E6BA997068)
  275. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  276. VALUES(132,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xACD467986D320427FCA9C9D7EB15A1C85EC8103CD8EF8AD668C621F9256A3FDB)
  277. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  278. VALUES(133,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x41D68894227BC228E6120F847E43804414A73CB5E8AA304CECFB297317216797)
  279. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  280. VALUES(134,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8014CE4C2A8B31CEBFE70ABCF3710318FA23BCAF8E2BFAC45E64662AB54B9E78)
  281. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  282. VALUES(135,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBB9E035F0EE39091C03B8034A92AFB43C202A1BE9349798DD7698C636F094642)
  283. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  284. VALUES(136,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xF6216298078412B73D444CFC07D5E6DFA3DAEF4D39648C5A26044D7C4DED0265)
  285. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  286. VALUES(137,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x378240958F16C8EE9A8DC98B9C9BB64180A1DB47ACEDCA58F687427404D94393)
  287. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  288. VALUES(138,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5773D0E4501BEB4377880769F6B876EC8107A26C5E5B6A8570E5EF1E3EEE42D5)
  289. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  290. VALUES(139,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xFFD5799129E15ECF6AB3724ECABE273B0DDD0DCBAE499F83B421C3129DD7645F)
  291. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  292. VALUES(140,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7082F7295A4A0DA5927D8AACC6ED7C97B0325B26CC612F46B1B9EC31BF7BEC59)
  293. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  294. VALUES(141,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC6B9137F2D5C3EB34891658D95CD5D25252C8C3AEFB304E199569C387A5145A7)
  295. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  296. VALUES(142,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x99D2B26CBF3EE0684D0742DF5626F8E66B7D94C73588F319AA23A6645896CEEA)
  297. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  298. VALUES(143,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xDD6788A6EC57B966EE46A5D67B98C61EE2C0F55BFB443258BD0018DB1D4773ED)
  299. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  300. VALUES(144,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCA68B719596C8FB6A36C05F0624056FB41794FCBE95BA5BA97D373F65C8719C7)
  301. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  302. VALUES(145,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA6AEB7DA25D12FEFF058070EFEAAB75211D3AFF49496DD83F8783F5E87E07361)
  303. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  304. VALUES(146,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB8C3C7349BE303536397AAA963E58D2777EA568FA64D13030263E7CA6A416E9D)
  305. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  306. VALUES(147,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x25198653CABB212C8BCD79C5D467FBD1887E0A1759F94AC35D83E63D6DE0D4AC)
  307. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  308. VALUES(148,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9C582FC7504F63819636EC66A0954399C7258C50A891855D396EAC6EF4A223CE)
  309. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  310. VALUES(149,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x74387B526BA550115518B6D63BC88DA42D07FB5D7AE5C9DA5124CA7386EDC11F)
  311. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  312. VALUES(150,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x919A2B089E547AE900CA956F3B6B47018E18D6050171515473625471B13990A5)
  313. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  314. VALUES(151,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x631AD5F8DB75C79269C43F638D6606DAC4298B723859C25BDBAE030A57961318)
  315. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  316. VALUES(152,CAST('20150331' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9196A3BB33D8E35A3CF3B1D1213BF5091464F594F21B9F2FBDD3DC6F310C9A13)
  317. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  318. VALUES(153,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xDB2579972BB014F3BB16761D710880841D3B77C2332989EA646F5AF7CFEF1EF8)
  319. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  320. VALUES(154,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x949C84F6C90AB6A5BA571262FE2A2476ADD695853F92C9FC89F274D07C26B203)
  321. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  322. VALUES(155,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC399805C07E1D55EA13FF5827D798C1E491C3C7DBA4466A079A7085D70DB1758)
  323. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  324. VALUES(156,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA1E5029418BEBFF59235715D335FACA59098583608C633F7E1283611A4927F55)
  325. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  326. VALUES(157,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x06859DD933F5CF541A42DFBF192709A2FE05F91894CBDA10B86783A65AA87D8A)
  327. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  328. VALUES(158,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x83386209AD2918BA672E969B6C820ECCEB156C255136BCD94D81DCABC9E9BD7A)
  329. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  330. VALUES(159,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9689EB9A20B3A599AAD77C02F007557ADE1B6FCEFB449EC538B7E5023C4F804A)
  331. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  332. VALUES(160,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9EF37C994FF7AB1B50CC8C0FE9E99415D84D0280E97302B1FD55503B5D9C9F1D)
  333. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  334. VALUES(161,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6135D2B83C6F2462B135AC6624D42D453F71FE3B34F3F719C4F89F79622B55D5)
  335. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  336. VALUES(162,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0956D7824806BB1C2F135DD36535134BF47CE359AC5E100700962C87F05C2FFD)
  337. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  338. VALUES(163,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3FB853D0D8D90868CAE5D6DF1C0ED7783988828611D032238F373EEED47B62AD)
  339. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  340. VALUES(164,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2014BF625D8E855A3DEDB13C82C3AEA326E58067EA100D24C246CF71514327B0)
  341. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  342. VALUES(165,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x985DC89986EC0F689CEAEDC180803D4E23686DDE121D2E7538753209D9BC5293)
  343. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  344. VALUES(166,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x97E66AB944DAF26E2F1F98F6255FCAB0F8303642E350448A27A47D6148CA2675)
  345. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  346. VALUES(167,CAST('20160131' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x04D3A7A97E1A598AE3699B2C1953CADE7F43D6CDF1B8201A66D6C3BAEE83269B)
  347. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  348. VALUES(168,CAST('20141031' as DATE),CAST('20141001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCF8A13F96C3E9DF0E68348F67FBB17BC86432C28E6082322FD5819F523105D04)
  349. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  350. VALUES(169,CAST('20221130' as DATE),CAST('20130201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD38487D42E9672D2405F20D83C9C1CB0D4CE92144C6D874732EBBA219070FF83)
  351. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  352. VALUES(170,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC00C3CEA7B6B92A008CD6F47E0C0DDC2E77C68D7FB436324233C71F8923B9750)
  353. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  354. VALUES(171,CAST('20150430' as DATE),CAST('20150101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8B7452B22D74135366AC8F0D380FB520480588B25FACC17CC73C06C3CEACEE41)
  355. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  356. VALUES(172,CAST('20150430' as DATE),CAST('20150101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD3F0E1D061B989C268BFDB846C50CC66A18C9925184CC8086589D37300D4CC51)
  357. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  358. VALUES(173,CAST('20150430' as DATE),CAST('20150101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE882530B90221B2E84EC8EA6F799D409A9627023DC624259D3CDF08C68CCD554)
  359. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  360. VALUES(174,CAST('20150430' as DATE),CAST('20150101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEE6C126676544B7040DB2A09AFFFDDAF3F310EBA00FBE807CB1731DAB42DF74E)
  361. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  362. VALUES(175,CAST('20150430' as DATE),CAST('20150101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x26C9A2E5B96A7C957584C8EEBF58AFB5CA493F6C9B09901204E375A62500E79F)
  363. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  364. VALUES(176,CAST('20150831' as DATE),CAST('20150501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x022EDAA5108C5D450F3B184B9901FBA6B1241A7089165CAF118871D75D0CEDCD)
  365. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  366. VALUES(177,CAST('20150831' as DATE),CAST('20150501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x549392691EA530B4ED51B19E09EFBE8AB5664946C62428C943DFFE55456D700B)
  367. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  368. VALUES(178,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB7093A33A9044A606849DE145F4E2B28FE46044C8BD7AC70FA90ED7B0A9114A3)
  369. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  370. VALUES(179,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x23FC005542772B02CCFC865FA868539189898CF70365051B7B40289F96F9CECC)
  371. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  372. VALUES(180,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3717A590D4C4D8E53887EACF131155193867E0635C4E28F7B96EAABE665C2A85)
  373. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  374. VALUES(181,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x55B7BA72116C6013E81947E55218DFCA80B5526307AFE0B60167F83F605508C8)
  375. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  376. VALUES(182,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xDD4821F54FD1D98300C41545FC7965CA85312F8310EF50DDD6125714FB30835E)
  377. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  378. VALUES(183,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB897FF57436825FF1B5CB62FC478CF0C8F981AA00E2CD2904EAB06BDC3B0B5AD)
  379. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  380. VALUES(184,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0A938174BC15CD43EF89BAFE75E91D09D1995C285CADFA37618DDA6E336972DC)
  381. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  382. VALUES(185,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5C28D017682D7ED658460D203119B3E7CC6A9E4E017E938AC50E84FFDAA07243)
  383. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  384. VALUES(186,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCFA34BD5F4846C5515FF7889C54004B1F842D0F362E097497703B01CA3A6989E)
  385. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  386. VALUES(187,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x884C3AFFEF5E64D3819199F0722590853E13492E30B1D6A79CE58D065AB84261)
  387. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  388. VALUES(188,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2E3F4DFA1BACFAD0BEEB1A6A8D4B9986D7C13DDABAF1B23D46BCF9873810A385)
  389. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  390. VALUES(189,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x79E43E5554268C9BF4905A21DB09CC8F3227741858416ABD70FE6CA0C860276E)
  391. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  392. VALUES(190,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x19D631F80B7CB883F017B70D877AA8758F3EFF26E717FFA178436EF4072EF5AE)
  393. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  394. VALUES(191,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x400C9D828947DF8CA5BDC2F90F84460AFC10A9F3E02955D8F8E0AD840AF50E02)
  395. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  396. VALUES(192,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCD1FD85DA19ABD2FD35B1CAA3DCD1E1ECA82C96D9F00BD1FD747B1F3BF4FCFA4)
  397. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  398. VALUES(193,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x19C280A2120EA8D4F81CA1BA89A93A89FBDBF07BD7B0356D8BB055CCE6836EEB)
  399. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  400. VALUES(194,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBB1763DCE5893BDEA9052FF936AA6FDC74538CBC4E7352D6E7A0248E35415360)
  401. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  402. VALUES(195,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x34E2DCBE5915678DA00FDC6F1180CA36F767C896E49C1BC0531A328CE11C519D)
  403. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  404. VALUES(196,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x71F61A23EC111B5401441C906B90622CA406F99BBABE1ACCD63F753844DB04D6)
  405. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  406. VALUES(197,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xFCD5F93DB99FFC9A4EFDBAE0E727F48B55077BD88E97EC6C058ECA977284E0EC)
  407. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  408. VALUES(198,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x13276CC034EF6EB0FAACE4857468F2E33CCDC1372332A164C35332B33FECF0FA)
  409. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  410. VALUES(199,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1B9776C0015298A6EFC0F19EF96E40E89329CC0D2113CCAAB99C97C734E515FE)
  411. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  412. VALUES(200,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6AE9E8C83877D011059BBB7A7B309D08A318BAEB0F22CD6ED18ED63E42D3444C)
  413. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  414. VALUES(201,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9D48A350C2C35FC9E182916026F286392FDA533EB8A458B6E5818A61550F1555)
  415. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  416. VALUES(202,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3B5A94E6944875573E534EEC1F2EB843AFFFC42EB06CD48C067A851E791CC4A9)
  417. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  418. VALUES(203,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x52FFB8E8B455C7925740DE69421D92B315CF5C6A9D73F700532AB07AAF66D87A)
  419. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  420. VALUES(204,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD8C4E8312D58DB512644A19353D44476B28851FD041EAA94709178EDDE2B4161)
  421. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  422. VALUES(205,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x869C9D61F21A84A7C64F0262CFA46DBC220B0903BE9458C6C136D07FA404B9E2)
  423. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  424. VALUES(206,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x07E038281C63534C2FACAB9D464C24C95CCDEA05CCEF3E32D4EE8FCFE014120B)
  425. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  426. VALUES(207,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE7AD583BF83050E27EABFC11B1537033282438EA659BE998A846CDE869A806FC)
  427. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  428. VALUES(208,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA7A429F3522D61D90BC4B2AD88FE1F10B486287F533BD68D5C280AF0D799DCCE)
  429. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  430. VALUES(209,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3E3E73ECC358E1B1D3200BB97BAB5AED0917C1AA4C63BC7A49EBA091630B180F)
  431. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  432. VALUES(210,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x187F2C7BC95E7D8D41190BA0B3EC217B1EA79B6C1429EC42622083A7D8EB925B)
  433. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  434. VALUES(211,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE35E6990DD74EFBEA9EF0911704A18A545F88D89854C430D0F7512181E7F8C96)
  435. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  436. VALUES(212,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x98EF4975880C8CA5153D4925F637966349DC8BADF7FE617B216B579C6FEC6F30)
  437. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  438. VALUES(213,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x85EA47C03A7B8B62EBC7F8F209320CA876A7698E5AEBE688AD32A18913C186CF)
  439. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  440. VALUES(214,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2D9906D3E75FDA254EFAD14437A0317FCA7815CC46755A5E9425D4D8F9B29583)
  441. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  442. VALUES(215,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x50A9F4861E5BF8E05DC8BF08A0146B58DF078D55227F771F3B1CC45B2053999C)
  443. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  444. VALUES(216,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA5C1D0A07807B8E340BA50D7C9114CAA8B8F5F4BA5CC9B819FB0657222D16A24)
  445. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  446. VALUES(217,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xAF60174628D9CDAAD93C0A20C8C95CA1A78C508D7684C4B9AA9C2D7A8F926BBE)
  447. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  448. VALUES(218,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x198FB8E833F434D13DCE22BA9B52A79E123BB542000237990749FC0C8D75859A)
  449. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  450. VALUES(219,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7AD076717A14DCCC077A5D2002497C1791ADBA62749913B664DF38B0C96EA7EF)
  451. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  452. VALUES(220,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB6F243544D69CD99085A6ABDE9AA76D2FDE13DB4B3DE2B1353B8FA45DCA9FAB8)
  453. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  454. VALUES(221,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x42CC8B597F0A180038FEE535F315DE407DB42AC8204A77CE1D743D6036362AFE)
  455. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  456. VALUES(222,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x72B27B2AE69FB9090B4270862085E0A1525E7A074BC8F927E824FBA9EFF644DE)
  457. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  458. VALUES(223,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x61B9223763BD7FF1146B3862C3926BB506F2258FE6490F9AD740E88771D91E0A)
  459. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  460. VALUES(224,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA514EC6E6F4FBC0BD454101953EE45A9743D0A48A6EE3C9BF50A266769504CBB)
  461. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  462. VALUES(225,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x743B790C4B1B5EABFB9D229525E545CA85CE3347FF642A0D2FE1F46942AD5802)
  463. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  464. VALUES(226,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x05E90DA231FA5527FA28FC225424CF45989060DBC2260CD58FF5E4E0D7B0BF82)
  465. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  466. VALUES(227,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3EE3BAAF5038D5DE519CED7D7E30B5DA31825EC173C3B72B1E88F4FD04B05F5C)
  467. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  468. VALUES(228,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x05CB228A96365F1783CB2899F53D7763A21D0307714EE598AE449344A7308BAF)
  469. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  470. VALUES(229,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8D9A9250D1832C3C4D57E2620E78E6AA98A6C3BC157764D08F7C94555C8C367D)
  471. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  472. VALUES(230,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBB8816EF7CF76C4507BDD9FB1211143DC4D2226D737E080040787A139F76FD73)
  473. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  474. VALUES(231,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8E606272109BA2A71D1513F9CE086C177B1107D58E5076DD87B65F490424DF40)
  475. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  476. VALUES(232,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x66713D02BBE03D84A23AA1759B4E9A5DC3E6B6A58E7FCC2FC69B256B6F2DB8CF)
  477. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  478. VALUES(233,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xFA73761198ED6317CE9F7B4E0796B57B3393D3CE9A9971795A18F7E4BD112A22)
  479. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  480. VALUES(234,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x965DA69D0BC73B2108F3BD5DEA79ED0AAC0B1935057217ECFBEAA873E31F7C03)
  481. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  482. VALUES(235,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8B72BC82A6690685E8F841D584AEF05A3B9BA7D8E17ADA1036B08692745498EC)
  483. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  484. VALUES(236,CAST('20140430' as DATE),CAST('20140101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEFB46F8BF72B3F09EB7138D1B59A1A4CAA9C739B06CAC34AA29E3B4EEA85EA08)
  485. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  486. VALUES(237,CAST('20140430' as DATE),CAST('20140101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEEC0C1D45F0E9B008B9AC62FD822424D502CAB028B23B58B688916448F6489F7)
  487. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  488. VALUES(238,CAST('20140430' as DATE),CAST('20140101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x415E83B29E9986AF34271E5D8C7CC9CB9CC2BA01A9030CCAC606E7C0B8F9C598)
  489. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  490. VALUES(239,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC048C7D575B600E2E763197FD24A755BF7D9C9C16F599EB8FA1817937F0E9A27)
  491. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  492. VALUES(240,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1091C6FBB88302B96AF17A2328354074C116EC7A21726D125B27F1ACB7F2AF91)
  493. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  494. VALUES(241,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8669B3BC667345ED400BED1782A25D29400854F58944059518AC20590A4CBCCF)
  495. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  496. VALUES(242,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xFB102AFE1CF1618645C146D00D417DA050BDA681527C4E7D42E2C6AA71394C1B)
  497. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  498. VALUES(243,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5AA00425668622354688F6B257C675AF9E3777A24EFDA81342415B07E5D7998B)
  499. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  500. VALUES(244,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE619A3EDC151DCDFE4C58A88DB6A0654D444063D096859DDDC4F8B7598F14CA2)
  501. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  502. VALUES(245,CAST('20140930' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEFC3F1C1A15715590EC281C7B236E9353BF28CAF3AA9746AD42BDA41A2439B6F)
  503. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  504. VALUES(246,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB4E2550DDEA629284A347C042389DB92A35442F61899A278C59B0762EF618189)
  505. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  506. VALUES(247,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7ECC8130168CC400242746BDE0B60738116FFF68BCF3C994C4275B64CC108150)
  507. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  508. VALUES(248,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x56CF1A536F01F6CAC93A09B5037F389467D7F8B93A6F6949816A787A762293F1)
  509. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  510. VALUES(249,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x73CD9014B6C5822C334E91FA426150218F68298D2D98A5988DB2D5DDC5A2D9F1)
  511. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  512. VALUES(250,CAST('20151231' as DATE),CAST('20150901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7CC511C4C1F10482B6753BED8CE89C4A6BC1C9EBA8206C78A86A3C1F55A5177B)
  513. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  514. VALUES(251,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9138592D39D77702ED51DAB41499FDBA563F57704BAF083C750307C948B0413A)
  515. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  516. VALUES(252,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCD4DFA1E0515436C6CD0BF59C88141C84D7B49A8721F0F505C5F7B2DDAC1A679)
  517. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  518. VALUES(253,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x18E291991EFA340A3FA39F6AC2DFE4D54ABC5D9CA5470BD5D15B16887F9025C9)
  519. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  520. VALUES(254,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3587BFE0F53F1BEF3A53E43B43B663CFA0A41FEDDA73BAD990B0799BEAAEB61F)
  521. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  522. VALUES(255,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x223F4D27BB4192E255D03C938E3234693644BD40DB55E06F07D9C114B985306A)
  523. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  524. VALUES(256,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xAE79123BDB95C516550F9BCA7D73C4E931FD59D60B5902D7FF88194E7912FCEC)
  525. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  526. VALUES(257,CAST('20160331' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xED80C2552A05185A313C5A6B8C3B6FD251025FF847AB3313627C4E62776E1358)
  527. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  528. VALUES(258,CAST('20150831' as DATE),CAST('20150501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2ECD25904CBDA5B87BF45966433D0D871FEC6AC3ACBBB0524BDD20C250257CAE)
  529. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  530. VALUES(259,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8F2B42B16DF9CEF1F3FD1091AF2AEE7016DDF06469BB3ECB878C4A25F34168DE)
  531. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  532. VALUES(260,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB3186CFC9083DCE187C714DD299343602F5725E0D820040DC882A4909CFD48A0)
  533. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  534. VALUES(261,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6A65B5626A59D7F432F3DEB019CDA7D013AE073194F98B344ED145D4636D4C40)
  535. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  536. VALUES(262,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x4A2FF758221461CD2AD0C311D81917FC524A91A85C0B59C529F4D4C83936AACD)
  537. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  538. VALUES(263,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x26D5974401A488D40C19099F658CB64905EF0A91B2A98E18F532F9CE750F7E00)
  539. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  540. VALUES(264,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD7EDF4BFD7BD47FC2817256F3233B80FA86FE6095FBDD1B6E685BB82C33921E9)
  541. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  542. VALUES(265,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x94C1D18CE5AD646CDE62BDD31FA225AB541A3A790944D20F1375DA66952BAF85)
  543. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  544. VALUES(266,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5D5939ABBC53F66EE7F53B0131A2D44F24EF103AFF1F3897E1C3EEF4ED2143F7)
  545. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  546. VALUES(267,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x47F8E9F66C7F8E3A7C94C38A116137CA954D05BC4376FCCB3B8931DD7ACFC073)
  547. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  548. VALUES(268,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5AE1250C99E061D983D30558747AB8A7DF31AD27110A907D489E705E2C22981E)
  549. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  550. VALUES(269,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9A194BD1B3F005551785549EFE6BC64B8645819FBA0170445536EA4340D43952)
  551. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  552. VALUES(270,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB925BD8971968507695724DB866DF16A713AE9607337912239CFE50FEEFEBA7F)
  553. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  554. VALUES(271,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2B1C5A136776DBF20126E5A7C0F9DD5D8A1E88DDFFEBEB1282D052EE9ABCC79B)
  555. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  556. VALUES(272,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x00E9BFFAF13E4A6F1F9FE8AAE37500F067B0C3C3AAB8AEAD25E847EE86F50BCA)
  557. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  558. VALUES(273,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xDEF47C885A8029A4340509028CAE45145E4CE8F2EEE191428D9F9853FA3221A3)
  559. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  560. VALUES(274,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x346EA2259F9C73014F94F25CFDA356C1DEE3F09202A93FAE4EBD5E7B1F1D2330)
  561. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  562. VALUES(275,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x369CC4EA802F92F7638812F68B159FF644AC774BCDA47A02A5D07E3335958AE4)
  563. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  564. VALUES(276,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE4E977EFCE5BF5057F3819E13830C771D89DD401DF33EC462900F5DE4F131EF5)
  565. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  566. VALUES(277,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7FF7E8E1732F3F6DD98F093D764DE805857D66581EF151C3E835E03171EC6336)
  567. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  568. VALUES(278,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xCDCEEC74AA7E3C1A2B52D50222E93CD032BD403620307A5C2CD9D4FD9C861B67)
  569. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  570. VALUES(279,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xAC619B765033F43854928D1DC8523C249B08BEC86940BF65C48100BEF7217113)
  571. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  572. VALUES(280,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x16105A9AC5B7637FB4A3E50B067D67B899DF3596F138CB3CDC93055F06E06812)
  573. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  574. VALUES(281,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x4E61013A8CA0BDDC098FF941D8BD8E6C46C62419ADF6A9D81674C59F9BBF53C3)
  575. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  576. VALUES(282,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x84A38457F4E70ADCDE0CCD3F669A7B118A6BD0AB3BD955845F9070FF6D40B6B3)
  577. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  578. VALUES(283,CAST('20150430' as DATE),CAST('20150201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1D710FFFF9917DBDE30C2C61052B7ED7286CAE58C0F42E85286910A25B933C01)
  579. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  580. VALUES(284,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x03B18AEC57E219F142BFB5D96E4B867D58A8ACDA845590746751DE0D269FE1C4)
  581. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  582. VALUES(285,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE6ED79E00B4FCDB9DF4123CB8B8D7AB53B666651D1746EE64350C469C8E6F735)
  583. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  584. VALUES(286,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xDF169EC934BF0361AD2456C72C421BD06193BCF9B03EC0E4E6B0B5D998258C99)
  585. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  586. VALUES(287,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC7CF47A5D34AB97447F0BBBF6CC029A231CD8CE553B16ED1B399D961C1459EC5)
  587. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  588. VALUES(288,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0ED5ECD7E6B6123629873E1B37C6419B35EE95A5E1376B35C1514B9891BEFF34)
  589. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  590. VALUES(289,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB03B09C72845A3BADCD174CD6E5D0748D64BC88AA30DB2AD2641304356C25FDD)
  591. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  592. VALUES(290,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7CF613CDDBF4B39FAC2F8E92A2DC86770BA7DE96C71D3901E7E14B7526C8A2A4)
  593. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  594. VALUES(291,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9B90A291D0413CB1BEE3387145377FDED5FB9E248B1BC68E0F0601BDB03A463F)
  595. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  596. VALUES(292,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xA663F0AFF5EBBF2864403476C41EA9BC9D3172D6DA31C092247262FC4A9976EC)
  597. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  598. VALUES(293,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x16A94CE2F1BC82E2BEE1EC04874ED22EA760E0A02B52E5E742E3161FF8FE9C8F)
  599. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  600. VALUES(294,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBBA4659AD9CA7AFFEF7B7E12B010A4FB3BCF55C55B06EC88758B246BED92E209)
  601. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  602. VALUES(295,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x86DF904F2170E4AF9EA60F54E9F71A2C38E568131DC7FA47FBFF9B8396470983)
  603. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  604. VALUES(296,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0B741A241E0CEB4C89DC25399BD2FBBEB9AA1CC5933E454499D8F3D8A26240D4)
  605. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  606. VALUES(297,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3634171B53072C159813EF7C5962BD1BDEFBAC097ADFDA4CB447D1F653C977ED)
  607. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  608. VALUES(298,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0A681B9E1FF5D754893193696EBEA53371F4172E135018889FA8BE53F2ECCA4F)
  609. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  610. VALUES(299,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9E0027F11C4FD20342418FFB1B500F782DA9375A14B8898AE4A643C726EB02FD)
  611. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  612. VALUES(300,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD71215B094F4F52AEFB0D651D4706EAF79910019BB066F9F2BA3462EDC3DB4BB)
  613. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  614. VALUES(301,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE756B9316A7C37F82C59AEBEB606A5F5EBDB647E2DC59B6C8260E18F393D044C)
  615. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  616. VALUES(302,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2342329FF26976D4A8C8B25A698FA5BC988617A40244E196DEB60C7DA0186312)
  617. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  618. VALUES(303,CAST('20150630' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB4BB2785C231FFD54F73C92C16B1BEA3821B4EF06DF4D222B26CE8A79EF31E0A)
  619. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  620. VALUES(304,CAST('20171231' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD63EEB33FFC2A7AA194C8F58DECE295AD406363E605666F6019142D55717DB96)
  621. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  622. VALUES(305,CAST('20171231' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6BDEC576FDB33229861A14B5127007F0FD384F8083ABB7328C6C8AFC7FEBD8D9)
  623. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  624. VALUES(306,CAST('20171231' as DATE),CAST('20151001' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x87A410D874CF68C8ABCECE37026E9F3536D1F9D7C3F34840BA735115662A7520)
  625. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  626. VALUES(307,CAST('20171231' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x74BDAB174BAB1A39DC0682AFA5023DF07E96CE971024E321CD621A98CC139864)
  627. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  628. VALUES(308,CAST('20171228' as DATE),CAST('20150501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xEC622A49277EADD444E877F1904E1859A12BB0EE8E15878C28435E73F1FAAC82)
  629. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  630. VALUES(309,CAST('20150331' as DATE),CAST('20130801' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x66565EB6F21D7663D729CF12720E5BEBDEC7C436B23609BE67F96AC9813DD643)
  631. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  632. VALUES(310,CAST('20161231' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1E0EBD5B082A49045245A0944C57462DDF0EE071B431E671CB02735A9FF7070E)
  633. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  634. VALUES(311,CAST('20161231' as DATE),CAST('20150501' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xB7DC059CA5A4DCD27D378384702D37FD24E8CAE24806C46A86E7AE172E819D12)
  635. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  636. VALUES(312,CAST('20171228' as DATE),CAST('20150101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xDAAC389C676E18321EF4AFD0BB9A52CAA80F122934020891B47DFA9AB0C81E46)
  637. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  638. VALUES(313,CAST('20171228' as DATE),CAST('20150401' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8C6266871BE81208DCA7D13900441DB28AAB68EA850BA61638B1E2A093B7CBCD)
  639. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  640. VALUES(314,CAST('20171228' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x04C8F344282B293AEFF936C377FFAE09B78AB7D7C1869549F70421C9A99D495C)
  641. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  642. VALUES(315,CAST('20150228' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xF8F55FD947DC737A12BA8F8DE9CD8BFD35C776EE9015CD86CFBC7EA0BF26AA15)
  643. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  644. VALUES(316,CAST('20171228' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1205F699736B0222165D938B5E311AA30DE7E3B81E31D222697AE75302D90A93)
  645. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  646. VALUES(317,CAST('20150228' as DATE),CAST('20140701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD1D726CEFB8D51794C04BE56954D9E0FB06EAEA58AACE4E14A17BF8505F86E04)
  647. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  648. VALUES(318,CAST('20150228' as DATE),CAST('20141101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC79BEE22FC92A2C633F4A9712B69A9E1A3971A134449B8B61556CD73C624EF58)
  649. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  650. VALUES(319,CAST('20150228' as DATE),CAST('20140901' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x28ED468D6CAEDD9899FF0EF0F19522BAA3549E891599C66DB5C8A983CB5F0A68)
  651. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  652. VALUES(320,CAST('20171228' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3EFD1A6B570640611626617B88DE71FC5FB3FC6BB4BC140FD4E3FB3F5EAFCAE0)
  653. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  654. VALUES(321,CAST('20171228' as DATE),CAST('20150301' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2F0E54195E77739B6F238134EF611DB2E7F81912989E952187C95A5BC78AB32D)
  655. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  656. VALUES(322,CAST('20150228' as DATE),CAST('20141101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x932F6470E2E5D45CE7BA59283C9AA702B8E91B05F237BF97A28139480D6E09A9)
  657. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  658. VALUES(323,CAST('20171228' as DATE),CAST('20150701' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5217BE7B3E2999098620CAB9C4EF3D3F884BF0C8FD8F42175ADCC53B07B7EF92)
  659. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  660. VALUES(324,CAST('20150930' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x9FE4E60FB0546BC8A6134C4E8769DA44EF5F8D07539BE2180903E684780448FE)
  661. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  662. VALUES(325,CAST('20150930' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x551B8173B26F0010F235C95E98B0C3F8EDC3CCD9FA3EC370F552CF3E8DB0CC5A)
  663. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  664. VALUES(326,CAST('20150930' as DATE),CAST('20150601' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBD93C2075D4DF8FDFEBCD67B9A7A63A9389A748D5FB1444689C15E10522144FC)
  665. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  666. VALUES(327,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x716E31B5E0CBE933473C7097BB373B85B4B20A989DF5F536080C6A5FD9FECBB4)
  667. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  668. VALUES(328,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x03F7179861EB16C397C5E60F98D47658648DCB4D6A39C55B9D14D74F7F85E13F)
  669. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  670. VALUES(329,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x8A19D5802D8D98202975F3E3EEF2A80C6FA7805717020EC0BACB6784A49566F4)
  671. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  672. VALUES(330,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x2C50E09CB3870950D372E5C604D056F4CD983D507CEB3BCF0FA2322303BDC009)
  673. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  674. VALUES(331,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xBF412F46176E8838B83840FA288A33A8FF763EC810FDFA2E58AE7CBBC8908AC2)
  675. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  676. VALUES(332,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x44442E692C51A1C47CEDADE7B7264D4B6E80FE4DC383AC345B2F7CA3581FEB74)
  677. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  678. VALUES(333,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x6B13E49D4341AC8F273C716862185733FC7CFE407A607CD180CEF1A9DA697089)
  679. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  680. VALUES(334,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x7B941B2D1DB445FF4489B6D8C3F5E8E6318D001E0A418601EBE1610B80B81B3F)
  681. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  682. VALUES(335,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3E4BC4E8CDAD0E2EF60C4584897C36E3BCBECC55DD7698BA7299483A51F2E684)
  683. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  684. VALUES(336,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x283C2617CE229A32D52ED6BA781E4E95038CF736426C6D476D07F31524301A19)
  685. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  686. VALUES(337,CAST('20160131' as DATE),CAST('20151101' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xE457AFFD8C6060321B03C963BBE79AFDA55161BF287867D304EC4BE8D049FA84)
  687. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  688. VALUES(338,CAST('20160229' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xC08DDD0E95B709066DDA1BAB833CF3DD2C6377914F9D6E01368EDFBF058E58AF)
  689. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  690. VALUES(339,CAST('20160229' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0FBCEEFDD6C4D9CAFF45B81CAC5CC815101FA66FD08AF0DD7F42B2B023F5552B)
  691. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  692. VALUES(340,CAST('20160229' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x1AEF6028952AAD7601E37B7F2AA75EEA39075BE0D79CA4C3A4727CC0460CCD42)
  693. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  694. VALUES(341,CAST('20160229' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x50C491C9A02220AE0C1DAB0B713362D5FDDBE3004ED8479F14AA9FFF1861D417)
  695. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  696. VALUES(342,CAST('20160229' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5724D831704A343110E9E9E099F4E3FE990BA2C10071AD10A6CB0BB997981325)
  697. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  698. VALUES(343,CAST('20160229' as DATE),CAST('20151201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x16B91BC3178C04948F4F810E8743C9522DF25DE8ACCC301FAB541BA125EF8ABA)
  699. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  700. VALUES(344,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x0D5995ADEA75138F85EF32B89541FE1C9A5C3198CAEE96256B85974D8D68CDEB)
  701. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  702. VALUES(345,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xECD0740987C138E2E6ADBBB3DE889233110616462FA4A1665C8F8C27D140C32C)
  703. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  704. VALUES(346,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xF0B3DF28E1D0A739C546A1CC7D5DCCB7BAEFC19694AB45FF7789609477854162)
  705. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  706. VALUES(347,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x5AEE86AF672AC3BEB8833EDE559721F24ECB7191F5DEC0068143F76CDEE9B55E)
  707. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  708. VALUES(348,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3C6041952CDFE38FD8F8F5C1F56296C73C4F1E8B0A4E96C4545A5610B79A0883)
  709. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  710. VALUES(349,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0x3A1E41778240A971372391A0DD077F384CE98D044DB4C67B5FC71E2AA52F605C)
  711. INSERT INTO [dbo].[SourceTable]([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK])
  712. VALUES(350,CAST('20160430' as DATE),CAST('20160201' as DATE),NULL,'String2',CAST('20160307 00:00:00.000' as DATETIME),0xD51BEFB2E924D7203178009026B9134D0AB96E5782460ABABC7092153F2EF759)
  713.  
  714. /* 05: Run the merge statement - it should timeout after about 300 seconds
  715.  
  716. INSERT INTO dbo.TargetTable ([RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [Bit], [HashedBK])  
  717. SELECT [RK], [Date1], [Date2], [FK], [Char1], [DateTime1], 1, [HashedBK] FROM
  718. (
  719.     MERGE INTO dbo.TargetTable AS target
  720.     USING (SELECT [RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [HashedBK] FROM TEST.dbo.SourceTable) AS source
  721.                  ([RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [HashedBK])
  722.     ON (target.[HashedBK] = source.[HashedBK] and target.[Bit] = 1)
  723.     WHEN MATCHED AND EXISTS
  724.     (
  725.         select source.[Date1], source.[Date2], source.[FK]
  726.         except
  727.         select target.[Date1], target.[Date2], target.[FK]
  728.     )
  729.     THEN UPDATE SET [DateTime2] = dateadd(ss, -1, source.[DateTime1]), [Bit]=0
  730.     WHEN NOT MATCHED THEN
  731.         INSERT ([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK],[Bit])
  732.         VALUES (source.[RK], source.[Date1], source.[Date2], source.[FK], source.[Char1], source.[DateTime1], source.[HashedBK], 1)  
  733.     OUTPUT $action, source.[RK], source.[Date1], source.[Date2], source.[FK], source.[Char1], source.[DateTime1], source.[HashedBK], 1
  734. ) AS changes
  735. (action, [RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [HashedBK], [Bit]) WHERE action = 'UPDATE';
  736. */
  737.  
  738. /* 06: Now delete 50 rows from the source table
  739.  
  740. delete from dbo.SourceTable where RK > 300;
  741. */
  742.  
  743. /* 07: Run the merge statement again - it should complete successfully in about 1-2 seconds
  744.  
  745. INSERT INTO dbo.TargetTable ([RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [Bit], [HashedBK])  
  746. SELECT [RK], [Date1], [Date2], [FK], [Char1], [DateTime1], 1, [HashedBK] FROM
  747. (
  748.     MERGE INTO dbo.TargetTable AS target
  749.     USING (SELECT [RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [HashedBK] FROM TEST.dbo.SourceTable) AS source
  750.                  ([RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [HashedBK])
  751.     ON (target.[HashedBK] = source.[HashedBK] and target.[Bit] = 1)
  752.     WHEN MATCHED AND EXISTS
  753.     (
  754.         select source.[Date1], source.[Date2], source.[FK]
  755.         except
  756.         select target.[Date1], target.[Date2], target.[FK]
  757.     )
  758.     THEN UPDATE SET [DateTime2] = dateadd(ss, -1, source.[DateTime1]), [Bit]=0
  759.     WHEN NOT MATCHED THEN
  760.         INSERT ([RK],[Date1],[Date2],[FK],[Char1],[DateTime1],[HashedBK],[Bit])
  761.         VALUES (source.[RK], source.[Date1], source.[Date2], source.[FK], source.[Char1], source.[DateTime1], source.[HashedBK], 1)  
  762.     OUTPUT $action, source.[RK], source.[Date1], source.[Date2], source.[FK], source.[Char1], source.[DateTime1], source.[HashedBK], 1
  763. ) AS changes
  764. (action, [RK], [Date1], [Date2], [FK], [Char1], [DateTime1], [HashedBK], [Bit]) WHERE action = 'UPDATE';
  765. */
  766.  
  767. --select * from dbo.SourceTable
  768. --select * from dbo.TargetTable
  769.  
  770. /* 08: Now change to full recovery model and start from step 02. The merge will succeed the first time around */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!