Crazy CASE statement causing major churn on WorkTable

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 8:13 am

  #399773

  So the code below is a snippet of a procedure (that for the most part executes just fine), however the code below causes massive logical reads, take a long time, and has quite a bit of CPU overhead. My main question is; how could this be rewritten to be more efficient? The execution plan doesn't look too bad...(also attached)

  CREATE A TABLE (#TempMPM ) -->> have to do this to get around our proxy

  (

  UniqueId INT IDENTITY(1, 1) PRIMARY KEY,

  Program INT,

  FleetProgramStatus VARCHAR(5),

  IncludeExclude VARCHAR(5),

  TStatus VARCHAR(5),

  TStatusEffectiveStartDate DATETIME,

  MPLMerchantNumber VARCHAR(25),

  MPLStoreNumber VARCHAR(25)

  )

  /* Import data from CSV into this physical version of above temp table */

  /* Problem script below */

  IF EXISTS (SELECT 1

  FROM #TempMPM mpm1

  WHERE EXISTS (SELECT 1

  FROM #TempMPM mpm2

  WHERE mpm1.Program <> mpm2.Program

  AND mpm1.MPLMerchantNumber = mpm2.MPLMerchantNumber

  AND mpm1.MPLStoreNumber = mpm2.MPLStoreNumber

  AND ( CASE

  WHEN mpm1.TStatusEffectiveStartDate IS NOT NULL

  AND mpm2.TStatusEffectiveStartDate IS NOT NULL THEN

  CASE

  WHEN mpm1.TStatus = '0' AND mpm2.TStatus = '0' THEN 1

  WHEN mpm1.TStatus = '0' AND mpm2.TStatus = '1' AND mpm1.TStatusEffectiveStartDate < mpm2.TStatusEffectiveStartDate THEN 1

  WHEN mpm1.TStatus = '1' AND mpm2.TStatus = '0' AND mpm1.TStatusEffectiveStartDate > mpm2.TStatusEffectiveStartDate THEN 1

  WHEN mpm1.FleetProgramStatus = '0' AND mpm2.FleetProgramStatus = '0' THEN 1

  ELSE 0

  END

  WHEN mpm1.TStatusEffectiveStartDate IS NULL AND mpm2.TStatusEffectiveStartDate IS NOT NULL AND mpm1.FleetProgramStatus = '0'

  AND ( mpm2.TStatus = '0' OR mpm2.FleetProgramStatus = '0' ) THEN 1

  WHEN mpm1.TStatusEffectiveStartDate IS NOT NULL AND mpm2.TStatusEffectiveStartDate IS NULL

  AND ( mpm1.TStatus = '0' OR mpm1.FleetProgramStatus = '0' )

  AND mpm2.FleetProgramStatus = '0' THEN 1

  WHEN mpm1.TStatusEffectiveStartDate IS NULL

  AND mpm2.TStatusEffectiveStartDate IS NULL

  AND mpm1.FleetProgramStatus = '0'

  AND mpm2.FleetProgramStatus = '0' THEN 1

  ELSE 0

  END ) = 1))

  BEGIN

  SELECT 1

  END

  ELSE

  BEGIN

  SELECT 0

  END

  /* STATISTICS IO OUTPUT - snippet from output via the original procedure

  Table 'Worktable'. Scan count 1, logical reads 13,375,849, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

  */

  DROP The TABLE #TempMPM -->> have to do this to get around our proxy

  Attached is some sample data..

  There has to be a better way to do this; the developer was suggesting a LOOP but I figured that would perform even worse with the JOIN being back onto itself.

  Any thoughts?

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  February 25, 2016 at 8:57 am

  #1861115

  This would be a lot better if your sample data was readily consumable (insert statement). Also, the actual execution plan as a file instead of a screen shot would be more helpful.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 12:11 pm

  #1861208

  I was hoping there'd be a "Oh you just need to do it this way" by looking at the code...but knew I'd get dinged on the lack of preparation on my part. Here's updated code that can be run as is, plus I'm attaching the execution plan for the script below, plus the original procedure and original execution plan...Apologies for the oversight, but the part of the code originally posted was all I was questioning.

  CREATE TABLE #TempMPM

  (

  UniqueId INT PRIMARY KEY,

  Program INT,

  FleetProgramStatus VARCHAR(5),

  IncludeExclude VARCHAR(5),

  TStatus VARCHAR(5),

  TStatusEffectiveStartDate DATETIME,

  MPLMerchantNumber VARCHAR(25),

  MPLStoreNumber VARCHAR(25)

  )

  /* Populate */

  INSERT INTO #TempMPM

  SELECT 1849,7110,1,0,NULL,NULL,0377,189 UNION ALL

  SELECT 1850,7110,1,0,NULL,NULL,0377,194 UNION ALL

  SELECT 1851,7110,1,0,NULL,NULL,0377,195 UNION ALL

  SELECT 1852,7110,1,0,NULL,NULL,0377,328 UNION ALL

  SELECT 1853,7110,1,0,NULL,NULL,0377,332 UNION ALL

  SELECT 1854,7110,1,0,NULL,NULL,0377,418174 UNION ALL

  SELECT 1855,7110,1,0,NULL,NULL,0377,419059 UNION ALL

  SELECT 1856,7110,1,0,NULL,NULL,0377,45 UNION ALL

  SELECT 1857,7110,1,0,NULL,NULL,0377,123 UNION ALL

  SELECT 1858,7110,1,0,NULL,NULL,0377,83 UNION ALL

  SELECT 1859,7110,1,0,NULL,NULL,0377,193 UNION ALL

  SELECT 1860,7110,1,0,NULL,NULL,0377,150 UNION ALL

  SELECT 97071,6690,1,0,0,'2016-02-25 00:00:00.000',5009,496 UNION ALL

  SELECT 97072,6690,1,0,0,'2016-02-25 00:00:00.000',5009,447 UNION ALL

  SELECT 97073,6690,1,0,0,'2016-02-25 00:00:00.000',5009,302 UNION ALL

  SELECT 97074,6690,1,0,0,'2016-02-25 00:00:00.000',5009,707 UNION ALL

  SELECT 97075,6690,1,0,0,'2016-02-25 00:00:00.000',5009,458 UNION ALL

  SELECT 97076,6690,1,0,0,'2016-02-25 00:00:00.000',5009,460 UNION ALL

  SELECT 97077,6690,1,0,0,'2016-02-25 00:00:00.000',5009,441 UNION ALL

  SELECT 97078,6690,1,0,0,'2016-02-25 00:00:00.000',5009,196231 UNION ALL

  SELECT 97079,6690,1,0,0,'2016-02-25 00:00:00.000',5009,196363 UNION ALL

  SELECT 97080,6690,1,0,0,'2016-02-25 00:00:00.000',5009,196370 UNION ALL

  SELECT 97081,6690,1,0,0,'2016-02-25 00:00:00.000',5009,762 UNION ALL

  SELECT 97082,6690,1,0,0,'2016-02-25 00:00:00.000',5009,373 UNION ALL

  SELECT 99404,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6963 UNION ALL

  SELECT 99405,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8276 UNION ALL

  SELECT 99406,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8662 UNION ALL

  SELECT 99407,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6980 UNION ALL

  SELECT 95481,7030,1,0,NULL,NULL,1400,900001494UNION ALL

  SELECT 95482,7030,1,0,NULL,NULL,1400,900001495UNION ALL

  SELECT 95483,7030,1,0,NULL,NULL,1400,900001496UNION ALL

  SELECT 95484,7030,1,0,NULL,NULL,1400,900001497UNION ALL

  SELECT 95485,7030,1,0,NULL,NULL,1400,900001498UNION ALL

  SELECT 95486,7030,1,0,NULL,NULL,1400,900001499UNION ALL

  SELECT 95487,7030,1,0,NULL,NULL,1400,900001500UNION ALL

  SELECT 95488,7030,1,0,NULL,NULL,1400,900001501UNION ALL

  SELECT 95489,7030,1,0,NULL,NULL,1400,900001502UNION ALL

  SELECT 95490,7030,1,0,NULL,NULL,1400,900001503UNION ALL

  SELECT 95491,7030,1,0,NULL,NULL,1400,900001504UNION ALL

  SELECT 95492,7030,1,0,NULL,NULL,1400,900001505UNION ALL

  SELECT 95493,7030,1,0,NULL,NULL,1400,900001506UNION ALL

  SELECT 95494,7030,1,0,NULL,NULL,1400,900001507UNION ALL

  SELECT 95495,7030,1,0,NULL,NULL,1400,900001508UNION ALL

  SELECT 95496,7030,1,0,NULL,NULL,1400,900001509UNION ALL

  SELECT 95497,7030,1,0,NULL,NULL,1400,900001510UNION ALL

  SELECT 95498,7030,1,0,NULL,NULL,1400,900001511UNION ALL

  SELECT 95499,7030,1,0,NULL,NULL,1400,900001512UNION ALL

  SELECT 95500,7030,1,0,NULL,NULL,1400,900001513UNION ALL

  SELECT 95501,7030,1,0,NULL,NULL,1400,900001514UNION ALL

  SELECT 95502,7030,1,0,NULL,NULL,1400,900001515UNION ALL

  SELECT 95503,7030,1,0,NULL,NULL,1400,900001516UNION ALL

  SELECT 95504,7030,1,0,NULL,NULL,1400,900001517UNION ALL

  SELECT 95505,7030,1,0,NULL,NULL,1400,900001518UNION ALL

  SELECT 95506,7030,1,0,NULL,NULL,1400,900001519UNION ALL

  SELECT 95507,7030,1,0,NULL,NULL,1400,900001520UNION ALL

  SELECT 95508,7030,1,0,NULL,NULL,1400,900001521UNION ALL

  SELECT 95509,7030,1,0,NULL,NULL,1513,500640 UNION ALL

  SELECT 95510,7030,1,0,NULL,NULL,1513,500641 UNION ALL

  SELECT 95511,7030,1,0,NULL,NULL,1707,2944 UNION ALL

  SELECT 95512,7030,1,0,NULL,NULL,1513,500642 UNION ALL

  SELECT 95513,7030,1,0,NULL,NULL,1763,9353517 UNION ALL

  SELECT 95514,7030,1,0,NULL,NULL,1763,6162606 UNION ALL

  SELECT 95515,7030,1,0,NULL,NULL,1763,6162812 UNION ALL

  SELECT 95516,7030,1,0,NULL,NULL,1763,9568023 UNION ALL

  SELECT 95517,7030,1,0,NULL,NULL,1763,2956126 UNION ALL

  SELECT 95518,7030,1,0,NULL,NULL,1513,500643 UNION ALL

  SELECT 95519,7030,1,0,NULL,NULL,1477,300366 UNION ALL

  SELECT 95520,7030,1,0,NULL,NULL,1600,0377019 UNION ALL

  SELECT 95521,7030,1,0,NULL,NULL,1600,0377020 UNION ALL

  SELECT 95522,7030,1,0,NULL,NULL,1600,0377021 UNION ALL

  SELECT 95523,7030,1,0,NULL,NULL,1600,0377022 UNION ALL

  SELECT 95524,7030,1,0,NULL,NULL,1477,300367 UNION ALL

  SELECT 95525,7030,1,0,NULL,NULL,1513,500644 UNION ALL

  SELECT 95526,7030,1,0,NULL,NULL,603775,603775 UNION ALL

  SELECT 95527,7030,1,0,NULL,NULL,1600,0377023 UNION ALL

  SELECT 95528,7030,1,0,NULL,NULL,1600,0377024 UNION ALL

  SELECT 95529,7030,1,0,NULL,NULL,1400,900001522UNION ALL

  SELECT 95530,7030,1,0,NULL,NULL,1400,900001523UNION ALL

  SELECT 95531,7030,1,0,NULL,NULL,1400,900001524UNION ALL

  SELECT 95532,7030,1,0,NULL,NULL,1400,900001525UNION ALL

  SELECT 95533,7030,1,0,NULL,NULL,1513,500645 UNION ALL

  SELECT 95534,7030,1,0,NULL,NULL,1711,9350 UNION ALL

  SELECT 95535,7030,1,0,NULL,NULL,1700,4434 UNION ALL

  SELECT 95536,7030,1,0,NULL,NULL,1600,0377025 UNION ALL

  SELECT 95537,7030,1,0,NULL,NULL,1600,0377029 UNION ALL

  SELECT 95538,7030,1,0,NULL,NULL,1600,0377030 UNION ALL

  SELECT 95539,7030,1,0,NULL,NULL,1600,0377032 UNION ALL

  SELECT 95540,7030,1,0,NULL,NULL,1600,0377033 UNION ALL

  SELECT 95541,7030,1,0,NULL,NULL,1600,0377034 UNION ALL

  SELECT 95542,7030,1,0,NULL,NULL,1600,0377037 UNION ALL

  SELECT 95543,7030,1,0,NULL,NULL,1600,0377042 UNION ALL

  SELECT 95544,7030,1,0,NULL,NULL,1600,0377051 UNION ALL

  SELECT 95545,7030,1,0,NULL,NULL,1600,0377053 UNION ALL

  SELECT 95546,7030,1,0,NULL,NULL,1600,0377054 UNION ALL

  SELECT 95547,7030,1,0,NULL,NULL,1600,0377055 UNION ALL

  SELECT 95548,7030,1,0,NULL,NULL,1600,0377056 UNION ALL

  SELECT 95549,7030,1,0,NULL,NULL,1600,0377057 UNION ALL

  SELECT 95550,7030,1,0,NULL,NULL,1600,0377064 UNION ALL

  SELECT 95551,7030,1,0,NULL,NULL,1600,0377066 UNION ALL

  SELECT 95552,7030,1,0,NULL,NULL,1600,0377067 UNION ALL

  SELECT 95553,7030,1,0,NULL,NULL,1600,0377068 UNION ALL

  SELECT 95554,7030,1,0,NULL,NULL,1600,0377069 UNION ALL

  SELECT 95555,7030,1,0,NULL,NULL,1600,0377070 UNION ALL

  SELECT 95556,7030,1,0,NULL,NULL,1600,0377071 UNION ALL

  SELECT 95557,7030,1,0,NULL,NULL,1600,0377072 UNION ALL

  SELECT 95558,7030,1,0,NULL,NULL,1600,0377073 UNION ALL

  SELECT 95559,7030,1,0,NULL,NULL,1600,0377074 UNION ALL

  SELECT 95560,7030,1,0,NULL,NULL,1600,0377075 UNION ALL

  SELECT 95561,7030,1,0,NULL,NULL,1600,0377076 UNION ALL

  SELECT 95562,7030,1,0,NULL,NULL,1600,0377077 UNION ALL

  SELECT 95563,7030,1,0,NULL,NULL,1600,0377078 UNION ALL

  SELECT 95564,7030,1,0,NULL,NULL,1600,0377079 UNION ALL

  SELECT 95565,7030,1,0,NULL,NULL,1600,0377080 UNION ALL

  SELECT 95566,7030,1,0,NULL,NULL,1600,0377081 UNION ALL

  SELECT 95567,7030,1,0,NULL,NULL,1600,0377082 UNION ALL

  SELECT 95568,7030,1,0,NULL,NULL,1600,0377083 UNION ALL

  SELECT 95569,7030,1,0,NULL,NULL,1600,0377084 UNION ALL

  SELECT 95570,7030,1,0,NULL,NULL,1600,0377085 UNION ALL

  SELECT 95571,7030,1,0,NULL,NULL,1600,0377086 UNION ALL

  SELECT 95572,7030,1,0,NULL,NULL,1600,0377087 UNION ALL

  SELECT 95573,7030,1,0,NULL,NULL,1600,0377088 UNION ALL

  SELECT 95574,7030,1,0,NULL,NULL,1600,0377089 UNION ALL

  SELECT 95575,7030,1,0,NULL,NULL,1600,0377090 UNION ALL

  SELECT 95576,7030,1,0,NULL,NULL,1600,0377091 UNION ALL

  SELECT 95577,7030,1,0,NULL,NULL,1600,0377092 UNION ALL

  SELECT 95578,7030,1,0,NULL,NULL,1600,0377093 UNION ALL

  SELECT 95579,7030,1,0,NULL,NULL,1600,0377094 UNION ALL

  SELECT 95580,7030,1,0,NULL,NULL,1600,0377095 UNION ALL

  SELECT 95581,7030,1,0,NULL,NULL,1600,0377096 UNION ALL

  SELECT 95582,7030,1,0,NULL,NULL,1600,0377097 UNION ALL

  SELECT 95583,7030,1,0,NULL,NULL,1600,0377099 UNION ALL

  SELECT 95584,7030,1,0,NULL,NULL,1600,0377100 UNION ALL

  SELECT 95585,7030,1,0,NULL,NULL,1600,0377101 UNION ALL

  SELECT 95586,7030,1,0,NULL,NULL,1550,988343 UNION ALL

  SELECT 95587,7030,1,0,NULL,NULL,1550,988344 UNION ALL

  SELECT 95588,7030,1,0,NULL,NULL,1550,988345 UNION ALL

  SELECT 95589,7030,1,0,NULL,NULL,1550,988346 UNION ALL

  SELECT 95590,7030,1,0,NULL,NULL,1550,988347 UNION ALL

  SELECT 95591,7030,1,0,NULL,NULL,1550,988348 UNION ALL

  SELECT 95592,7030,1,0,NULL,NULL,1550,988349 UNION ALL

  SELECT 95593,7030,1,0,NULL,NULL,1550,988350 UNION ALL

  SELECT 95594,7030,1,0,NULL,NULL,1550,988351 UNION ALL

  SELECT 95595,7030,1,0,NULL,NULL,1513,500729 UNION ALL

  SELECT 95596,7030,1,0,NULL,NULL,1513,500728 UNION ALL

  SELECT 95597,7030,1,0,NULL,NULL,1513,500727 UNION ALL

  SELECT 95598,7030,1,0,NULL,NULL,1513,500726 UNION ALL

  SELECT 95599,7030,1,0,NULL,NULL,1513,500725 UNION ALL

  SELECT 95600,7030,1,0,NULL,NULL,1513,500724 UNION ALL

  SELECT 95601,7030,1,0,NULL,NULL,1513,500723 UNION ALL

  SELECT 95602,7030,1,0,NULL,NULL,1513,500722 UNION ALL

  SELECT 95603,7030,1,0,NULL,NULL,1513,500721 UNION ALL

  SELECT 95604,7030,1,0,NULL,NULL,1513,500720 UNION ALL

  SELECT 95605,7030,1,0,NULL,NULL,1513,500719 UNION ALL

  SELECT 95606,7030,1,0,NULL,NULL,1513,500718 UNION ALL

  SELECT 95607,7030,1,0,NULL,NULL,1513,500717 UNION ALL

  SELECT 95608,7030,1,0,NULL,NULL,1513,500716 UNION ALL

  SELECT 95609,7030,1,0,NULL,NULL,1513,500714 UNION ALL

  SELECT 95610,7030,1,0,NULL,NULL,1513,500715 UNION ALL

  SELECT 95611,7030,1,0,NULL,NULL,1513,500713 UNION ALL

  SELECT 95612,7030,1,0,NULL,NULL,1513,500712 UNION ALL

  SELECT 95613,7030,1,0,NULL,NULL,1513,500711 UNION ALL

  SELECT 95614,7030,1,0,NULL,NULL,1513,500709 UNION ALL

  SELECT 95615,7030,1,0,NULL,NULL,1513,500710 UNION ALL

  SELECT 95616,7030,1,0,NULL,NULL,1513,500707 UNION ALL

  SELECT 95617,7030,1,0,NULL,NULL,1513,500708 UNION ALL

  SELECT 95618,7030,1,0,NULL,NULL,1513,500706 UNION ALL

  SELECT 95619,7030,1,0,NULL,NULL,1513,500705 UNION ALL

  SELECT 95620,7030,1,0,NULL,NULL,1513,500704 UNION ALL

  SELECT 95621,7030,1,0,NULL,NULL,1513,500703 UNION ALL

  SELECT 95622,7030,1,0,NULL,NULL,1513,500702 UNION ALL

  SELECT 95623,7030,1,0,NULL,NULL,1513,500701 UNION ALL

  SELECT 95624,7030,1,0,NULL,NULL,1513,500699 UNION ALL

  SELECT 95625,7030,1,0,NULL,NULL,1513,500700 UNION ALL

  SELECT 95626,7030,1,0,NULL,NULL,1513,500697 UNION ALL

  SELECT 95627,7030,1,0,NULL,NULL,1513,500698 UNION ALL

  SELECT 95628,7030,1,0,NULL,NULL,1513,500696 UNION ALL

  SELECT 95629,7030,1,0,NULL,NULL,1513,500695 UNION ALL

  SELECT 95630,7030,1,0,NULL,NULL,1513,500693 UNION ALL

  SELECT 95631,7030,1,0,NULL,NULL,1513,500694 UNION ALL

  SELECT 95632,7030,1,0,NULL,NULL,1513,500692 UNION ALL

  SELECT 95633,7030,1,0,NULL,NULL,1513,500691 UNION ALL

  SELECT 95634,7030,1,0,NULL,NULL,1513,500690 UNION ALL

  SELECT 95635,7030,1,0,NULL,NULL,1513,500689 UNION ALL

  SELECT 95636,7030,1,0,NULL,NULL,1513,500688 UNION ALL

  SELECT 95637,7030,1,0,NULL,NULL,1513,500687 UNION ALL

  SELECT 95638,7030,1,0,NULL,NULL,1513,500686 UNION ALL

  SELECT 95639,7030,1,0,NULL,NULL,1513,500685 UNION ALL

  SELECT 95640,7030,1,0,NULL,NULL,1513,500684 UNION ALL

  SELECT 95641,7030,1,0,NULL,NULL,1513,500683 UNION ALL

  SELECT 95642,7030,1,0,NULL,NULL,1513,500682 UNION ALL

  SELECT 95643,7030,1,0,NULL,NULL,1513,500681 UNION ALL

  SELECT 95644,7030,1,0,NULL,NULL,1513,500680 UNION ALL

  SELECT 95645,7030,1,0,NULL,NULL,1513,500679 UNION ALL

  SELECT 95646,7030,1,0,NULL,NULL,1513,500678 UNION ALL

  SELECT 95647,7030,1,0,NULL,NULL,1513,500677 UNION ALL

  SELECT 95648,7030,1,0,NULL,NULL,1513,500676 UNION ALL

  SELECT 95649,7030,1,0,NULL,NULL,1513,500675 UNION ALL

  SELECT 95650,7030,1,0,NULL,NULL,1513,500674 UNION ALL

  SELECT 95651,7030,1,0,NULL,NULL,1513,500673 UNION ALL

  SELECT 95652,7030,1,0,NULL,NULL,1513,500672 UNION ALL

  SELECT 95653,7030,1,0,NULL,NULL,1513,500671 UNION ALL

  SELECT 95654,7030,1,0,NULL,NULL,1513,500670 UNION ALL

  SELECT 95655,7030,1,0,NULL,NULL,1513,500646 UNION ALL

  SELECT 95656,7030,1,0,NULL,NULL,1513,500647 UNION ALL

  SELECT 95657,7030,1,0,NULL,NULL,1513,500648 UNION ALL

  SELECT 95658,7030,1,0,NULL,NULL,1513,500649 UNION ALL

  SELECT 95659,7030,1,0,NULL,NULL,1513,500650 UNION ALL

  SELECT 95660,7030,1,0,NULL,NULL,1513,500651 UNION ALL

  SELECT 95661,7030,1,0,NULL,NULL,1513,500652 UNION ALL

  SELECT 95662,7030,1,0,NULL,NULL,1513,500653 UNION ALL

  SELECT 95663,7030,1,0,NULL,NULL,1513,500654 UNION ALL

  SELECT 95664,7030,1,0,NULL,NULL,1513,500655 UNION ALL

  SELECT 95665,7030,1,0,NULL,NULL,1513,500656 UNION ALL

  SELECT 95666,7030,1,0,NULL,NULL,1513,500657 UNION ALL

  SELECT 95667,7030,1,0,NULL,NULL,1513,500658 UNION ALL

  SELECT 95668,7030,1,0,NULL,NULL,1513,500659 UNION ALL

  SELECT 95669,7030,1,0,NULL,NULL,1513,500661 UNION ALL

  SELECT 95670,7030,1,0,NULL,NULL,1513,500662 UNION ALL

  SELECT 95671,7030,1,0,NULL,NULL,1513,500663 UNION ALL

  SELECT 95672,7030,1,0,NULL,NULL,1513,500664 UNION ALL

  SELECT 95673,7030,1,0,NULL,NULL,1513,500665 UNION ALL

  SELECT 95674,7030,1,0,NULL,NULL,1513,500660 UNION ALL

  SELECT 95675,7030,1,0,NULL,NULL,1513,500666 UNION ALL

  SELECT 95676,7030,1,0,NULL,NULL,1513,500667 UNION ALL

  SELECT 95677,7030,1,0,NULL,NULL,1513,500669 UNION ALL

  SELECT 95678,7030,1,0,NULL,NULL,1513,500668 UNION ALL

  SELECT 95679,7030,1,0,NULL,NULL,1513,500730 UNION ALL

  SELECT 95680,7030,1,0,NULL,NULL,1513,500731 UNION ALL

  SELECT 95681,7030,1,0,NULL,NULL,1707,944 UNION ALL

  SELECT 95682,7030,1,0,NULL,NULL,1400,900001530UNION ALL

  SELECT 95683,7030,1,0,NULL,NULL,1400,900001531UNION ALL

  SELECT 95684,7030,1,0,NULL,NULL,1400,900001532UNION ALL

  SELECT 95685,7030,1,0,NULL,NULL,1513,500732 UNION ALL

  SELECT 95686,7030,1,0,NULL,NULL,1513,500733 UNION ALL

  SELECT 95687,7030,1,0,NULL,NULL,1400,900001533UNION ALL

  SELECT 95688,7030,1,0,NULL,NULL,1400,900001534UNION ALL

  SELECT 95689,7030,1,0,NULL,NULL,1477,300368 UNION ALL

  SELECT 95690,7030,1,0,NULL,NULL,1477,300369 UNION ALL

  SELECT 95691,7030,1,0,NULL,NULL,1477,300370 UNION ALL

  SELECT 95692,7030,1,0,NULL,NULL,1477,300371 UNION ALL

  SELECT 95693,7030,1,0,NULL,NULL,0655,67 UNION ALL

  SELECT 95694,7030,1,0,NULL,NULL,1513,500734 UNION ALL

  SELECT 95695,7030,1,0,NULL,NULL,1513,500735 UNION ALL

  SELECT 95696,7030,1,0,NULL,NULL,1513,500736 UNION ALL

  SELECT 95697,7030,1,0,NULL,NULL,1763,6163067 UNION ALL

  SELECT 95698,7030,1,0,NULL,NULL,1763,6163174 UNION ALL

  SELECT 95699,7030,1,0,NULL,NULL,1763,6163281 UNION ALL

  SELECT 95700,7030,1,0,NULL,NULL,1763,6164420 UNION ALL

  SELECT 95701,7030,1,0,NULL,NULL,1763,6164891 UNION ALL

  SELECT 95702,7030,1,0,NULL,NULL,1763,2098010 UNION ALL

  SELECT 95703,7030,1,0,NULL,NULL,1763,3077831 UNION ALL

  SELECT 95704,7030,1,0,NULL,NULL,1763,6179113 UNION ALL

  SELECT 95705,7030,1,0,NULL,NULL,1763,6176424 UNION ALL

  SELECT 95706,7030,1,0,NULL,NULL,1763,6177323 UNION ALL

  SELECT 95707,7030,1,0,NULL,NULL,1763,6177539 UNION ALL

  SELECT 95708,7030,1,0,NULL,NULL,1763,6178255 UNION ALL

  SELECT 95709,7030,1,0,NULL,NULL,1763,9696717 UNION ALL

  SELECT 95710,7030,1,0,NULL,NULL,1763,6175368 UNION ALL

  SELECT 95711,7030,1,0,NULL,NULL,1600,0377105 UNION ALL

  SELECT 95712,7030,1,0,NULL,NULL,1600,0377106 UNION ALL

  SELECT 95713,7030,1,0,NULL,NULL,1600,0377107 UNION ALL

  SELECT 95714,7030,1,0,NULL,NULL,1513,500740 UNION ALL

  SELECT 95715,7030,1,0,NULL,NULL,1513,500741 UNION ALL

  SELECT 95716,7030,1,0,NULL,NULL,1513,500742 UNION ALL

  SELECT 95717,7030,1,0,NULL,NULL,1600,0377108 UNION ALL

  SELECT 95718,7030,1,0,NULL,NULL,1600,0377109 UNION ALL

  SELECT 95719,7030,1,0,NULL,NULL,1600,0377110 UNION ALL

  SELECT 95720,7030,1,0,NULL,NULL,1600,0377112 UNION ALL

  SELECT 95721,7030,1,0,NULL,NULL,1600,0377113 UNION ALL

  SELECT 95722,7030,1,0,NULL,NULL,1600,0377117 UNION ALL

  SELECT 95723,7030,1,0,NULL,NULL,1600,0377118 UNION ALL

  SELECT 95724,7030,1,0,NULL,NULL,1600,0377124 UNION ALL

  SELECT 95725,7030,1,0,NULL,NULL,1600,0377125 UNION ALL

  SELECT 95726,7030,1,0,NULL,NULL,1600,0377126 UNION ALL

  SELECT 95727,7030,1,0,NULL,NULL,1600,0377127 UNION ALL

  SELECT 95728,7030,1,0,NULL,NULL,1600,0377128 UNION ALL

  SELECT 95729,7030,1,0,NULL,NULL,1600,0377129 UNION ALL

  SELECT 95730,7030,1,0,NULL,NULL,1600,0377130 UNION ALL

  SELECT 95731,7030,1,0,NULL,NULL,1600,0377131 UNION ALL

  SELECT 95732,7030,1,0,NULL,NULL,1600,0377132 UNION ALL

  SELECT 95733,7030,1,0,NULL,NULL,1600,0377133 UNION ALL

  SELECT 95734,7030,1,0,NULL,NULL,1600,0377134 UNION ALL

  SELECT 95735,7030,1,0,NULL,NULL,1600,0377135 UNION ALL

  SELECT 95736,7030,1,0,NULL,NULL,1600,0377136 UNION ALL

  SELECT 95737,7030,1,0,NULL,NULL,1600,0377137 UNION ALL

  SELECT 95738,7030,1,0,NULL,NULL,1600,0377143 UNION ALL

  SELECT 95739,7030,1,0,NULL,NULL,1600,0377144 UNION ALL

  SELECT 95740,7030,1,0,NULL,NULL,1600,0377145 UNION ALL

  SELECT 98113,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198045 UNION ALL

  SELECT 98114,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198051 UNION ALL

  SELECT 98115,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198052 UNION ALL

  SELECT 98116,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198054 UNION ALL

  SELECT 98117,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198062 UNION ALL

  SELECT 98118,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198064 UNION ALL

  SELECT 98119,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198066 UNION ALL

  SELECT 98120,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198071 UNION ALL

  SELECT 98121,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198072 UNION ALL

  SELECT 98122,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198074 UNION ALL

  SELECT 98123,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198083 UNION ALL

  SELECT 98124,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198089 UNION ALL

  SELECT 98125,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198093 UNION ALL

  SELECT 98126,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198095 UNION ALL

  SELECT 98127,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198101 UNION ALL

  SELECT 98128,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198112 UNION ALL

  SELECT 98129,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198130 UNION ALL

  SELECT 98130,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198133 UNION ALL

  SELECT 98131,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198135 UNION ALL

  SELECT 98132,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198141 UNION ALL

  SELECT 98133,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198145 UNION ALL

  SELECT 98134,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198146 UNION ALL

  SELECT 98135,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198147 UNION ALL

  SELECT 98136,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198153 UNION ALL

  SELECT 98137,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198154 UNION ALL

  SELECT 98138,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198162 UNION ALL

  SELECT 98139,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198168 UNION ALL

  SELECT 98140,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198171 UNION ALL

  SELECT 98141,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198172 UNION ALL

  SELECT 98142,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198175 UNION ALL

  SELECT 98143,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198183 UNION ALL

  SELECT 98144,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198188 UNION ALL

  SELECT 98145,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198191 UNION ALL

  SELECT 98146,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198192 UNION ALL

  SELECT 98147,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198203 UNION ALL

  SELECT 98148,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198208 UNION ALL

  SELECT 98149,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198212 UNION ALL

  SELECT 98150,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198215 UNION ALL

  SELECT 98151,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198216 UNION ALL

  SELECT 98152,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198217 UNION ALL

  SELECT 98153,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198226 UNION ALL

  SELECT 98154,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198229 UNION ALL

  SELECT 98155,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198235 UNION ALL

  SELECT 98156,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198238 UNION ALL

  SELECT 98157,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198239 UNION ALL

  SELECT 98158,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198254 UNION ALL

  SELECT 98159,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198255 UNION ALL

  SELECT 98160,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198256 UNION ALL

  SELECT 98161,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198257 UNION ALL

  SELECT 98162,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198264 UNION ALL

  SELECT 98163,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198268 UNION ALL

  SELECT 98164,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198274 UNION ALL

  SELECT 98165,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198275 UNION ALL

  SELECT 98166,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198286 UNION ALL

  SELECT 98167,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198291 UNION ALL

  SELECT 98168,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198294 UNION ALL

  SELECT 98169,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198300 UNION ALL

  SELECT 98170,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198309 UNION ALL

  SELECT 98171,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198314 UNION ALL

  SELECT 98172,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198317 UNION ALL

  SELECT 98173,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198319 UNION ALL

  SELECT 98174,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198323 UNION ALL

  SELECT 98175,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198330 UNION ALL

  SELECT 98176,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198332 UNION ALL

  SELECT 98177,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198337 UNION ALL

  SELECT 98178,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198338 UNION ALL

  SELECT 98179,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198339 UNION ALL

  SELECT 98180,6690,1,0,0,'2016-02-25 00:00:00.000',0001,200634 UNION ALL

  SELECT 98181,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198353 UNION ALL

  SELECT 98182,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198354 UNION ALL

  SELECT 98183,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198359 UNION ALL

  SELECT 98184,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198360 UNION ALL

  SELECT 98185,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198373 UNION ALL

  SELECT 98186,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198374 UNION ALL

  SELECT 98187,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198377 UNION ALL

  SELECT 98188,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198379 UNION ALL

  SELECT 98189,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198381 UNION ALL

  SELECT 98190,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198383 UNION ALL

  SELECT 98191,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198384 UNION ALL

  SELECT 98192,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198386 UNION ALL

  SELECT 98193,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198388 UNION ALL

  SELECT 98194,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198403 UNION ALL

  SELECT 98195,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198409 UNION ALL

  SELECT 98196,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198413 UNION ALL

  SELECT 98197,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198415 UNION ALL

  SELECT 98198,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198416 UNION ALL

  SELECT 98199,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198427 UNION ALL

  SELECT 98200,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198429 UNION ALL

  SELECT 98201,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198431 UNION ALL

  SELECT 98202,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198435 UNION ALL

  SELECT 98203,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198441 UNION ALL

  SELECT 98204,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198447 UNION ALL

  SELECT 98205,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198448 UNION ALL

  SELECT 98206,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198451 UNION ALL

  SELECT 98207,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198454 UNION ALL

  SELECT 98208,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198457 UNION ALL

  SELECT 98209,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198462 UNION ALL

  SELECT 98210,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198485 UNION ALL

  SELECT 98211,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198487 UNION ALL

  SELECT 98212,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198504 UNION ALL

  SELECT 98213,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198505 UNION ALL

  SELECT 98214,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198507 UNION ALL

  SELECT 98215,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198508 UNION ALL

  SELECT 98216,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198509 UNION ALL

  SELECT 98217,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198512 UNION ALL

  SELECT 98218,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198513 UNION ALL

  SELECT 98219,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198519 UNION ALL

  SELECT 98220,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198521 UNION ALL

  SELECT 98221,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198527 UNION ALL

  SELECT 98222,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198533 UNION ALL

  SELECT 98223,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198542 UNION ALL

  SELECT 98224,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198544 UNION ALL

  SELECT 98225,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198551 UNION ALL

  SELECT 98226,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198563 UNION ALL

  SELECT 98227,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198567 UNION ALL

  SELECT 98228,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198572 UNION ALL

  SELECT 98229,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198577 UNION ALL

  SELECT 98230,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198578 UNION ALL

  SELECT 98231,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198581 UNION ALL

  SELECT 98232,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198583 UNION ALL

  SELECT 98233,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198586 UNION ALL

  SELECT 98234,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198589 UNION ALL

  SELECT 98235,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198591 UNION ALL

  SELECT 98236,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198592 UNION ALL

  SELECT 98237,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198593 UNION ALL

  SELECT 98238,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198601 UNION ALL

  SELECT 98239,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198605 UNION ALL

  SELECT 98240,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198617 UNION ALL

  SELECT 98241,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198621 UNION ALL

  SELECT 98242,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198624 UNION ALL

  SELECT 98243,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198627 UNION ALL

  SELECT 98244,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198690 UNION ALL

  SELECT 98245,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198702 UNION ALL

  SELECT 98246,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198703 UNION ALL

  SELECT 98247,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198704 UNION ALL

  SELECT 98248,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198707 UNION ALL

  SELECT 98249,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198726 UNION ALL

  SELECT 98250,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198727 UNION ALL

  SELECT 98251,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198728 UNION ALL

  SELECT 98252,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198729 UNION ALL

  SELECT 98253,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198731 UNION ALL

  SELECT 98254,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198733 UNION ALL

  SELECT 98255,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198744 UNION ALL

  SELECT 98256,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198747 UNION ALL

  SELECT 98257,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198749 UNION ALL

  SELECT 98258,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198755 UNION ALL

  SELECT 98259,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198756 UNION ALL

  SELECT 98260,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198757 UNION ALL

  SELECT 98261,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198772 UNION ALL

  SELECT 98262,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198773 UNION ALL

  SELECT 98263,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198774 UNION ALL

  SELECT 98264,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198775 UNION ALL

  SELECT 98265,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198776 UNION ALL

  SELECT 98266,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198778 UNION ALL

  SELECT 98267,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198781 UNION ALL

  SELECT 98268,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198782 UNION ALL

  SELECT 98269,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198783 UNION ALL

  SELECT 98270,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198794 UNION ALL

  SELECT 98271,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198795 UNION ALL

  SELECT 98272,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198800 UNION ALL

  SELECT 98273,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198804 UNION ALL

  SELECT 98274,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198806 UNION ALL

  SELECT 98275,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198813 UNION ALL

  SELECT 98276,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198814 UNION ALL

  SELECT 98277,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198822 UNION ALL

  SELECT 98278,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198828 UNION ALL

  SELECT 98279,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198830 UNION ALL

  SELECT 98280,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198834 UNION ALL

  SELECT 98281,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198835 UNION ALL

  SELECT 98282,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198851 UNION ALL

  SELECT 98283,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198858 UNION ALL

  SELECT 98284,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198859 UNION ALL

  SELECT 98285,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198860 UNION ALL

  SELECT 98286,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198861 UNION ALL

  SELECT 98287,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198862 UNION ALL

  SELECT 98288,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198865 UNION ALL

  SELECT 98289,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198868 UNION ALL

  SELECT 98290,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198872 UNION ALL

  SELECT 98291,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198876 UNION ALL

  SELECT 98292,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198877 UNION ALL

  SELECT 98293,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198883 UNION ALL

  SELECT 98294,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198884 UNION ALL

  SELECT 98295,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198886 UNION ALL

  SELECT 98296,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198889 UNION ALL

  SELECT 98297,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198890 UNION ALL

  SELECT 98298,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198900 UNION ALL

  SELECT 98299,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198905 UNION ALL

  SELECT 98300,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198908 UNION ALL

  SELECT 98301,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198911 UNION ALL

  SELECT 98302,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198915 UNION ALL

  SELECT 98303,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198994 UNION ALL

  SELECT 98304,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198995 UNION ALL

  SELECT 98305,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199081 UNION ALL

  SELECT 98306,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199117 UNION ALL

  SELECT 98307,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199154 UNION ALL

  SELECT 98308,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199158 UNION ALL

  SELECT 98309,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199165 UNION ALL

  SELECT 98310,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199167 UNION ALL

  SELECT 98311,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199176 UNION ALL

  SELECT 98312,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199182 UNION ALL

  SELECT 98313,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199183 UNION ALL

  SELECT 98314,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199195 UNION ALL

  SELECT 98315,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199196 UNION ALL

  SELECT 98316,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199197 UNION ALL

  SELECT 98317,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199198 UNION ALL

  SELECT 98318,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199199 UNION ALL

  SELECT 98319,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199200 UNION ALL

  SELECT 98320,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199201 UNION ALL

  SELECT 98321,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199203 UNION ALL

  SELECT 98322,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199204 UNION ALL

  SELECT 98323,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199209 UNION ALL

  SELECT 98324,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199216 UNION ALL

  SELECT 98325,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199217 UNION ALL

  SELECT 98326,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199218 UNION ALL

  SELECT 98327,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199219 UNION ALL

  SELECT 98328,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199220 UNION ALL

  SELECT 98329,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199221 UNION ALL

  SELECT 98330,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199222 UNION ALL

  SELECT 98331,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199226 UNION ALL

  SELECT 98332,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199227 UNION ALL

  SELECT 98333,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199228 UNION ALL

  SELECT 98334,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199229 UNION ALL

  SELECT 98335,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199239 UNION ALL

  SELECT 98336,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199255 UNION ALL

  SELECT 98337,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199256 UNION ALL

  SELECT 98338,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199257 UNION ALL

  SELECT 98339,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199258 UNION ALL

  SELECT 98340,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199259 UNION ALL

  SELECT 98341,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199261 UNION ALL

  SELECT 98342,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199269 UNION ALL

  SELECT 98343,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199270 UNION ALL

  SELECT 98344,6690,1,0,0,'2016-02-25 00:00:00.000',0089,187300 UNION ALL

  SELECT 98345,6690,1,0,0,'2016-02-25 00:00:00.000',0089,193387 UNION ALL

  SELECT 98346,6690,1,0,0,'2016-02-25 00:00:00.000',0089,198692 UNION ALL

  SELECT 98347,6690,1,0,0,'2016-02-25 00:00:00.000',5009,196712 UNION ALL

  SELECT 98348,6690,1,0,0,'2016-02-25 00:00:00.000',6001,9949 UNION ALL

  SELECT 98349,6690,1,0,0,'2016-02-25 00:00:00.000',6018,103903 UNION ALL

  SELECT 98350,6690,1,0,0,'2016-02-25 00:00:00.000',6040,187253 UNION ALL

  SELECT 98351,6690,1,0,0,'2016-02-25 00:00:00.000',6151,184311 UNION ALL

  SELECT 98352,6690,1,0,0,'2016-02-25 00:00:00.000',0001,163683 UNION ALL

  SELECT 98353,6690,1,0,0,'2016-02-25 00:00:00.000',0001,136747 UNION ALL

  SELECT 98354,6690,1,0,0,'2016-02-25 00:00:00.000',0001,100230 UNION ALL

  SELECT 98355,6690,1,0,0,'2016-02-25 00:00:00.000',5000,177 UNION ALL

  SELECT 98356,6690,1,0,0,'2016-02-25 00:00:00.000',5000,154 UNION ALL

  SELECT 98357,6690,1,0,0,'2016-02-25 00:00:00.000',5007,197984 UNION ALL

  SELECT 98358,6690,1,0,0,'2016-02-25 00:00:00.000',5007,198138 UNION ALL

  SELECT 98359,6690,1,0,0,'2016-02-25 00:00:00.000',189415,189415 UNION ALL

  SELECT 98360,6690,1,0,0,'2016-02-25 00:00:00.000',5000,220 UNION ALL

  SELECT 98361,6690,1,0,0,'2016-02-25 00:00:00.000',5000,33 UNION ALL

  SELECT 98362,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104075 UNION ALL

  SELECT 98363,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104117 UNION ALL

  SELECT 98364,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104125 UNION ALL

  SELECT 98365,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104133 UNION ALL

  SELECT 98366,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104141 UNION ALL

  SELECT 98367,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104158 UNION ALL

  SELECT 98368,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104208 UNION ALL

  SELECT 98369,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104216 UNION ALL

  SELECT 98370,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104224 UNION ALL

  SELECT 98371,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104232 UNION ALL

  SELECT 98372,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104240 UNION ALL

  SELECT 98373,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104299 UNION ALL

  SELECT 98374,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104315 UNION ALL

  SELECT 98375,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104356 UNION ALL

  SELECT 98376,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104372 UNION ALL

  SELECT 98377,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104380 UNION ALL

  SELECT 98378,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104398 UNION ALL

  SELECT 98379,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104414 UNION ALL

  SELECT 98380,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104422 UNION ALL

  SELECT 98381,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104430 UNION ALL

  SELECT 98382,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104471 UNION ALL

  SELECT 98383,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104489 UNION ALL

  SELECT 98384,6690,1,0,0,'2016-02-25 00:00:00.000',5000,104497 UNION ALL

  SELECT 98385,6690,1,0,0,'2016-02-25 00:00:00.000',5000,105809 UNION ALL

  SELECT 98386,6690,1,0,0,'2016-02-25 00:00:00.000',5000,106229 UNION ALL

  SELECT 98387,6690,1,0,0,'2016-02-25 00:00:00.000',5000,106344 UNION ALL

  SELECT 98388,6690,1,0,0,'2016-02-25 00:00:00.000',5000,106864 UNION ALL

  SELECT 98389,6690,1,0,0,'2016-02-25 00:00:00.000',5000,107276 UNION ALL

  SELECT 98390,6690,1,0,0,'2016-02-25 00:00:00.000',5000,107383 UNION ALL

  SELECT 98391,6690,1,0,0,'2016-02-25 00:00:00.000',5000,107441 UNION ALL

  SELECT 98392,6690,1,0,0,'2016-02-25 00:00:00.000',5000,107458 UNION ALL

  SELECT 98393,6690,1,0,0,'2016-02-25 00:00:00.000',5000,107490 UNION ALL

  SELECT 98394,6690,1,0,0,'2016-02-25 00:00:00.000',5000,107847 UNION ALL

  SELECT 98395,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108092 UNION ALL

  SELECT 98396,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108100 UNION ALL

  SELECT 98397,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108134 UNION ALL

  SELECT 98398,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108233 UNION ALL

  SELECT 98399,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108241 UNION ALL

  SELECT 98400,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108258 UNION ALL

  SELECT 98401,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108266 UNION ALL

  SELECT 98402,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108282 UNION ALL

  SELECT 98403,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108308 UNION ALL

  SELECT 98404,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108324 UNION ALL

  SELECT 98405,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108340 UNION ALL

  SELECT 98406,6690,1,0,0,'2016-02-25 00:00:00.000',5000,108522 UNION ALL

  SELECT 98407,6690,1,0,0,'2016-02-25 00:00:00.000',5000,109249 UNION ALL

  SELECT 98408,6690,1,0,0,'2016-02-25 00:00:00.000',5000,109264 UNION ALL

  SELECT 98409,6690,1,0,0,'2016-02-25 00:00:00.000',5000,109272 UNION ALL

  SELECT 98410,6690,1,0,0,'2016-02-25 00:00:00.000',5000,109546 UNION ALL

  SELECT 98411,6690,1,0,0,'2016-02-25 00:00:00.000',5000,110304 UNION ALL

  SELECT 98412,6690,1,0,0,'2016-02-25 00:00:00.000',5000,110643 UNION ALL

  SELECT 98413,6690,1,0,0,'2016-02-25 00:00:00.000',5000,110650 UNION ALL

  SELECT 98414,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111336 UNION ALL

  SELECT 98415,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111641 UNION ALL

  SELECT 98416,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111823 UNION ALL

  SELECT 98417,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111831 UNION ALL

  SELECT 98418,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111856 UNION ALL

  SELECT 98419,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111864 UNION ALL

  SELECT 98420,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111906 UNION ALL

  SELECT 98421,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111930 UNION ALL

  SELECT 98422,6690,1,0,0,'2016-02-25 00:00:00.000',5000,111989 UNION ALL

  SELECT 98423,6690,1,0,0,'2016-02-25 00:00:00.000',5000,112573 UNION ALL

  SELECT 98424,6690,1,0,0,'2016-02-25 00:00:00.000',5000,113688 UNION ALL

  SELECT 98425,6690,1,0,0,'2016-02-25 00:00:00.000',5000,114462 UNION ALL

  SELECT 98426,6690,1,0,0,'2016-02-25 00:00:00.000',5000,116491 UNION ALL

  SELECT 98427,6690,1,0,0,'2016-02-25 00:00:00.000',5000,116517 UNION ALL

  SELECT 98428,6690,1,0,0,'2016-02-25 00:00:00.000',5000,117960 UNION ALL

  SELECT 98429,6690,1,0,0,'2016-02-25 00:00:00.000',5000,118448 UNION ALL

  SELECT 98430,6690,1,0,0,'2016-02-25 00:00:00.000',5000,125005 UNION ALL

  SELECT 98431,6690,1,0,0,'2016-02-25 00:00:00.000',5000,126961 UNION ALL

  SELECT 98432,6690,1,0,0,'2016-02-25 00:00:00.000',5000,129163 UNION ALL

  SELECT 98433,6690,1,0,0,'2016-02-25 00:00:00.000',5000,129544 UNION ALL

  SELECT 98434,6690,1,0,0,'2016-02-25 00:00:00.000',5000,131896 UNION ALL

  SELECT 98435,6690,1,0,0,'2016-02-25 00:00:00.000',5000,136234 UNION ALL

  SELECT 98436,6690,1,0,0,'2016-02-25 00:00:00.000',5000,141358 UNION ALL

  SELECT 98437,6690,1,0,0,'2016-02-25 00:00:00.000',5000,141879 UNION ALL

  SELECT 98438,6690,1,0,0,'2016-02-25 00:00:00.000',5000,142828 UNION ALL

  SELECT 98439,6690,1,0,0,'2016-02-25 00:00:00.000',5000,143040 UNION ALL

  SELECT 98440,6690,1,0,0,'2016-02-25 00:00:00.000',5000,143057 UNION ALL

  SELECT 98441,6690,1,0,0,'2016-02-25 00:00:00.000',5000,143347 UNION ALL

  SELECT 98442,6690,1,0,0,'2016-02-25 00:00:00.000',5000,143594 UNION ALL

  SELECT 98443,6690,1,0,0,'2016-02-25 00:00:00.000',5000,143693 UNION ALL

  SELECT 98444,6690,1,0,0,'2016-02-25 00:00:00.000',5000,144519 UNION ALL

  SELECT 98445,6690,1,0,0,'2016-02-25 00:00:00.000',5000,145987 UNION ALL

  SELECT 98446,6690,1,0,0,'2016-02-25 00:00:00.000',5000,147934 UNION ALL

  SELECT 98447,6690,1,0,0,'2016-02-25 00:00:00.000',5000,149690 UNION ALL

  SELECT 98448,6690,1,0,0,'2016-02-25 00:00:00.000',5000,149773 UNION ALL

  SELECT 98449,6690,1,0,0,'2016-02-25 00:00:00.000',5000,149922 UNION ALL

  SELECT 98450,6690,1,0,0,'2016-02-25 00:00:00.000',5000,149971 UNION ALL

  SELECT 98451,6690,1,0,0,'2016-02-25 00:00:00.000',5000,150086 UNION ALL

  SELECT 98452,6690,1,0,0,'2016-02-25 00:00:00.000',5000,153163 UNION ALL

  SELECT 98453,6690,1,0,0,'2016-02-25 00:00:00.000',5000,160226 UNION ALL

  SELECT 98454,6690,1,0,0,'2016-02-25 00:00:00.000',5000,161885 UNION ALL

  SELECT 98455,6690,1,0,0,'2016-02-25 00:00:00.000',5000,162818 UNION ALL

  SELECT 98456,6690,1,0,0,'2016-02-25 00:00:00.000',5000,163360 UNION ALL

  SELECT 98457,6690,1,0,0,'2016-02-25 00:00:00.000',5000,164277 UNION ALL

  SELECT 98458,6690,1,0,0,'2016-02-25 00:00:00.000',5000,165514 UNION ALL

  SELECT 98459,6690,1,0,0,'2016-02-25 00:00:00.000',5000,170365 UNION ALL

  SELECT 98460,6690,1,0,0,'2016-02-25 00:00:00.000',5000,174276 UNION ALL

  SELECT 98461,6690,1,0,0,'2016-02-25 00:00:00.000',5000,176891 UNION ALL

  SELECT 98462,6690,1,0,0,'2016-02-25 00:00:00.000',5000,180380 UNION ALL

  SELECT 98463,6690,1,0,0,'2016-02-25 00:00:00.000',5000,183704 UNION ALL

  SELECT 98464,6690,1,0,0,'2016-02-25 00:00:00.000',5000,184373 UNION ALL

  SELECT 98465,6690,1,0,0,'2016-02-25 00:00:00.000',5000,184680 UNION ALL

  SELECT 98466,6690,1,0,0,'2016-02-25 00:00:00.000',5000,184772 UNION ALL

  SELECT 98467,6690,1,0,0,'2016-02-25 00:00:00.000',5000,184844 UNION ALL

  SELECT 98468,6690,1,0,0,'2016-02-25 00:00:00.000',5000,185907 UNION ALL

  SELECT 98469,6690,1,0,0,'2016-02-25 00:00:00.000',5000,185908 UNION ALL

  SELECT 98470,6690,1,0,0,'2016-02-25 00:00:00.000',5000,186423 UNION ALL

  SELECT 98471,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188187 UNION ALL

  SELECT 98472,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188234 UNION ALL

  SELECT 98473,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188236 UNION ALL

  SELECT 98474,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188238 UNION ALL

  SELECT 98475,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188241 UNION ALL

  SELECT 98476,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188243 UNION ALL

  SELECT 98477,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188245 UNION ALL

  SELECT 98478,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188247 UNION ALL

  SELECT 98479,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188249 UNION ALL

  SELECT 98480,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188251 UNION ALL

  SELECT 98481,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188253 UNION ALL

  SELECT 98482,6690,1,0,0,'2016-02-25 00:00:00.000',5000,188255 UNION ALL

  SELECT 98483,6690,1,0,0,'2016-02-25 00:00:00.000',5000,191753 UNION ALL

  SELECT 98484,6690,1,0,0,'2016-02-25 00:00:00.000',5000,192161 UNION ALL

  SELECT 98485,6690,1,0,0,'2016-02-25 00:00:00.000',5000,192417 UNION ALL

  SELECT 98486,6690,1,0,0,'2016-02-25 00:00:00.000',5000,193064 UNION ALL

  SELECT 98487,6690,1,0,0,'2016-02-25 00:00:00.000',5000,193066 UNION ALL

  SELECT 98488,6690,1,0,0,'2016-02-25 00:00:00.000',5000,193140 UNION ALL

  SELECT 98489,6690,1,0,0,'2016-02-25 00:00:00.000',5000,239 UNION ALL

  SELECT 98490,6690,1,0,0,'2016-02-25 00:00:00.000',5000,241 UNION ALL

  SELECT 98491,6690,1,0,0,'2016-02-25 00:00:00.000',5000,250 UNION ALL

  SELECT 98492,6690,1,0,0,'2016-02-25 00:00:00.000',5000,198287 UNION ALL

  SELECT 98493,6690,1,0,0,'2016-02-25 00:00:00.000',5000,198289 UNION ALL

  SELECT 98494,6690,1,0,0,'2016-02-25 00:00:00.000',5000,198493 UNION ALL

  SELECT 98495,6690,1,0,0,'2016-02-25 00:00:00.000',5000,198836 UNION ALL

  SELECT 98496,6690,1,0,0,'2016-02-25 00:00:00.000',5000,198838 UNION ALL

  SELECT 98497,6690,1,0,0,'2016-02-25 00:00:00.000',5000,198840 UNION ALL

  SELECT 98498,6690,1,0,0,'2016-02-25 00:00:00.000',5000,199104 UNION ALL

  SELECT 98499,6690,1,0,0,'2016-02-25 00:00:00.000',5000,199133 UNION ALL

  SELECT 98500,6690,1,0,0,'2016-02-25 00:00:00.000',5000,199179 UNION ALL

  SELECT 98501,6690,1,0,0,'2016-02-25 00:00:00.000',5007,198424 UNION ALL

  SELECT 98502,6690,1,0,0,'2016-02-25 00:00:00.000',5047,144915 UNION ALL

  SELECT 98503,6690,1,0,0,'2016-02-25 00:00:00.000',5047,145797 UNION ALL

  SELECT 98504,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186266 UNION ALL

  SELECT 98505,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186268 UNION ALL

  SELECT 98506,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186277 UNION ALL

  SELECT 98507,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186853 UNION ALL

  SELECT 98508,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186855 UNION ALL

  SELECT 98509,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186856 UNION ALL

  SELECT 98510,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186857 UNION ALL

  SELECT 98511,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186858 UNION ALL

  SELECT 98512,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186860 UNION ALL

  SELECT 98513,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186863 UNION ALL

  SELECT 98514,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186864 UNION ALL

  SELECT 98515,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186865 UNION ALL

  SELECT 98516,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186866 UNION ALL

  SELECT 98517,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186867 UNION ALL

  SELECT 98518,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186868 UNION ALL

  SELECT 98519,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186869 UNION ALL

  SELECT 98520,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186870 UNION ALL

  SELECT 98521,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186871 UNION ALL

  SELECT 98522,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186872 UNION ALL

  SELECT 98523,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186875 UNION ALL

  SELECT 98524,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186876 UNION ALL

  SELECT 98525,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186877 UNION ALL

  SELECT 98526,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186878 UNION ALL

  SELECT 98527,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186879 UNION ALL

  SELECT 98528,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186880 UNION ALL

  SELECT 98529,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186881 UNION ALL

  SELECT 98530,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186885 UNION ALL

  SELECT 98531,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186886 UNION ALL

  SELECT 98532,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186887 UNION ALL

  SELECT 98533,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186889 UNION ALL

  SELECT 98534,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186890 UNION ALL

  SELECT 98535,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186891 UNION ALL

  SELECT 98536,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186892 UNION ALL

  SELECT 98537,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186895 UNION ALL

  SELECT 98538,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186896 UNION ALL

  SELECT 98539,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186897 UNION ALL

  SELECT 98540,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186898 UNION ALL

  SELECT 98541,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186899 UNION ALL

  SELECT 98542,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186900 UNION ALL

  SELECT 98543,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186902 UNION ALL

  SELECT 98544,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186903 UNION ALL

  SELECT 98545,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186906 UNION ALL

  SELECT 98546,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186907 UNION ALL

  SELECT 98547,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186908 UNION ALL

  SELECT 98548,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186909 UNION ALL

  SELECT 98549,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186910 UNION ALL

  SELECT 98550,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186911 UNION ALL

  SELECT 98551,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186912 UNION ALL

  SELECT 98552,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186915 UNION ALL

  SELECT 98553,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186917 UNION ALL

  SELECT 98554,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186918 UNION ALL

  SELECT 98555,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186919 UNION ALL

  SELECT 98556,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186920 UNION ALL

  SELECT 98557,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186921 UNION ALL

  SELECT 98558,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186922 UNION ALL

  SELECT 98559,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186924 UNION ALL

  SELECT 98560,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186925 UNION ALL

  SELECT 98561,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186927 UNION ALL

  SELECT 98562,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186928 UNION ALL

  SELECT 98563,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186929 UNION ALL

  SELECT 98564,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186930 UNION ALL

  SELECT 98565,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186931 UNION ALL

  SELECT 98566,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186932 UNION ALL

  SELECT 98567,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186933 UNION ALL

  SELECT 98568,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186934 UNION ALL

  SELECT 98569,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186935 UNION ALL

  SELECT 98570,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186936 UNION ALL

  SELECT 98571,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186937 UNION ALL

  SELECT 98572,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186938 UNION ALL

  SELECT 98573,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186939 UNION ALL

  SELECT 98574,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186940 UNION ALL

  SELECT 98575,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186941 UNION ALL

  SELECT 98576,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186942 UNION ALL

  SELECT 98577,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186943 UNION ALL

  SELECT 98578,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186944 UNION ALL

  SELECT 98579,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186945 UNION ALL

  SELECT 98580,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186949 UNION ALL

  SELECT 98581,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186950 UNION ALL

  SELECT 98582,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186951 UNION ALL

  SELECT 98583,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186952 UNION ALL

  SELECT 98584,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186953 UNION ALL

  SELECT 98585,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186954 UNION ALL

  SELECT 98586,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186956 UNION ALL

  SELECT 98587,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186957 UNION ALL

  SELECT 98588,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186958 UNION ALL

  SELECT 98589,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186959 UNION ALL

  SELECT 98590,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186960 UNION ALL

  SELECT 98591,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186961 UNION ALL

  SELECT 98592,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186963 UNION ALL

  SELECT 98593,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186964 UNION ALL

  SELECT 98594,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186966 UNION ALL

  SELECT 98595,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186967 UNION ALL

  SELECT 98596,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186968 UNION ALL

  SELECT 98597,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186969 UNION ALL

  SELECT 98598,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186970 UNION ALL

  SELECT 98599,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186971 UNION ALL

  SELECT 98600,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186972 UNION ALL

  SELECT 98601,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186973 UNION ALL

  SELECT 98602,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186974 UNION ALL

  SELECT 98603,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186978 UNION ALL

  SELECT 98604,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186981 UNION ALL

  SELECT 98605,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186982 UNION ALL

  SELECT 98606,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186983 UNION ALL

  SELECT 98607,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186984 UNION ALL

  SELECT 98608,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186987 UNION ALL

  SELECT 98609,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186988 UNION ALL

  SELECT 98610,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186990 UNION ALL

  SELECT 98611,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186991 UNION ALL

  SELECT 98612,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186992 UNION ALL

  SELECT 98613,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186993 UNION ALL

  SELECT 98614,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186994 UNION ALL

  SELECT 98615,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186995 UNION ALL

  SELECT 98616,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186996 UNION ALL

  SELECT 98617,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186997 UNION ALL

  SELECT 98618,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186998 UNION ALL

  SELECT 98619,6690,1,0,0,'2016-02-25 00:00:00.000',5047,187000 UNION ALL

  SELECT 98620,6690,1,0,0,'2016-02-25 00:00:00.000',5047,187001 UNION ALL

  SELECT 98621,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188235 UNION ALL

  SELECT 98622,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188237 UNION ALL

  SELECT 98623,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188239 UNION ALL

  SELECT 98624,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188242 UNION ALL

  SELECT 98625,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188244 UNION ALL

  SELECT 98626,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188246 UNION ALL

  SELECT 98627,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188248 UNION ALL

  SELECT 98628,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188250 UNION ALL

  SELECT 98629,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188252 UNION ALL

  SELECT 98630,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188254 UNION ALL

  SELECT 98631,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188256 UNION ALL

  SELECT 98632,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188257 UNION ALL

  SELECT 98633,6690,1,0,0,'2016-02-25 00:00:00.000',5047,188258 UNION ALL

  SELECT 98634,6690,1,0,0,'2016-02-25 00:00:00.000',5047,192002 UNION ALL

  SELECT 98635,6690,1,0,0,'2016-02-25 00:00:00.000',5047,192162 UNION ALL

  SELECT 98636,6690,1,0,0,'2016-02-25 00:00:00.000',5047,192418 UNION ALL

  SELECT 98637,6690,1,0,0,'2016-02-25 00:00:00.000',5047,193065 UNION ALL

  SELECT 98638,6690,1,0,0,'2016-02-25 00:00:00.000',5047,193067 UNION ALL

  SELECT 98639,6690,1,0,0,'2016-02-25 00:00:00.000',5047,193141 UNION ALL

  SELECT 98640,6690,1,0,0,'2016-02-25 00:00:00.000',5047,197995 UNION ALL

  SELECT 98641,6690,1,0,0,'2016-02-25 00:00:00.000',5047,198288 UNION ALL

  SELECT 98642,6690,1,0,0,'2016-02-25 00:00:00.000',5047,198290 UNION ALL

  SELECT 98643,6690,1,0,0,'2016-02-25 00:00:00.000',5047,198494 UNION ALL

  SELECT 98644,6690,1,0,0,'2016-02-25 00:00:00.000',5047,198837 UNION ALL

  SELECT 98645,6690,1,0,0,'2016-02-25 00:00:00.000',5047,198839 UNION ALL

  SELECT 98646,6690,1,0,0,'2016-02-25 00:00:00.000',5047,198841 UNION ALL

  SELECT 98647,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199105 UNION ALL

  SELECT 98648,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199134 UNION ALL

  SELECT 98649,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199180 UNION ALL

  SELECT 98650,6690,1,0,0,'2016-02-25 00:00:00.000',102624,102624 UNION ALL

  SELECT 98651,6690,1,0,0,'2016-02-25 00:00:00.000',186985,186985 UNION ALL

  SELECT 98652,6690,1,0,0,'2016-02-25 00:00:00.000',0001,196263 UNION ALL

  SELECT 98653,6690,1,0,0,'2016-02-25 00:00:00.000',5217,23 UNION ALL

  SELECT 98654,6690,1,0,0,'2016-02-25 00:00:00.000',5217,104 UNION ALL

  SELECT 98655,6690,1,0,0,'2016-02-25 00:00:00.000',5217,105 UNION ALL

  SELECT 98656,6690,1,0,0,'2016-02-25 00:00:00.000',5217,107 UNION ALL

  SELECT 98657,6690,1,0,0,'2016-02-25 00:00:00.000',5217,114 UNION ALL

  SELECT 98658,6690,1,0,0,'2016-02-25 00:00:00.000',7010,199302 UNION ALL

  SELECT 98659,6690,1,0,0,'2016-02-25 00:00:00.000',5215,300 UNION ALL

  SELECT 98660,6690,1,0,0,'2016-02-25 00:00:00.000',5215,210 UNION ALL

  SELECT 98661,6690,1,0,0,'2016-02-25 00:00:00.000',199304,199304 UNION ALL

  SELECT 98662,6690,1,0,0,'2016-02-25 00:00:00.000',0001,196591 UNION ALL

  SELECT 98663,6690,1,0,0,'2016-02-25 00:00:00.000',5007,199310 UNION ALL

  SELECT 98664,6690,1,0,0,'2016-02-25 00:00:00.000',1000120 ,457 UNION ALL

  SELECT 98665,6690,1,0,0,'2016-02-25 00:00:00.000',0089,104 UNION ALL

  SELECT 98666,6690,1,0,0,'2016-02-25 00:00:00.000',0089,118 UNION ALL

  SELECT 98667,6690,1,0,0,'2016-02-25 00:00:00.000',0089,120 UNION ALL

  SELECT 98668,6690,1,0,0,'2016-02-25 00:00:00.000',5000,199321 UNION ALL

  SELECT 98669,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199322 UNION ALL

  SELECT 98670,6690,1,0,0,'2016-02-25 00:00:00.000',5004,5400 UNION ALL

  SELECT 98671,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199077 UNION ALL

  SELECT 98672,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7382 UNION ALL

  SELECT 98673,6690,1,0,0,'2016-02-25 00:00:00.000',199338,199338 UNION ALL

  SELECT 98674,6690,1,0,0,'2016-02-25 00:00:00.000',5004,1224 UNION ALL

  SELECT 98675,6690,1,0,0,'2016-02-25 00:00:00.000',0001,197257 UNION ALL

  SELECT 98676,6690,1,0,0,'2016-02-25 00:00:00.000',0001,197643 UNION ALL

  SELECT 98677,6690,1,0,0,'2016-02-25 00:00:00.000',199368,199368 UNION ALL

  SELECT 98678,6690,1,0,0,'2016-02-25 00:00:00.000',112052,112052 UNION ALL

  SELECT 98679,6690,1,0,0,'2016-02-25 00:00:00.000',111005,111005 UNION ALL

  SELECT 98680,6690,1,0,0,'2016-02-25 00:00:00.000',5116,199391 UNION ALL

  SELECT 98681,6690,1,0,0,'2016-02-25 00:00:00.000',5116,199392 UNION ALL

  SELECT 98682,6690,1,0,0,'2016-02-25 00:00:00.000',6001,908 UNION ALL

  SELECT 98683,6690,1,0,0,'2016-02-25 00:00:00.000',0001,195363 UNION ALL

  SELECT 98684,6690,1,0,0,'2016-02-25 00:00:00.000',0001,196384 UNION ALL

  SELECT 98685,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199399 UNION ALL

  SELECT 98686,6690,1,0,0,'2016-02-25 00:00:00.000',0001,193198 UNION ALL

  SELECT 98687,6690,1,0,0,'2016-02-25 00:00:00.000',0001,192639 UNION ALL

  SELECT 98688,6690,1,0,0,'2016-02-25 00:00:00.000',199434,199434 UNION ALL

  SELECT 98689,6690,1,0,0,'2016-02-25 00:00:00.000',5009,199439 UNION ALL

  SELECT 98690,6690,1,0,0,'2016-02-25 00:00:00.000',0089,115 UNION ALL

  SELECT 98691,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199163 UNION ALL

  SELECT 98692,6690,1,0,0,'2016-02-25 00:00:00.000',0001,160358 UNION ALL

  SELECT 98693,6690,1,0,0,'2016-02-25 00:00:00.000',5009,872 UNION ALL

  SELECT 98694,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198996 UNION ALL

  SELECT 98695,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4533 UNION ALL

  SELECT 98696,6690,1,0,0,'2016-02-25 00:00:00.000',5004,1017 UNION ALL

  SELECT 98697,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4100 UNION ALL

  SELECT 98698,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7115 UNION ALL

  SELECT 98699,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7124 UNION ALL

  SELECT 98700,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7606 UNION ALL

  SELECT 98701,6690,1,0,0,'2016-02-25 00:00:00.000',198436,198436 UNION ALL

  SELECT 98702,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198730 UNION ALL

  SELECT 98703,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7136 UNION ALL

  SELECT 98704,6690,1,0,0,'2016-02-25 00:00:00.000',5004,5215 UNION ALL

  SELECT 98705,6690,1,0,0,'2016-02-25 00:00:00.000',0001,197477 UNION ALL

  SELECT 98706,6690,1,0,0,'2016-02-25 00:00:00.000',0377,601701 UNION ALL

  SELECT 98707,6690,1,0,0,'2016-02-25 00:00:00.000',6001,337 UNION ALL

  SELECT 98708,6690,1,0,0,'2016-02-25 00:00:00.000',199519,199519 UNION ALL

  SELECT 98709,6690,1,0,0,'2016-02-25 00:00:00.000',0001,199273 UNION ALL

  SELECT 98710,6690,1,0,0,'2016-02-25 00:00:00.000',199548,199548 UNION ALL

  SELECT 98711,6690,1,0,0,'2016-02-25 00:00:00.000',199550,199550 UNION ALL

  SELECT 98712,6690,1,0,0,'2016-02-25 00:00:00.000',5004,6303 UNION ALL

  SELECT 98713,6690,1,0,0,'2016-02-25 00:00:00.000',5007,104075 UNION ALL

  SELECT 98714,6690,1,0,0,'2016-02-25 00:00:00.000',0001,194203 UNION ALL

  SELECT 98715,6690,1,0,0,'2016-02-25 00:00:00.000',0001,193487 UNION ALL

  SELECT 98716,6690,1,0,0,'2016-02-25 00:00:00.000',5009,863 UNION ALL

  SELECT 98717,6690,1,0,0,'2016-02-25 00:00:00.000',5004,6670 UNION ALL

  SELECT 98718,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7461 UNION ALL

  SELECT 98719,6690,1,0,0,'2016-02-25 00:00:00.000',6091,199580 UNION ALL

  SELECT 98720,6690,1,0,0,'2016-02-25 00:00:00.000',5007,394 UNION ALL

  SELECT 98721,6690,1,0,0,'2016-02-25 00:00:00.000',199592,199592 UNION ALL

  SELECT 98722,6690,1,0,0,'2016-02-25 00:00:00.000',5009,875 UNION ALL

  SELECT 98723,6690,1,0,0,'2016-02-25 00:00:00.000',6001,902 UNION ALL

  SELECT 98724,6690,1,0,0,'2016-02-25 00:00:00.000',192170,192170 UNION ALL

  SELECT 98725,6690,1,0,0,'2016-02-25 00:00:00.000',199614,199614 UNION ALL

  SELECT 98726,6690,1,0,0,'2016-02-25 00:00:00.000',5009,212 UNION ALL

  SELECT 98727,6690,1,0,0,'2016-02-25 00:00:00.000',5000,199622 UNION ALL

  SELECT 98728,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199623 UNION ALL

  SELECT 98729,6690,1,0,0,'2016-02-25 00:00:00.000',5000,199647 UNION ALL

  SELECT 98730,6690,1,0,0,'2016-02-25 00:00:00.000',5047,199648 UNION ALL

  SELECT 98731,6690,1,0,0,'2016-02-25 00:00:00.000',199654,199654 UNION ALL

  SELECT 98732,6690,1,0,0,'2016-02-25 00:00:00.000',199656,199656 UNION ALL

  SELECT 98733,6690,1,0,0,'2016-02-25 00:00:00.000',5009,202 UNION ALL

  SELECT 98734,6690,1,0,0,'2016-02-25 00:00:00.000',0089,191494 UNION ALL

  SELECT 98735,6690,1,0,0,'2016-02-25 00:00:00.000',199673,199673 UNION ALL

  SELECT 98736,6690,1,0,0,'2016-02-25 00:00:00.000',0001,191312 UNION ALL

  SELECT 98737,6690,1,0,0,'2016-02-25 00:00:00.000',0001,198094 UNION ALL

  SELECT 98738,6690,1,0,0,'2016-02-25 00:00:00.000',5009,869 UNION ALL

  SELECT 98739,6690,1,0,0,'2016-02-25 00:00:00.000',5009,204 UNION ALL

  SELECT 98740,6690,1,0,0,'2016-02-25 00:00:00.000',0001,197269 UNION ALL

  SELECT 98741,6690,1,0,0,'2016-02-25 00:00:00.000',5007,199696 UNION ALL

  SELECT 98742,6690,1,0,0,'2016-02-25 00:00:00.000',5004,9561 UNION ALL

  SELECT 98743,6690,1,0,0,'2016-02-25 00:00:00.000',5004,6395 UNION ALL

  SELECT 97333,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186977 UNION ALL

  SELECT 97334,6690,1,0,0,'2016-02-25 00:00:00.000',5047,186913 UNION ALL

  SELECT 97335,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7137 UNION ALL

  SELECT 97336,6690,1,0,0,'2016-02-25 00:00:00.000',199224,199224 UNION ALL

  SELECT 97337,6690,1,0,0,'2016-02-25 00:00:00.000',100610,100610 UNION ALL

  SELECT 97338,6690,1,0,0,'2016-02-25 00:00:00.000',103010,103010 UNION ALL

  SELECT 97339,6690,1,0,0,'2016-02-25 00:00:00.000',103218,103218 UNION ALL

  SELECT 97340,6690,1,0,0,'2016-02-25 00:00:00.000',105288,105288 UNION ALL

  SELECT 97341,6690,1,0,0,'2016-02-25 00:00:00.000',105833,105833 UNION ALL

  SELECT 97342,6690,1,0,0,'2016-02-25 00:00:00.000',106294,106294 UNION ALL

  SELECT 97343,6690,1,0,0,'2016-02-25 00:00:00.000',106534,106534 UNION ALL

  SELECT 97344,6690,1,0,0,'2016-02-25 00:00:00.000',107789,107789 UNION ALL

  SELECT 97345,6690,1,0,0,'2016-02-25 00:00:00.000',108316,108316 UNION ALL

  SELECT 97346,6690,1,0,0,'2016-02-25 00:00:00.000',109470,109470 UNION ALL

  SELECT 97347,6690,1,0,0,'2016-02-25 00:00:00.000',110072,110072 UNION ALL

  SELECT 97348,6690,1,0,0,'2016-02-25 00:00:00.000',110080,110080 UNION ALL

  SELECT 97349,6690,1,0,0,'2016-02-25 00:00:00.000',110718,110718 UNION ALL

  SELECT 97350,6690,1,0,0,'2016-02-25 00:00:00.000',111385,111385 UNION ALL

  SELECT 97351,6690,1,0,0,'2016-02-25 00:00:00.000',111971,111971 UNION ALL

  SELECT 97352,6690,1,0,0,'2016-02-25 00:00:00.000',115329,115329 UNION ALL

  SELECT 97353,6690,1,0,0,'2016-02-25 00:00:00.000',115386,115386 UNION ALL

  SELECT 97354,6690,1,0,0,'2016-02-25 00:00:00.000',117754,2 UNION ALL

  SELECT 97355,6690,1,0,0,'2016-02-25 00:00:00.000',117788,117788 UNION ALL

  SELECT 97356,6690,1,0,0,'2016-02-25 00:00:00.000',117911,117911 UNION ALL

  SELECT 97357,6690,1,0,0,'2016-02-25 00:00:00.000',118612,118612 UNION ALL

  SELECT 97358,6690,1,0,0,'2016-02-25 00:00:00.000',118745,118745 UNION ALL

  SELECT 97359,6690,1,0,0,'2016-02-25 00:00:00.000',121608,121608 UNION ALL

  SELECT 97360,6690,1,0,0,'2016-02-25 00:00:00.000',121780,121780 UNION ALL

  SELECT 97361,6690,1,0,0,'2016-02-25 00:00:00.000',122341,122341 UNION ALL

  SELECT 97362,6690,1,0,0,'2016-02-25 00:00:00.000',122598,122598 UNION ALL

  SELECT 97363,6690,1,0,0,'2016-02-25 00:00:00.000',124453,124453 UNION ALL

  SELECT 97364,6690,1,0,0,'2016-02-25 00:00:00.000',126409,126409 UNION ALL

  SELECT 97365,6690,1,0,0,'2016-02-25 00:00:00.000',128165,128165 UNION ALL

  SELECT 97366,6690,1,0,0,'2016-02-25 00:00:00.000',132456,132456 UNION ALL

  SELECT 97367,6690,1,0,0,'2016-02-25 00:00:00.000',133454,133454 UNION ALL

  SELECT 97368,6690,1,0,0,'2016-02-25 00:00:00.000',134189,134189 UNION ALL

  SELECT 97369,6690,1,0,0,'2016-02-25 00:00:00.000',135095,135095 UNION ALL

  SELECT 97370,6690,1,0,0,'2016-02-25 00:00:00.000',139006,139006 UNION ALL

  SELECT 97371,6690,1,0,0,'2016-02-25 00:00:00.000',140681,140681 UNION ALL

  SELECT 97372,6690,1,0,0,'2016-02-25 00:00:00.000',141846,141846 UNION ALL

  SELECT 97373,6690,1,0,0,'2016-02-25 00:00:00.000',142737,142737 UNION ALL

  SELECT 97374,6690,1,0,0,'2016-02-25 00:00:00.000',143354,143354 UNION ALL

  SELECT 97375,6690,1,0,0,'2016-02-25 00:00:00.000',144642,144642 UNION ALL

  SELECT 97376,6690,1,0,0,'2016-02-25 00:00:00.000',145151,145151 UNION ALL

  SELECT 97377,6690,1,0,0,'2016-02-25 00:00:00.000',145730,145730 UNION ALL

  SELECT 97378,6690,1,0,0,'2016-02-25 00:00:00.000',148122,148122 UNION ALL

  SELECT 97379,6690,1,0,0,'2016-02-25 00:00:00.000',152462,152462 UNION ALL

  SELECT 97380,6690,1,0,0,'2016-02-25 00:00:00.000',161596,17 UNION ALL

  SELECT 97381,6690,1,0,0,'2016-02-25 00:00:00.000',162198,162198 UNION ALL

  SELECT 97382,6690,1,0,0,'2016-02-25 00:00:00.000',169391,169391 UNION ALL

  SELECT 97383,6690,1,0,0,'2016-02-25 00:00:00.000',169631,169631 UNION ALL

  SELECT 97384,6690,1,0,0,'2016-02-25 00:00:00.000',173484,173484 UNION ALL

  SELECT 97385,6690,1,0,0,'2016-02-25 00:00:00.000',177329,2 UNION ALL

  SELECT 97386,6690,1,0,0,'2016-02-25 00:00:00.000',180257,180257 UNION ALL

  SELECT 97387,6690,1,0,0,'2016-02-25 00:00:00.000',183828,183828 UNION ALL

  SELECT 97388,6690,1,0,0,'2016-02-25 00:00:00.000',183922,183922 UNION ALL

  SELECT 97389,6690,1,0,0,'2016-02-25 00:00:00.000',184091,184091 UNION ALL

  SELECT 97390,6690,1,0,0,'2016-02-25 00:00:00.000',184144,184144 UNION ALL

  SELECT 97391,6690,1,0,0,'2016-02-25 00:00:00.000',184433,184433 UNION ALL

  SELECT 97392,6690,1,0,0,'2016-02-25 00:00:00.000',184755,184755 UNION ALL

  SELECT 97393,6690,1,0,0,'2016-02-25 00:00:00.000',184797,184797 UNION ALL

  SELECT 97394,6690,1,0,0,'2016-02-25 00:00:00.000',185997,185997 UNION ALL

  SELECT 97395,6690,1,0,0,'2016-02-25 00:00:00.000',186387,186387 UNION ALL

  SELECT 97396,6690,1,0,0,'2016-02-25 00:00:00.000',186515,186515 UNION ALL

  SELECT 97397,6690,1,0,0,'2016-02-25 00:00:00.000',186717,186717 UNION ALL

  SELECT 97398,6690,1,0,0,'2016-02-25 00:00:00.000',186749,10 UNION ALL

  SELECT 97399,6690,1,0,0,'2016-02-25 00:00:00.000',187067,187067 UNION ALL

  SELECT 97400,6690,1,0,0,'2016-02-25 00:00:00.000',187274,187274 UNION ALL

  SELECT 97401,6690,1,0,0,'2016-02-25 00:00:00.000',187412,187412 UNION ALL

  SELECT 97402,6690,1,0,0,'2016-02-25 00:00:00.000',187670,187670 UNION ALL

  SELECT 97403,6690,1,0,0,'2016-02-25 00:00:00.000',187874,6 UNION ALL

  SELECT 97404,6690,1,0,0,'2016-02-25 00:00:00.000',188079,188079 UNION ALL

  SELECT 97405,6690,1,0,0,'2016-02-25 00:00:00.000',188289,188289 UNION ALL

  SELECT 97406,6690,1,0,0,'2016-02-25 00:00:00.000',189065,189065 UNION ALL

  SELECT 97407,6690,1,0,0,'2016-02-25 00:00:00.000',189609,189609 UNION ALL

  SELECT 97408,6690,1,0,0,'2016-02-25 00:00:00.000',191521,191521 UNION ALL

  SELECT 97409,6690,1,0,0,'2016-02-25 00:00:00.000',192490,192490 UNION ALL

  SELECT 97410,6690,1,0,0,'2016-02-25 00:00:00.000',192746,192746 UNION ALL

  SELECT 97411,6690,1,0,0,'2016-02-25 00:00:00.000',193323,7 UNION ALL

  SELECT 97412,6690,1,0,0,'2016-02-25 00:00:00.000',194292,194292 UNION ALL

  SELECT 97413,6690,1,0,0,'2016-02-25 00:00:00.000',197099,197099 UNION ALL

  SELECT 97414,6690,1,0,0,'2016-02-25 00:00:00.000',0098,187351 UNION ALL

  SELECT 97415,6690,1,0,0,'2016-02-25 00:00:00.000',0377,19 UNION ALL

  SELECT 99408,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8211 UNION ALL

  SELECT 99409,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8653 UNION ALL

  SELECT 99410,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7950 UNION ALL

  SELECT 99411,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8285 UNION ALL

  SELECT 99412,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8661 UNION ALL

  SELECT 99413,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8266 UNION ALL

  SELECT 99414,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8293 UNION ALL

  SELECT 99415,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8183 UNION ALL

  SELECT 99416,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8672 UNION ALL

  SELECT 99417,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8221 UNION ALL

  SELECT 99418,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8287 UNION ALL

  SELECT 99419,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8208 UNION ALL

  SELECT 99420,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8204 UNION ALL

  SELECT 99421,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8265 UNION ALL

  SELECT 99422,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8654 UNION ALL

  SELECT 99423,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8215 UNION ALL

  SELECT 99424,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8231 UNION ALL

  SELECT 99425,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8283 UNION ALL

  SELECT 99426,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7958 UNION ALL

  SELECT 99427,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8220 UNION ALL

  SELECT 99428,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8219 UNION ALL

  SELECT 99429,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8278 UNION ALL

  SELECT 99430,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6966 UNION ALL

  SELECT 99431,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8668 UNION ALL

  SELECT 99432,6690,1,0,0,'2016-02-25 00:00:00.000',6111,2573 UNION ALL

  SELECT 99433,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4333 UNION ALL

  SELECT 99434,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7426 UNION ALL

  SELECT 99435,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8230 UNION ALL

  SELECT 99436,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8284 UNION ALL

  SELECT 99437,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8295 UNION ALL

  SELECT 99438,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8229 UNION ALL

  SELECT 99439,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8210 UNION ALL

  SELECT 99440,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8263 UNION ALL

  SELECT 99441,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6991 UNION ALL

  SELECT 99442,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8290 UNION ALL

  SELECT 99443,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7906 UNION ALL

  SELECT 99444,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8227 UNION ALL

  SELECT 99445,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8272 UNION ALL

  SELECT 99446,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7952 UNION ALL

  SELECT 99447,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8289 UNION ALL

  SELECT 99448,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8226 UNION ALL

  SELECT 99449,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8181 UNION ALL

  SELECT 99450,6690,1,0,0,'2016-02-25 00:00:00.000',5004,8133 UNION ALL

  SELECT 99451,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4250 UNION ALL

  SELECT 99452,6690,1,0,0,'2016-02-25 00:00:00.000',5004,7176 UNION ALL

  SELECT 99453,6690,1,0,0,'2016-02-25 00:00:00.000',5004,8480 UNION ALL

  SELECT 99454,6690,1,0,0,'2016-02-25 00:00:00.000',5004,6131 UNION ALL

  SELECT 99455,6690,1,0,0,'2016-02-25 00:00:00.000',5004,2918 UNION ALL

  SELECT 99456,6690,1,0,0,'2016-02-25 00:00:00.000',5004,6207 UNION ALL

  SELECT 99457,6690,1,0,0,'2016-02-25 00:00:00.000',7032,14 UNION ALL

  SELECT 99458,6690,1,0,0,'2016-02-25 00:00:00.000',5013,881 UNION ALL

  SELECT 99459,6690,1,0,0,'2016-02-25 00:00:00.000',6111,1068 UNION ALL

  SELECT 99460,6690,1,0,0,'2016-02-25 00:00:00.000',5217,120 UNION ALL

  SELECT 99461,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4617 UNION ALL

  SELECT 99462,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4624 UNION ALL

  SELECT 99463,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4620 UNION ALL

  SELECT 99464,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4621 UNION ALL

  SELECT 99465,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4628 UNION ALL

  SELECT 99466,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4627 UNION ALL

  SELECT 99467,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4625 UNION ALL

  SELECT 99468,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4635 UNION ALL

  SELECT 99469,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4634 UNION ALL

  SELECT 99470,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4645 UNION ALL

  SELECT 99471,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4629 UNION ALL

  SELECT 99472,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4623 UNION ALL

  SELECT 99473,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4639 UNION ALL

  SELECT 99474,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4637 UNION ALL

  SELECT 99475,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4636 UNION ALL

  SELECT 99476,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4640 UNION ALL

  SELECT 99477,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4662 UNION ALL

  SELECT 99478,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4658 UNION ALL

  SELECT 99479,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4660 UNION ALL

  SELECT 99480,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4659 UNION ALL

  SELECT 99481,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4657 UNION ALL

  SELECT 99482,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4673 UNION ALL

  SELECT 99483,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4672 UNION ALL

  SELECT 99484,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4668 UNION ALL

  SELECT 99485,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4667 UNION ALL

  SELECT 99486,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4669 UNION ALL

  SELECT 99487,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4671 UNION ALL

  SELECT 99488,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4670 UNION ALL

  SELECT 99489,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4674 UNION ALL

  SELECT 99490,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4665 UNION ALL

  SELECT 99491,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4666 UNION ALL

  SELECT 99492,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4663 UNION ALL

  SELECT 99493,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4664 UNION ALL

  SELECT 99494,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4652 UNION ALL

  SELECT 99495,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4654 UNION ALL

  SELECT 99496,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4653 UNION ALL

  SELECT 99497,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4643 UNION ALL

  SELECT 99498,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4644 UNION ALL

  SELECT 99499,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4641 UNION ALL

  SELECT 99500,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4646 UNION ALL

  SELECT 99501,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4650 UNION ALL

  SELECT 99502,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4647 UNION ALL

  SELECT 99503,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8182 UNION ALL

  SELECT 99504,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8275 UNION ALL

  SELECT 99505,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8282 UNION ALL

  SELECT 99506,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8214 UNION ALL

  SELECT 99507,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8274 UNION ALL

  SELECT 99508,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8222 UNION ALL

  SELECT 99509,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8246 UNION ALL

  SELECT 99510,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8268 UNION ALL

  SELECT 99511,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8271 UNION ALL

  SELECT 99512,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7908 UNION ALL

  SELECT 99513,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7953 UNION ALL

  SELECT 99514,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8657 UNION ALL

  SELECT 99515,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8659 UNION ALL

  SELECT 99516,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8187 UNION ALL

  SELECT 99517,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8184 UNION ALL

  SELECT 99518,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8186 UNION ALL

  SELECT 99519,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8185 UNION ALL

  SELECT 99520,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8188 UNION ALL

  SELECT 99521,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8191 UNION ALL

  SELECT 99522,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8656 UNION ALL

  SELECT 99523,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8681 UNION ALL

  SELECT 99524,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4585 UNION ALL

  SELECT 99525,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4590 UNION ALL

  SELECT 99526,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4583 UNION ALL

  SELECT 99527,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4588 UNION ALL

  SELECT 99528,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4591 UNION ALL

  SELECT 99529,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4575 UNION ALL

  SELECT 99530,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4586 UNION ALL

  SELECT 99531,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4577 UNION ALL

  SELECT 99532,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4592 UNION ALL

  SELECT 99533,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4593 UNION ALL

  SELECT 99534,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4564 UNION ALL

  SELECT 99535,6690,1,0,0,'2016-02-25 00:00:00.000',7037,999999 UNION ALL

  SELECT 99536,6690,1,0,0,'2016-02-25 00:00:00.000',7063,303775 UNION ALL

  SELECT 99537,6690,1,0,0,'2016-02-25 00:00:00.000',303790,303790 UNION ALL

  SELECT 99538,6690,1,0,0,'2016-02-25 00:00:00.000',7065,199855 UNION ALL

  SELECT 99539,6690,1,0,0,'2016-02-25 00:00:00.000',303820,303820 UNION ALL

  SELECT 99540,6690,1,0,0,'2016-02-25 00:00:00.000',7037,7118 UNION ALL

  SELECT 99541,6690,1,0,0,'2016-02-25 00:00:00.000',7037,1577 UNION ALL

  SELECT 99542,6690,1,0,0,'2016-02-25 00:00:00.000',7037,7140 UNION ALL

  SELECT 99543,6690,1,0,0,'2016-02-25 00:00:00.000',7037,2921 UNION ALL

  SELECT 99544,6690,1,0,0,'2016-02-25 00:00:00.000',5000,333 UNION ALL

  SELECT 99545,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4565 UNION ALL

  SELECT 99546,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4595 UNION ALL

  SELECT 99547,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4589 UNION ALL

  SELECT 99548,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4594 UNION ALL

  SELECT 99549,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4582 UNION ALL

  SELECT 99550,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4587 UNION ALL

  SELECT 99551,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4574 UNION ALL

  SELECT 99552,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8189 UNION ALL

  SELECT 99553,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8244 UNION ALL

  SELECT 99554,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8190 UNION ALL

  SELECT 99555,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8298 UNION ALL

  SELECT 99556,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7954 UNION ALL

  SELECT 99557,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7941 UNION ALL

  SELECT 99558,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7945 UNION ALL

  SELECT 99559,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7946 UNION ALL

  SELECT 99560,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8262 UNION ALL

  SELECT 99561,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8277 UNION ALL

  SELECT 99562,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7905 UNION ALL

  SELECT 99563,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8297 UNION ALL

  SELECT 99564,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6969 UNION ALL

  SELECT 99565,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8288 UNION ALL

  SELECT 99566,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6964 UNION ALL

  SELECT 99567,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7907 UNION ALL

  SELECT 99568,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7909 UNION ALL

  SELECT 99569,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7960 UNION ALL

  SELECT 99570,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6979 UNION ALL

  SELECT 99571,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7949 UNION ALL

  SELECT 99572,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6981 UNION ALL

  SELECT 99573,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6977 UNION ALL

  SELECT 99574,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6973 UNION ALL

  SELECT 99575,6690,1,0,0,'2016-02-25 00:00:00.000',7036,8228 UNION ALL

  SELECT 99576,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6972 UNION ALL

  SELECT 99577,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6962 UNION ALL

  SELECT 99578,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6961 UNION ALL

  SELECT 99579,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6985 UNION ALL

  SELECT 99580,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7930 UNION ALL

  SELECT 99581,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6997 UNION ALL

  SELECT 99582,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7998 UNION ALL

  SELECT 99583,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7974 UNION ALL

  SELECT 99584,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7911 UNION ALL

  SELECT 99585,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7965 UNION ALL

  SELECT 99586,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7912 UNION ALL

  SELECT 99587,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6953 UNION ALL

  SELECT 99588,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6954 UNION ALL

  SELECT 99589,6690,1,0,0,'2016-02-25 00:00:00.000',7036,7929 UNION ALL

  SELECT 99590,6690,1,0,0,'2016-02-25 00:00:00.000',7036,6940 UNION ALL

  SELECT 99591,6690,1,0,0,'2016-02-25 00:00:00.000',0655,67 UNION ALL

  SELECT 99592,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4675 UNION ALL

  SELECT 99593,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4676 UNION ALL

  SELECT 99594,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4632 UNION ALL

  SELECT 99595,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4630 UNION ALL

  SELECT 99596,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4631 UNION ALL

  SELECT 99597,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4618 UNION ALL

  SELECT 99598,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4626 UNION ALL

  SELECT 99599,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4633 UNION ALL

  SELECT 99600,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4638 UNION ALL

  SELECT 99601,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4648 UNION ALL

  SELECT 99602,6690,1,0,0,'2016-02-25 00:00:00.000',7036,4655 UNION ALL

  SELECT 99603,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4569 UNION ALL

  SELECT 99604,6690,1,0,0,'2016-02-25 00:00:00.000',6111,2475 UNION ALL

  SELECT 99605,6690,1,0,0,'2016-02-25 00:00:00.000',192148,192148 UNION ALL

  SELECT 99606,6690,1,0,0,'2016-02-25 00:00:00.000',6111,2487 UNION ALL

  SELECT 99607,6690,1,0,0,'2016-02-25 00:00:00.000',7067,265 UNION ALL

  SELECT 99608,6690,1,0,0,'2016-02-25 00:00:00.000',5139,999999 UNION ALL

  SELECT 99609,6690,1,0,0,'2016-02-25 00:00:00.000',6111,1526 UNION ALL

  SELECT 99610,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4589 UNION ALL

  SELECT 99611,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4574 UNION ALL

  SELECT 99612,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4582 UNION ALL

  SELECT 99613,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4587 UNION ALL

  SELECT 99614,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4594 UNION ALL

  SELECT 99615,6690,1,0,0,'2016-02-25 00:00:00.000',5004,4595

  /* Problem script below */

  SET STATISTICS IO ON

  IF EXISTS (SELECT 1

  FROM #TempMPM mpm1

  WHERE EXISTS (SELECT 1

  FROM #TempMPM mpm2

  WHERE mpm1.Program <> mpm2.Program

  AND mpm1.MPLMerchantNumber = mpm2.MPLMerchantNumber

  AND mpm1.MPLStoreNumber = mpm2.MPLStoreNumber

  AND ( CASE

  WHEN mpm1.TStatusEffectiveStartDate IS NOT NULL

  AND mpm2.TStatusEffectiveStartDate IS NOT NULL THEN

  CASE

  WHEN mpm1.TStatus = '0' AND mpm2.TStatus = '0' THEN 1

  WHEN mpm1.TStatus = '0' AND mpm2.TStatus = '1' AND mpm1.TStatusEffectiveStartDate < mpm2.TStatusEffectiveStartDate THEN 1

  WHEN mpm1.TStatus = '1' AND mpm2.TStatus = '0' AND mpm1.TStatusEffectiveStartDate > mpm2.TStatusEffectiveStartDate THEN 1

  WHEN mpm1.FleetProgramStatus = '0' AND mpm2.FleetProgramStatus = '0' THEN 1

  ELSE 0

  END

  WHEN mpm1.TStatusEffectiveStartDate IS NULL AND mpm2.TStatusEffectiveStartDate IS NOT NULL AND mpm1.FleetProgramStatus = '0'

  AND ( mpm2.TStatus = '0' OR mpm2.FleetProgramStatus = '0' ) THEN 1

  WHEN mpm1.TStatusEffectiveStartDate IS NOT NULL AND mpm2.TStatusEffectiveStartDate IS NULL

  AND ( mpm1.TStatus = '0' OR mpm1.FleetProgramStatus = '0' )

  AND mpm2.FleetProgramStatus = '0' THEN 1

  WHEN mpm1.TStatusEffectiveStartDate IS NULL

  AND mpm2.TStatusEffectiveStartDate IS NULL

  AND mpm1.FleetProgramStatus = '0'

  AND mpm2.FleetProgramStatus = '0' THEN 1

  ELSE 0

  END ) = 1))

  BEGIN

  SELECT 1

  END

  ELSE

  BEGIN

  SELECT 0

  END

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 12:13 pm

  #1861209

  You'll immediately see the problem query in the original execution plan doing the 1.14 billion rows between the Table Spool and the Nested Loop

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  February 25, 2016 at 12:54 pm

  #1861226

  MyDoggieJessie (2/25/2016)

  ---

  You'll immediately see the problem query in the original execution plan doing the 1.14 billion rows between the Table Spool and the Nested Loop

  Think you forgot to attach the execution plan. 😉

  The data you posted runs almost instantly. It takes less than a second to complete.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 1:02 pm

  #1861227

  Whoops, attachments added.

  Yes it runs super quick using "test" data, but the original procedure can takes 20 minutes depending on how much data gets loaded into that temp table. Look at the original execution plan...that FAT line...1.14 billion rows?

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  February 25, 2016 at 1:07 pm

  #1861229

  MyDoggieJessie (2/25/2016)

  ---

  Whoops, attachments added.

  Yes it runs super quick using "test" data, but the original procedure can takes 20 minutes depending on how much data gets loaded into that temp table. Look at the original execution plan...that FAT line...1.14 billion rows?

  Wait a minute...are you saying you are loading 1.14 billion rows from an external file into a temp table and it can process the whole thing in 20 minutes? That doesn't sound like a performance problem to me. That sounds pretty fast.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 1:13 pm

  #1861231

  I'm not saying that at all. Check out the original execution plan, looks like it's doing some cartesian product in the portion of code I originally posted.

  In the example I provided (with the sample data) there about 1200 records, yet in the execution plan attached for the snippet posted, it still says there's over 12000 rows (which there isn't)

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• ScottPletcher

  SSC Guru

  Points: 101120

  More actions

  February 25, 2016 at 1:26 pm

  #1861233

  Do you (almost) always access this table by StoreNumber and MerchantNumber? If so, cluster the table on those columns -- using the code below -- and try again. I assumed StoreNumber would always be known, but if it's the other way around, cluster first on MerchantNumber -- that won't make any difference for this query.

  Yes, that's a wide key, but that's irrelevant if you don't need any nonclus indexes. On my system, the query went from 12110 logical I/Os to 20.

  DECLARE @index_name varchar(128)

  DECLARE @sql varchar(8000)

  SELECT @index_name = i.name

  FROM tempdb.sys.indexes i

  WHERE i.object_id = OBJECT_ID('#TempMPM') AND i.index_id in (0, 1)

  --SELECT @index_name

  SET @sql = 'ALTER TABLE #TempMPM DROP CONSTRAINT [' + @index_name + ']'

  PRINT @sql

  EXEC(@sql)

  create clustered index tempmpm__cl on #tempmpm ( MPLStoreNumber, MPLMerchantNumber, Program ) with ( fillfactor = 99 );

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

• ScottPletcher

  SSC Guru

  Points: 101120

  More actions

  February 25, 2016 at 1:38 pm

  #1861242

  Btw, you really should strongly consider using ints to represent the StoreNumber and MerchantNumber -- the typical StoreNumberId and MerchantNumberId -- and looking up the 25-byte strings from a separate table. Repeating up to 50 characters row after row is a lot of additional overhead :-).

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

• Jacob Wilkins

  One Orange Chip

  Points: 27976

  More actions

  February 25, 2016 at 2:25 pm

  #1861260

  The big issue is the estimate for the rows coming out of the scan of #TempMPM that is the outer input for the first nested loop join.

  It's estimating only 6.5 rows in the sample data and 16.75 in the real data, but coming out with 1210 in the sample data and 22000 in the plan from your real data.

  With 1200 rows and 51000 rows coming from the inner input in the sample and real data respectively, that underestimate will cause a huge problem.

  6.5*1200 and 16.75*51000 are large numbers of rows for this task, but nothing compared to the actual 1200*1200 and 22000*51000 that come out in the actual executions.

  The two EXISTS are causing SQL Server to think it will have to read far fewer rows than it actually ends up reading (probably due to the row goals introduced). Even removing one of the EXISTS checks fixes the estimates and the performance, at least in the sample data. If you just do a SELECT * FROM #TempMPM mpm1 WHERE EXISTS..., the estimates are accurate and because of that it chooses to implement the Semi Join with a Hash Join instead of a Nested Loops join.

  I have a feeling the logic in the CASE statement can be simplified, but that's just a feeling, and it's not the biggest problem here anyway 🙂

  Here's one rewrite that I think preserves the current logic, and avoids all the messiness introduced to the estimates from the two EXISTS:

  SELECT COUNT(*) FROM

  (

  SELECT TOP 1 'Exists'

  FROM #TempMPM mpm1 INNER JOIN #TempMPM mpm2 ON mpm1.Program <> mpm2.Program

  AND mpm1.MPLMerchantNumber = mpm2.MPLMerchantNumber

  AND mpm1.MPLStoreNumber = mpm2.MPLStoreNumber

  WHERE CASE

  WHEN mpm1.TStatusEffectiveStartDate IS NOT NULL

  AND mpm2.TStatusEffectiveStartDate IS NOT NULL THEN

  CASE

  WHEN mpm1.TStatus = '0' AND mpm2.TStatus = '0' THEN 1

  WHEN mpm1.TStatus = '0' AND mpm2.TStatus = '1' AND mpm1.TStatusEffectiveStartDate < mpm2.TStatusEffectiveStartDate THEN 1

  WHEN mpm1.TStatus = '1' AND mpm2.TStatus = '0' AND mpm1.TStatusEffectiveStartDate > mpm2.TStatusEffectiveStartDate THEN 1

  WHEN mpm1.FleetProgramStatus = '0' AND mpm2.FleetProgramStatus = '0' THEN 1

  ELSE 0

  END

  WHEN mpm1.TStatusEffectiveStartDate IS NULL AND mpm2.TStatusEffectiveStartDate IS NOT NULL AND mpm1.FleetProgramStatus = '0'

  AND ( mpm2.TStatus = '0' OR mpm2.FleetProgramStatus = '0' ) THEN 1

  WHEN mpm1.TStatusEffectiveStartDate IS NOT NULL AND mpm2.TStatusEffectiveStartDate IS NULL

  AND ( mpm1.TStatus = '0' OR mpm1.FleetProgramStatus = '0' )

  AND mpm2.FleetProgramStatus = '0' THEN 1

  WHEN mpm1.TStatusEffectiveStartDate IS NULL

  AND mpm2.TStatusEffectiveStartDate IS NULL

  AND mpm1.FleetProgramStatus = '0'

  AND mpm2.FleetProgramStatus = '0' THEN 1

  ELSE 0

  END = 1

  )x(y);

  I'm sure there are further tuning wins to be had here, but at least with the sample data this resolves the biggest problem from the plan.

  Cheers!

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 4:48 pm

  #1861292

  This was exactly the case! I can't believe I completely overlooked that...wow I feel like an idiot :hehe:

  The developers used UniqueID as the PK because in the table they were selected the data from it's the PK...but in the procedure being used, it clearly wasn't a good choice. MUCH APPRECIATED.

  The new execution brought the 1.14 billion reads down to just over 150K - wow.

  As for the use of INTEGER on those columns...completely agree with you and struggled with that battle (and lost) a few years ago. Problem is they store the data like '000114432' so if stored in a int column...bye-bye leading zeros (this is a 3rd party vendor DB that we host/support)

  Thanks Scott!

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• MyDoggieJessie

  SSC-Forever

  Points: 44486

  More actions

  February 25, 2016 at 4:52 pm

  #1861297

  @jacob, thanks as well! I will take a look at this approach as well - much appreciate everyone's help!

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience