How to break MS SQL

Toggle sidebar Toggle sidebar
Evadman

Evadman

Administrator Emeritus<br>Elite Member
Feb 18, 2001
30,990
5
81
Server: Msg 8630, Level 17, State 34, Line 1
Internal Query Processor Error: The query processor encountered an unexpected error during execution.
Click to expand...

Screw you MS. It isn't that difficult of a query. It only has 900 odd columns with a total length of 70,244 characters. That's easy to me, I can do it in my head!

Query (Edited to remove part of the column name)
select
CZ_ZipCode,
count(distinct(CASE WHEN CC_ItemNumber = '06302' THEN CC_Contractor END))as "06302",
count(distinct(CASE WHEN CC_ItemNumber = '06304' THEN CC_Contractor END))as "06304",
count(distinct(CASE WHEN CC_ItemNumber = '06306' THEN CC_Contractor END))as "06306",
count(distinct(CASE WHEN CC_ItemNumber = '06308' THEN CC_Contractor END))as "06308",
count(distinct(CASE WHEN CC_ItemNumber = '06311' THEN CC_Contractor END))as "06311",
count(distinct(CASE WHEN CC_ItemNumber = '06313' THEN CC_Contractor END))as "06313",
count(distinct(CASE WHEN CC_ItemNumber = '06315' THEN CC_Contractor END))as "06315",
count(distinct(CASE WHEN CC_ItemNumber = '06317' THEN CC_Contractor END))as "06317",
count(distinct(CASE WHEN CC_ItemNumber = '06341' THEN CC_Contractor END))as "06341",
count(distinct(CASE WHEN CC_ItemNumber = '06360' THEN CC_Contractor END))as "06360",
count(distinct(CASE WHEN CC_ItemNumber = '06361' THEN CC_Contractor END))as "06361",
count(distinct(CASE WHEN CC_ItemNumber = '06370' THEN CC_Contractor END))as "06370",
count(distinct(CASE WHEN CC_ItemNumber = '06371' THEN CC_Contractor END))as "06371",
count(distinct(CASE WHEN CC_ItemNumber = '06373' THEN CC_Contractor END))as "06373",
count(distinct(CASE WHEN CC_ItemNumber = '06380' THEN CC_Contractor END))as "06380",
count(distinct(CASE WHEN CC_ItemNumber = '06381' THEN CC_Contractor END))as "06381",
count(distinct(CASE WHEN CC_ItemNumber = '06383' THEN CC_Contractor END))as "06383",
count(distinct(CASE WHEN CC_ItemNumber = '06385' THEN CC_Contractor END))as "06385",
count(distinct(CASE WHEN CC_ItemNumber = '06386' THEN CC_Contractor END))as "06386",
count(distinct(CASE WHEN CC_ItemNumber = '06388' THEN CC_Contractor END))as "06388",
count(distinct(CASE WHEN CC_ItemNumber = '06389' THEN CC_Contractor END))as "06389",
count(distinct(CASE WHEN CC_ItemNumber = '06390' THEN CC_Contractor END))as "06390",
count(distinct(CASE WHEN CC_ItemNumber = '06392' THEN CC_Contractor END))as "06392",
count(distinct(CASE WHEN CC_ItemNumber = '06394' THEN CC_Contractor END))as "06394",
count(distinct(CASE WHEN CC_ItemNumber = '06398' THEN CC_Contractor END))as "06398",
count(distinct(CASE WHEN CC_ItemNumber = '06481' THEN CC_Contractor END))as "06481",
count(distinct(CASE WHEN CC_ItemNumber = '06482' THEN CC_Contractor END))as "06482",
count(distinct(CASE WHEN CC_ItemNumber = '06483' THEN CC_Contractor END))as "06483",
count(distinct(CASE WHEN CC_ItemNumber = '06484' THEN CC_Contractor END))as "06484",
count(distinct(CASE WHEN CC_ItemNumber = '06485' THEN CC_Contractor END))as "06485",
count(distinct(CASE WHEN CC_ItemNumber = '06491' THEN CC_Contractor END))as "06491",
count(distinct(CASE WHEN CC_ItemNumber = '06492' THEN CC_Contractor END))as "06492",
count(distinct(CASE WHEN CC_ItemNumber = '06493' THEN CC_Contractor END))as "06493",
count(distinct(CASE WHEN CC_ItemNumber = '06494' THEN CC_Contractor END))as "06494",
count(distinct(CASE WHEN CC_ItemNumber = '06495' THEN CC_Contractor END))as "06495",
count(distinct(CASE WHEN CC_ItemNumber = '06777' THEN CC_Contractor END))as "06777",
count(distinct(CASE WHEN CC_ItemNumber = '08100' THEN CC_Contractor END))as "08100",
count(distinct(CASE WHEN CC_ItemNumber = '08112' THEN CC_Contractor END))as "08112",
count(distinct(CASE WHEN CC_ItemNumber = '08114' THEN CC_Contractor END))as "08114",
count(distinct(CASE WHEN CC_ItemNumber = '09350' THEN CC_Contractor END))as "09350",
count(distinct(CASE WHEN CC_ItemNumber = '09352' THEN CC_Contractor END))as "09352",
count(distinct(CASE WHEN CC_ItemNumber = '09353' THEN CC_Contractor END))as "09353",
count(distinct(CASE WHEN CC_ItemNumber = '09360' THEN CC_Contractor END))as "09360",
count(distinct(CASE WHEN CC_ItemNumber = '09361' THEN CC_Contractor END))as "09361",
count(distinct(CASE WHEN CC_ItemNumber = '09362' THEN CC_Contractor END))as "09362",
count(distinct(CASE WHEN CC_ItemNumber = '09395' THEN CC_Contractor END))as "09395",
count(distinct(CASE WHEN CC_ItemNumber = '09398' THEN CC_Contractor END))as "09398",
count(distinct(CASE WHEN CC_ItemNumber = '09400' THEN CC_Contractor END))as "09400",
count(distinct(CASE WHEN CC_ItemNumber = '09411' THEN CC_Contractor END))as "09411",
count(distinct(CASE WHEN CC_ItemNumber = '09414' THEN CC_Contractor END))as "09414",
count(distinct(CASE WHEN CC_ItemNumber = '09416' THEN CC_Contractor END))as "09416",
count(distinct(CASE WHEN CC_ItemNumber = '09418' THEN CC_Contractor END))as "09418",
count(distinct(CASE WHEN CC_ItemNumber = '09420' THEN CC_Contractor END))as "09420",
count(distinct(CASE WHEN CC_ItemNumber = '09498' THEN CC_Contractor END))as "09498",
count(distinct(CASE WHEN CC_ItemNumber = '09499' THEN CC_Contractor END))as "09499",
count(distinct(CASE WHEN CC_ItemNumber = '09700' THEN CC_Contractor END))as "09700",
count(distinct(CASE WHEN CC_ItemNumber = '09710' THEN CC_Contractor END))as "09710",
count(distinct(CASE WHEN CC_ItemNumber = '09713' THEN CC_Contractor END))as "09713",
count(distinct(CASE WHEN CC_ItemNumber = '09714' THEN CC_Contractor END))as "09714",
count(distinct(CASE WHEN CC_ItemNumber = '09715' THEN CC_Contractor END))as "09715",
count(distinct(CASE WHEN CC_ItemNumber = '09720' THEN CC_Contractor END))as "09720",
count(distinct(CASE WHEN CC_ItemNumber = '09750' THEN CC_Contractor END))as "09750",
count(distinct(CASE WHEN CC_ItemNumber = '09777' THEN CC_Contractor END))as "09777",
count(distinct(CASE WHEN CC_ItemNumber = '22046' THEN CC_Contractor END))as "22046",
count(distinct(CASE WHEN CC_ItemNumber = '22050' THEN CC_Contractor END))as "22050",
count(distinct(CASE WHEN CC_ItemNumber = '22057' THEN CC_Contractor END))as "22057",
count(distinct(CASE WHEN CC_ItemNumber = '22058' THEN CC_Contractor END))as "22058",
count(distinct(CASE WHEN CC_ItemNumber = '22090' THEN CC_Contractor END))as "22090",
count(distinct(CASE WHEN CC_ItemNumber = '22094' THEN CC_Contractor END))as "22094",
count(distinct(CASE WHEN CC_ItemNumber = '22096' THEN CC_Contractor END))as "22096",
count(distinct(CASE WHEN CC_ItemNumber = '22097' THEN CC_Contractor END))as "22097",
count(distinct(CASE WHEN CC_ItemNumber = '22098' THEN CC_Contractor END))as "22098",
count(distinct(CASE WHEN CC_ItemNumber = '22099' THEN CC_Contractor END))as "22099",
count(distinct(CASE WHEN CC_ItemNumber = '22100' THEN CC_Contractor END))as "22100",
count(distinct(CASE WHEN CC_ItemNumber = '22105' THEN CC_Contractor END))as "22105",
count(distinct(CASE WHEN CC_ItemNumber = '22112' THEN CC_Contractor END))as "22112",
count(distinct(CASE WHEN CC_ItemNumber = '22113' THEN CC_Contractor END))as "22113",
count(distinct(CASE WHEN CC_ItemNumber = '22116' THEN CC_Contractor END))as "22116",
count(distinct(CASE WHEN CC_ItemNumber = '22198' THEN CC_Contractor END))as "22198",
count(distinct(CASE WHEN CC_ItemNumber = '22199' THEN CC_Contractor END))as "22199",
count(distinct(CASE WHEN CC_ItemNumber = '22288' THEN CC_Contractor END))as "22288",
count(distinct(CASE WHEN CC_ItemNumber = '22290' THEN CC_Contractor END))as "22290",
count(distinct(CASE WHEN CC_ItemNumber = '22298' THEN CC_Contractor END))as "22298",
count(distinct(CASE WHEN CC_ItemNumber = '22300' THEN CC_Contractor END))as "22300",
count(distinct(CASE WHEN CC_ItemNumber = '22301' THEN CC_Contractor END))as "22301",
count(distinct(CASE WHEN CC_ItemNumber = '22306' THEN CC_Contractor END))as "22306",
count(distinct(CASE WHEN CC_ItemNumber = '22307' THEN CC_Contractor END))as "22307",
count(distinct(CASE WHEN CC_ItemNumber = '22308' THEN CC_Contractor END))as "22308",
count(distinct(CASE WHEN CC_ItemNumber = '22312' THEN CC_Contractor END))as "22312",
count(distinct(CASE WHEN CC_ItemNumber = '22320' THEN CC_Contractor END))as "22320",
count(distinct(CASE WHEN CC_ItemNumber = '22321' THEN CC_Contractor END))as "22321",
count(distinct(CASE WHEN CC_ItemNumber = '22323' THEN CC_Contractor END))as "22323",
count(distinct(CASE WHEN CC_ItemNumber = '22324' THEN CC_Contractor END))as "22324",
count(distinct(CASE WHEN CC_ItemNumber = '22325' THEN CC_Contractor END))as "22325",
count(distinct(CASE WHEN CC_ItemNumber = '22326' THEN CC_Contractor END))as "22326",
count(distinct(CASE WHEN CC_ItemNumber = '22328' THEN CC_Contractor END))as "22328",
count(distinct(CASE WHEN CC_ItemNumber = '22329' THEN CC_Contractor END))as "22329",
count(distinct(CASE WHEN CC_ItemNumber = '22330' THEN CC_Contractor END))as "22330",
count(distinct(CASE WHEN CC_ItemNumber = '22332' THEN CC_Contractor END))as "22332",
count(distinct(CASE WHEN CC_ItemNumber = '22333' THEN CC_Contractor END))as "22333",
count(distinct(CASE WHEN CC_ItemNumber = '22334' THEN CC_Contractor END))as "22334",
count(distinct(CASE WHEN CC_ItemNumber = '22335' THEN CC_Contractor END))as "22335",
count(distinct(CASE WHEN CC_ItemNumber = '22336' THEN CC_Contractor END))as "22336",
count(distinct(CASE WHEN CC_ItemNumber = '22337' THEN CC_Contractor END))as "22337",
count(distinct(CASE WHEN CC_ItemNumber = '22338' THEN CC_Contractor END))as "22338",
count(distinct(CASE WHEN CC_ItemNumber = '22340' THEN CC_Contractor END))as "22340",
count(distinct(CASE WHEN CC_ItemNumber = '22341' THEN CC_Contractor END))as "22341",
count(distinct(CASE WHEN CC_ItemNumber = '22343' THEN CC_Contractor END))as "22343",
count(distinct(CASE WHEN CC_ItemNumber = '22344' THEN CC_Contractor END))as "22344",
count(distinct(CASE WHEN CC_ItemNumber = '22345' THEN CC_Contractor END))as "22345",
count(distinct(CASE WHEN CC_ItemNumber = '22347' THEN CC_Contractor END))as "22347",
count(distinct(CASE WHEN CC_ItemNumber = '22350' THEN CC_Contractor END))as "22350",
count(distinct(CASE WHEN CC_ItemNumber = '22352' THEN CC_Contractor END))as "22352",
count(distinct(CASE WHEN CC_ItemNumber = '22354' THEN CC_Contractor END))as "22354",
count(distinct(CASE WHEN CC_ItemNumber = '22356' THEN CC_Contractor END))as "22356",
count(distinct(CASE WHEN CC_ItemNumber = '22358' THEN CC_Contractor END))as "22358",
count(distinct(CASE WHEN CC_ItemNumber = '22362' THEN CC_Contractor END))as "22362",
count(distinct(CASE WHEN CC_ItemNumber = '22370' THEN CC_Contractor END))as "22370",
count(distinct(CASE WHEN CC_ItemNumber = '22372' THEN CC_Contractor END))as "22372",
count(distinct(CASE WHEN CC_ItemNumber = '22374' THEN CC_Contractor END))as "22374",
count(distinct(CASE WHEN CC_ItemNumber = '22376' THEN CC_Contractor END))as "22376",
count(distinct(CASE WHEN CC_ItemNumber = '22382' THEN CC_Contractor END))as "22382",
count(distinct(CASE WHEN CC_ItemNumber = '22398' THEN CC_Contractor END))as "22398",
count(distinct(CASE WHEN CC_ItemNumber = '22399' THEN CC_Contractor END))as "22399",
count(distinct(CASE WHEN CC_ItemNumber = '22400' THEN CC_Contractor END))as "22400",
count(distinct(CASE WHEN CC_ItemNumber = '22401' THEN CC_Contractor END))as "22401",
count(distinct(CASE WHEN CC_ItemNumber = '22402' THEN CC_Contractor END))as "22402",
count(distinct(CASE WHEN CC_ItemNumber = '22403' THEN CC_Contractor END))as "22403",
count(distinct(CASE WHEN CC_ItemNumber = '22404' THEN CC_Contractor END))as "22404",
count(distinct(CASE WHEN CC_ItemNumber = '22406' THEN CC_Contractor END))as "22406",
count(distinct(CASE WHEN CC_ItemNumber = '22407' THEN CC_Contractor END))as "22407",
count(distinct(CASE WHEN CC_ItemNumber = '22408' THEN CC_Contractor END))as "22408",
count(distinct(CASE WHEN CC_ItemNumber = '22409' THEN CC_Contractor END))as "22409",
count(distinct(CASE WHEN CC_ItemNumber = '22412' THEN CC_Contractor END))as "22412",
count(distinct(CASE WHEN CC_ItemNumber = '22413' THEN CC_Contractor END))as "22413",
count(distinct(CASE WHEN CC_ItemNumber = '22416' THEN CC_Contractor END))as "22416",
count(distinct(CASE WHEN CC_ItemNumber = '22418' THEN CC_Contractor END))as "22418",
count(distinct(CASE WHEN CC_ItemNumber = '22419' THEN CC_Contractor END))as "22419",
count(distinct(CASE WHEN CC_ItemNumber = '22428' THEN CC_Contractor END))as "22428",
count(distinct(CASE WHEN CC_ItemNumber = '22429' THEN CC_Contractor END))as "22429",
count(distinct(CASE WHEN CC_ItemNumber = '22430' THEN CC_Contractor END))as "22430",
count(distinct(CASE WHEN CC_ItemNumber = '22432' THEN CC_Contractor END))as "22432",
count(distinct(CASE WHEN CC_ItemNumber = '22438' THEN CC_Contractor END))as "22438",
count(distinct(CASE WHEN CC_ItemNumber = '22439' THEN CC_Contractor END))as "22439",
count(distinct(CASE WHEN CC_ItemNumber = '22440' THEN CC_Contractor END))as "22440",
count(distinct(CASE WHEN CC_ItemNumber = '22441' THEN CC_Contractor END))as "22441",
count(distinct(CASE WHEN CC_ItemNumber = '22442' THEN CC_Contractor END))as "22442",
count(distinct(CASE WHEN CC_ItemNumber = '22443' THEN CC_Contractor END))as "22443",
count(distinct(CASE WHEN CC_ItemNumber = '22444' THEN CC_Contractor END))as "22444",
count(distinct(CASE WHEN CC_ItemNumber = '22445' THEN CC_Contractor END))as "22445",
count(distinct(CASE WHEN CC_ItemNumber = '22446' THEN CC_Contractor END))as "22446",
count(distinct(CASE WHEN CC_ItemNumber = '22447' THEN CC_Contractor END))as "22447",
count(distinct(CASE WHEN CC_ItemNumber = '22448' THEN CC_Contractor END))as "22448",
count(distinct(CASE WHEN CC_ItemNumber = '22450' THEN CC_Contractor END))as "22450",
count(distinct(CASE WHEN CC_ItemNumber = '22452' THEN CC_Contractor END))as "22452",
count(distinct(CASE WHEN CC_ItemNumber = '22462' THEN CC_Contractor END))as "22462",
count(distinct(CASE WHEN CC_ItemNumber = '22468' THEN CC_Contractor END))as "22468",
count(distinct(CASE WHEN CC_ItemNumber = '22469' THEN CC_Contractor END))as "22469",
count(distinct(CASE WHEN CC_ItemNumber = '22470' THEN CC_Contractor END))as "22470",
count(distinct(CASE WHEN CC_ItemNumber = '22476' THEN CC_Contractor END))as "22476",
count(distinct(CASE WHEN CC_ItemNumber = '22478' THEN CC_Contractor END))as "22478",
count(distinct(CASE WHEN CC_ItemNumber = '22482' THEN CC_Contractor END))as "22482",
count(distinct(CASE WHEN CC_ItemNumber = '22484' THEN CC_Contractor END))as "22484",
count(distinct(CASE WHEN CC_ItemNumber = '22486' THEN CC_Contractor END))as "22486",
count(distinct(CASE WHEN CC_ItemNumber = '22488' THEN CC_Contractor END))as "22488",
count(distinct(CASE WHEN CC_ItemNumber = '22490' THEN CC_Contractor END))as "22490",
count(distinct(CASE WHEN CC_ItemNumber = '22491' THEN CC_Contractor END))as "22491",
count(distinct(CASE WHEN CC_ItemNumber = '22492' THEN CC_Contractor END))as "22492",
count(distinct(CASE WHEN CC_ItemNumber = '22493' THEN CC_Contractor END))as "22493",
count(distinct(CASE WHEN CC_ItemNumber = '22494' THEN CC_Contractor END))as "22494",
count(distinct(CASE WHEN CC_ItemNumber = '22496' THEN CC_Contractor END))as "22496",
count(distinct(CASE WHEN CC_ItemNumber = '22497' THEN CC_Contractor END))as "22497",
count(distinct(CASE WHEN CC_ItemNumber = '22498' THEN CC_Contractor END))as "22498",
count(distinct(CASE WHEN CC_ItemNumber = '22499' THEN CC_Contractor END))as "22499",
count(distinct(CASE WHEN CC_ItemNumber = '22500' THEN CC_Contractor END))as "22500",
count(distinct(CASE WHEN CC_ItemNumber = '22501' THEN CC_Contractor END))as "22501",
count(distinct(CASE WHEN CC_ItemNumber = '22515' THEN CC_Contractor END))as "22515",
count(distinct(CASE WHEN CC_ItemNumber = '22517' THEN CC_Contractor END))as "22517",
count(distinct(CASE WHEN CC_ItemNumber = '22518' THEN CC_Contractor END))as "22518",
count(distinct(CASE WHEN CC_ItemNumber = '22519' THEN CC_Contractor END))as "22519",
count(distinct(CASE WHEN CC_ItemNumber = '22520' THEN CC_Contractor END))as "22520",
count(distinct(CASE WHEN CC_ItemNumber = '22521' THEN CC_Contractor END))as "22521",
count(distinct(CASE WHEN CC_ItemNumber = '22522' THEN CC_Contractor END))as "22522",
count(distinct(CASE WHEN CC_ItemNumber = '22523' THEN CC_Contractor END))as "22523",
count(distinct(CASE WHEN CC_ItemNumber = '22524' THEN CC_Contractor END))as "22524",
count(distinct(CASE WHEN CC_ItemNumber = '22530' THEN CC_Contractor END))as "22530",
count(distinct(CASE WHEN CC_ItemNumber = '22532' THEN CC_Contractor END))as "22532",
count(distinct(CASE WHEN CC_ItemNumber = '22533' THEN CC_Contractor END))as "22533",
count(distinct(CASE WHEN CC_ItemNumber = '22541' THEN CC_Contractor END))as "22541",
count(distinct(CASE WHEN CC_ItemNumber = '22542' THEN CC_Contractor END))as "22542",
count(distinct(CASE WHEN CC_ItemNumber = '22543' THEN CC_Contractor END))as "22543",
count(distinct(CASE WHEN CC_ItemNumber = '22544' THEN CC_Contractor END))as "22544",
count(distinct(CASE WHEN CC_ItemNumber = '22545' THEN CC_Contractor END))as "22545",
count(distinct(CASE WHEN CC_ItemNumber = '22546' THEN CC_Contractor END))as "22546",
count(distinct(CASE WHEN CC_ItemNumber = '22547' THEN CC_Contractor END))as "22547",
count(distinct(CASE WHEN CC_ItemNumber = '22550' THEN CC_Contractor END))as "22550",
count(distinct(CASE WHEN CC_ItemNumber = '22551' THEN CC_Contractor END))as "22551",
count(distinct(CASE WHEN CC_ItemNumber = '22553' THEN CC_Contractor END))as "22553",
count(distinct(CASE WHEN CC_ItemNumber = '22554' THEN CC_Contractor END))as "22554",
count(distinct(CASE WHEN CC_ItemNumber = '22560' THEN CC_Contractor END))as "22560",
count(distinct(CASE WHEN CC_ItemNumber = '22561' THEN CC_Contractor END))as "22561",
count(distinct(CASE WHEN CC_ItemNumber = '22563' THEN CC_Contractor END))as "22563",
count(distinct(CASE WHEN CC_ItemNumber = '22564' THEN CC_Contractor END))as "22564",
count(distinct(CASE WHEN CC_ItemNumber = '22565' THEN CC_Contractor END))as "22565",
count(distinct(CASE WHEN CC_ItemNumber = '22566' THEN CC_Contractor END))as "22566",
count(distinct(CASE WHEN CC_ItemNumber = '22567' THEN CC_Contractor END))as "22567",
count(distinct(CASE WHEN CC_ItemNumber = '22568' THEN CC_Contractor END))as "22568",
count(distinct(CASE WHEN CC_ItemNumber = '22569' THEN CC_Contractor END))as "22569",
count(distinct(CASE WHEN CC_ItemNumber = '22601' THEN CC_Contractor END))as "22601",
count(distinct(CASE WHEN CC_ItemNumber = '22603' THEN CC_Contractor END))as "22603",
count(distinct(CASE WHEN CC_ItemNumber = '22604' THEN CC_Contractor END))as "22604",
count(distinct(CASE WHEN CC_ItemNumber = '22771' THEN CC_Contractor END))as "22771",
count(distinct(CASE WHEN CC_ItemNumber = '22772' THEN CC_Contractor END))as "22772",
count(distinct(CASE WHEN CC_ItemNumber = '22773' THEN CC_Contractor END))as "22773",
count(distinct(CASE WHEN CC_ItemNumber = '22774' THEN CC_Contractor END))as "22774",
count(distinct(CASE WHEN CC_ItemNumber = '22775' THEN CC_Contractor END))as "22775",
count(distinct(CASE WHEN CC_ItemNumber = '26200' THEN CC_Contractor END))as "26200",
count(distinct(CASE WHEN CC_ItemNumber = '26203' THEN CC_Contractor END))as "26203",
count(distinct(CASE WHEN CC_ItemNumber = '26205' THEN CC_Contractor END))as "26205",
count(distinct(CASE WHEN CC_ItemNumber = '26206' THEN CC_Contractor END))as "26206",
count(distinct(CASE WHEN CC_ItemNumber = '26208' THEN CC_Contractor END))as "26208",
count(distinct(CASE WHEN CC_ItemNumber = '26209' THEN CC_Contractor END))as "26209",
count(distinct(CASE WHEN CC_ItemNumber = '26214' THEN CC_Contractor END))as "26214",
count(distinct(CASE WHEN CC_ItemNumber = '26220' THEN CC_Contractor END))as "26220",
count(distinct(CASE WHEN CC_ItemNumber = '26225' THEN CC_Contractor END))as "26225",
count(distinct(CASE WHEN CC_ItemNumber = '26228' THEN CC_Contractor END))as "26228",
count(distinct(CASE WHEN CC_ItemNumber = '26230' THEN CC_Contractor END))as "26230",
count(distinct(CASE WHEN CC_ItemNumber = '26231' THEN CC_Contractor END))as "26231",
count(distinct(CASE WHEN CC_ItemNumber = '26232' THEN CC_Contractor END))as "26232",
count(distinct(CASE WHEN CC_ItemNumber = '26234' THEN CC_Contractor END))as "26234",
count(distinct(CASE WHEN CC_ItemNumber = '26235' THEN CC_Contractor END))as "26235",
count(distinct(CASE WHEN CC_ItemNumber = '26236' THEN CC_Contractor END))as "26236",
count(distinct(CASE WHEN CC_ItemNumber = '26238' THEN CC_Contractor END))as "26238",
count(distinct(CASE WHEN CC_ItemNumber = '26239' THEN CC_Contractor END))as "26239",
count(distinct(CASE WHEN CC_ItemNumber = '26240' THEN CC_Contractor END))as "26240",
count(distinct(CASE WHEN CC_ItemNumber = '26242' THEN CC_Contractor END))as "26242",
count(distinct(CASE WHEN CC_ItemNumber = '26246' THEN CC_Contractor END))as "26246",
count(distinct(CASE WHEN CC_ItemNumber = '26250' THEN CC_Contractor END))as "26250",
count(distinct(CASE WHEN CC_ItemNumber = '26296' THEN CC_Contractor END))as "26296",
count(distinct(CASE WHEN CC_ItemNumber = '26297' THEN CC_Contractor END))as "26297",
count(distinct(CASE WHEN CC_ItemNumber = '26298' THEN CC_Contractor END))as "26298",
count(distinct(CASE WHEN CC_ItemNumber = '26299' THEN CC_Contractor END))as "26299",
count(distinct(CASE WHEN CC_ItemNumber = '26771' THEN CC_Contractor END))as "26771",
count(distinct(CASE WHEN CC_ItemNumber = '26772' THEN CC_Contractor END))as "26772",
count(distinct(CASE WHEN CC_ItemNumber = '34497' THEN CC_Contractor END))as "34497",
count(distinct(CASE WHEN CC_ItemNumber = '34498' THEN CC_Contractor END))as "34498",
count(distinct(CASE WHEN CC_ItemNumber = '34500' THEN CC_Contractor END))as "34500",
count(distinct(CASE WHEN CC_ItemNumber = '34502' THEN CC_Contractor END))as "34502",
count(distinct(CASE WHEN CC_ItemNumber = '34670' THEN CC_Contractor END))as "34670",
count(distinct(CASE WHEN CC_ItemNumber = '34675' THEN CC_Contractor END))as "34675",
count(distinct(CASE WHEN CC_ItemNumber = '34777' THEN CC_Contractor END))as "34777",
count(distinct(CASE WHEN CC_ItemNumber = '42000' THEN CC_Contractor END))as "42000",
count(distinct(CASE WHEN CC_ItemNumber = '42097' THEN CC_Contractor END))as "42097",
count(distinct(CASE WHEN CC_ItemNumber = '42098' THEN CC_Contractor END))as "42098",
count(distinct(CASE WHEN CC_ItemNumber = '42316' THEN CC_Contractor END))as "42316",
count(distinct(CASE WHEN CC_ItemNumber = '42317' THEN CC_Contractor END))as "42317",
count(distinct(CASE WHEN CC_ItemNumber = '42319' THEN CC_Contractor END))as "42319",
count(distinct(CASE WHEN CC_ItemNumber = '42320' THEN CC_Contractor END))as "42320",
count(distinct(CASE WHEN CC_ItemNumber = '42321' THEN CC_Contractor END))as "42321",
count(distinct(CASE WHEN CC_ItemNumber = '42323' THEN CC_Contractor END))as "42323",
count(distinct(CASE WHEN CC_ItemNumber = '42324' THEN CC_Contractor END))as "42324",
count(distinct(CASE WHEN CC_ItemNumber = '42325' THEN CC_Contractor END))as "42325",
count(distinct(CASE WHEN CC_ItemNumber = '42327' THEN CC_Contractor END))as "42327",
count(distinct(CASE WHEN CC_ItemNumber = '42333' THEN CC_Contractor END))as "42333",
count(distinct(CASE WHEN CC_ItemNumber = '42339' THEN CC_Contractor END))as "42339",
count(distinct(CASE WHEN CC_ItemNumber = '42351' THEN CC_Contractor END))as "42351",
count(distinct(CASE WHEN CC_ItemNumber = '42417' THEN CC_Contractor END))as "42417",
count(distinct(CASE WHEN CC_ItemNumber = '42466' THEN CC_Contractor END))as "42466",
count(distinct(CASE WHEN CC_ItemNumber = '42468' THEN CC_Contractor END))as "42468",
count(distinct(CASE WHEN CC_ItemNumber = '42483' THEN CC_Contractor END))as "42483",
count(distinct(CASE WHEN CC_ItemNumber = '42491' THEN CC_Contractor END))as "42491",
count(distinct(CASE WHEN CC_ItemNumber = '42497' THEN CC_Contractor END))as "42497",
count(distinct(CASE WHEN CC_ItemNumber = '42500' THEN CC_Contractor END))as "42500",
count(distinct(CASE WHEN CC_ItemNumber = '42507' THEN CC_Contractor END))as "42507",
count(distinct(CASE WHEN CC_ItemNumber = '42512' THEN CC_Contractor END))as "42512",
count(distinct(CASE WHEN CC_ItemNumber = '42514' THEN CC_Contractor END))as "42514",
count(distinct(CASE WHEN CC_ItemNumber = '42515' THEN CC_Contractor END))as "42515",
count(distinct(CASE WHEN CC_ItemNumber = '42521' THEN CC_Contractor END))as "42521",
count(distinct(CASE WHEN CC_ItemNumber = '42522' THEN CC_Contractor END))as "42522",
count(distinct(CASE WHEN CC_ItemNumber = '42523' THEN CC_Contractor END))as "42523",
count(distinct(CASE WHEN CC_ItemNumber = '42598' THEN CC_Contractor END))as "42598",
count(distinct(CASE WHEN CC_ItemNumber = '42599' THEN CC_Contractor END))as "42599",
count(distinct(CASE WHEN CC_ItemNumber = '42600' THEN CC_Contractor END))as "42600",
count(distinct(CASE WHEN CC_ItemNumber = '42605' THEN CC_Contractor END))as "42605",
count(distinct(CASE WHEN CC_ItemNumber = '42606' THEN CC_Contractor END))as "42606",
count(distinct(CASE WHEN CC_ItemNumber = '42607' THEN CC_Contractor END))as "42607",
count(distinct(CASE WHEN CC_ItemNumber = '42610' THEN CC_Contractor END))as "42610",
count(distinct(CASE WHEN CC_ItemNumber = '42611' THEN CC_Contractor END))as "42611",
count(distinct(CASE WHEN CC_ItemNumber = '42613' THEN CC_Contractor END))as "42613",
count(distinct(CASE WHEN CC_ItemNumber = '42614' THEN CC_Contractor END))as "42614",
count(distinct(CASE WHEN CC_ItemNumber = '42616' THEN CC_Contractor END))as "42616",
count(distinct(CASE WHEN CC_ItemNumber = '42617' THEN CC_Contractor END))as "42617",
count(distinct(CASE WHEN CC_ItemNumber = '42775' THEN CC_Contractor END))as "42775",
count(distinct(CASE WHEN CC_ItemNumber = '42776' THEN CC_Contractor END))as "42776",
count(distinct(CASE WHEN CC_ItemNumber = '42777' THEN CC_Contractor END))as "42777",
count(distinct(CASE WHEN CC_ItemNumber = '42783' THEN CC_Contractor END))as "42783",
count(distinct(CASE WHEN CC_ItemNumber = '42785' THEN CC_Contractor END))as "42785",
count(distinct(CASE WHEN CC_ItemNumber = '42830' THEN CC_Contractor END))as "42830",
count(distinct(CASE WHEN CC_ItemNumber = '42831' THEN CC_Contractor END))as "42831",
count(distinct(CASE WHEN CC_ItemNumber = '42832' THEN CC_Contractor END))as "42832",
count(distinct(CASE WHEN CC_ItemNumber = '42833' THEN CC_Contractor END))as "42833",
count(distinct(CASE WHEN CC_ItemNumber = '42847' THEN CC_Contractor END))as "42847",
count(distinct(CASE WHEN CC_ItemNumber = '42848' THEN CC_Contractor END))as "42848",
count(distinct(CASE WHEN CC_ItemNumber = '42849' THEN CC_Contractor END))as "42849",
count(distinct(CASE WHEN CC_ItemNumber = '42850' THEN CC_Contractor END))as "42850",
count(distinct(CASE WHEN CC_ItemNumber = '42851' THEN CC_Contractor END))as "42851",
count(distinct(CASE WHEN CC_ItemNumber = '42852' THEN CC_Contractor END))as "42852",
count(distinct(CASE WHEN CC_ItemNumber = '42853' THEN CC_Contractor END))as "42853",
count(distinct(CASE WHEN CC_ItemNumber = '42854' THEN CC_Contractor END))as "42854",
count(distinct(CASE WHEN CC_ItemNumber = '42855' THEN CC_Contractor END))as "42855",
count(distinct(CASE WHEN CC_ItemNumber = '42860' THEN CC_Contractor END))as "42860",
count(distinct(CASE WHEN CC_ItemNumber = '42861' THEN CC_Contractor END))as "42861",
count(distinct(CASE WHEN CC_ItemNumber = '42862' THEN CC_Contractor END))as "42862",
count(distinct(CASE WHEN CC_ItemNumber = '42876' THEN CC_Contractor END))as "42876",
count(distinct(CASE WHEN CC_ItemNumber = '42877' THEN CC_Contractor END))as "42877",
count(distinct(CASE WHEN CC_ItemNumber = '42884' THEN CC_Contractor END))as "42884",
count(distinct(CASE WHEN CC_ItemNumber = '42886' THEN CC_Contractor END))as "42886",
count(distinct(CASE WHEN CC_ItemNumber = '42887' THEN CC_Contractor END))as "42887",
count(distinct(CASE WHEN CC_ItemNumber = '42893' THEN CC_Contractor END))as "42893",
count(distinct(CASE WHEN CC_ItemNumber = '42894' THEN CC_Contractor END))as "42894",
count(distinct(CASE WHEN CC_ItemNumber = '42897' THEN CC_Contractor END))as "42897",
count(distinct(CASE WHEN CC_ItemNumber = '42898' THEN CC_Contractor END))as "42898",
count(distinct(CASE WHEN CC_ItemNumber = '42899' THEN CC_Contractor END))as "42899",
count(distinct(CASE WHEN CC_ItemNumber = '42961' THEN CC_Contractor END))as "42961",
count(distinct(CASE WHEN CC_ItemNumber = '42962' THEN CC_Contractor END))as "42962",
count(distinct(CASE WHEN CC_ItemNumber = '42964' THEN CC_Contractor END))as "42964",
count(distinct(CASE WHEN CC_ItemNumber = '42966' THEN CC_Contractor END))as "42966",
count(distinct(CASE WHEN CC_ItemNumber = '42968' THEN CC_Contractor END))as "42968",
count(distinct(CASE WHEN CC_ItemNumber = '42970' THEN CC_Contractor END))as "42970",
count(distinct(CASE WHEN CC_ItemNumber = '42971' THEN CC_Contractor END))as "42971",
count(distinct(CASE WHEN CC_ItemNumber = '42972' THEN CC_Contractor END))as "42972",
count(distinct(CASE WHEN CC_ItemNumber = '42973' THEN CC_Contractor END))as "42973",
count(distinct(CASE WHEN CC_ItemNumber = '42974' THEN CC_Contractor END))as "42974",
count(distinct(CASE WHEN CC_ItemNumber = '42975' THEN CC_Contractor END))as "42975",
count(distinct(CASE WHEN CC_ItemNumber = '42976' THEN CC_Contractor END))as "42976",
count(distinct(CASE WHEN CC_ItemNumber = '42977' THEN CC_Contractor END))as "42977",
count(distinct(CASE WHEN CC_ItemNumber = '42978' THEN CC_Contractor END))as "42978",
count(distinct(CASE WHEN CC_ItemNumber = '42979' THEN CC_Contractor END))as "42979",
count(distinct(CASE WHEN CC_ItemNumber = '46196' THEN CC_Contractor END))as "46196",
count(distinct(CASE WHEN CC_ItemNumber = '46200' THEN CC_Contractor END))as "46200",
count(distinct(CASE WHEN CC_ItemNumber = '46205' THEN CC_Contractor END))as "46205",
count(distinct(CASE WHEN CC_ItemNumber = '46213' THEN CC_Contractor END))as "46213",
count(distinct(CASE WHEN CC_ItemNumber = '46214' THEN CC_Contractor END))as "46214",
count(distinct(CASE WHEN CC_ItemNumber = '46215' THEN CC_Contractor END))as "46215",
count(distinct(CASE WHEN CC_ItemNumber = '46216' THEN CC_Contractor END))as "46216",
count(distinct(CASE WHEN CC_ItemNumber = '46217' THEN CC_Contractor END))as "46217",
count(distinct(CASE WHEN CC_ItemNumber = '46218' THEN CC_Contractor END))as "46218",
count(distinct(CASE WHEN CC_ItemNumber = '46243' THEN CC_Contractor END))as "46243",
count(distinct(CASE WHEN CC_ItemNumber = '46245' THEN CC_Contractor END))as "46245",
count(distinct(CASE WHEN CC_ItemNumber = '46247' THEN CC_Contractor END))as "46247",
count(distinct(CASE WHEN CC_ItemNumber = '46249' THEN CC_Contractor END))as "46249",
count(distinct(CASE WHEN CC_ItemNumber = '46253' THEN CC_Contractor END))as "46253",
count(distinct(CASE WHEN CC_ItemNumber = '46255' THEN CC_Contractor END))as "46255",
count(distinct(CASE WHEN CC_ItemNumber = '46256' THEN CC_Contractor END))as "46256",
count(distinct(CASE WHEN CC_ItemNumber = '46280' THEN CC_Contractor END))as "46280",
count(distinct(CASE WHEN CC_ItemNumber = '46281' THEN CC_Contractor END))as "46281",
count(distinct(CASE WHEN CC_ItemNumber = '46282' THEN CC_Contractor END))as "46282",
count(distinct(CASE WHEN CC_ItemNumber = '46298' THEN CC_Contractor END))as "46298",
count(distinct(CASE WHEN CC_ItemNumber = '46299' THEN CC_Contractor END))as "46299",
count(distinct(CASE WHEN CC_ItemNumber = '46777' THEN CC_Contractor END))as "46777",
count(distinct(CASE WHEN CC_ItemNumber = '57210' THEN CC_Contractor END))as "57210",
count(distinct(CASE WHEN CC_ItemNumber = '57211' THEN CC_Contractor END))as "57211",
count(distinct(CASE WHEN CC_ItemNumber = '57212' THEN CC_Contractor END))as "57212",
count(distinct(CASE WHEN CC_ItemNumber = '57213' THEN CC_Contractor END))as "57213",
count(distinct(CASE WHEN CC_ItemNumber = '57214' THEN CC_Contractor END))as "57214",
count(distinct(CASE WHEN CC_ItemNumber = '57215' THEN CC_Contractor END))as "57215",
count(distinct(CASE WHEN CC_ItemNumber = '57216' THEN CC_Contractor END))as "57216",
count(distinct(CASE WHEN CC_ItemNumber = '57217' THEN CC_Contractor END))as "57217",
count(distinct(CASE WHEN CC_ItemNumber = '57218' THEN CC_Contractor END))as "57218",
count(distinct(CASE WHEN CC_ItemNumber = '57219' THEN CC_Contractor END))as "57219",
count(distinct(CASE WHEN CC_ItemNumber = '57220' THEN CC_Contractor END))as "57220",
count(distinct(CASE WHEN CC_ItemNumber = '57221' THEN CC_Contractor END))as "57221",
count(distinct(CASE WHEN CC_ItemNumber = '57222' THEN CC_Contractor END))as "57222",
count(distinct(CASE WHEN CC_ItemNumber = '57223' THEN CC_Contractor END))as "57223",
count(distinct(CASE WHEN CC_ItemNumber = '57224' THEN CC_Contractor END))as "57224",
count(distinct(CASE WHEN CC_ItemNumber = '57225' THEN CC_Contractor END))as "57225",
count(distinct(CASE WHEN CC_ItemNumber = '57226' THEN CC_Contractor END))as "57226",
count(distinct(CASE WHEN CC_ItemNumber = '57227' THEN CC_Contractor END))as "57227",
count(distinct(CASE WHEN CC_ItemNumber = '57230' THEN CC_Contractor END))as "57230",
count(distinct(CASE WHEN CC_ItemNumber = '57231' THEN CC_Contractor END))as "57231",
count(distinct(CASE WHEN CC_ItemNumber = '57232' THEN CC_Contractor END))as "57232",
count(distinct(CASE WHEN CC_ItemNumber = '57269' THEN CC_Contractor END))as "57269",
count(distinct(CASE WHEN CC_ItemNumber = '57271' THEN CC_Contractor END))as "57271",
count(distinct(CASE WHEN CC_ItemNumber = '57288' THEN CC_Contractor END))as "57288",
count(distinct(CASE WHEN CC_ItemNumber = '57289' THEN CC_Contractor END))as "57289",
count(distinct(CASE WHEN CC_ItemNumber = '57290' THEN CC_Contractor END))as "57290",
count(distinct(CASE WHEN CC_ItemNumber = '57291' THEN CC_Contractor END))as "57291",
count(distinct(CASE WHEN CC_ItemNumber = '57292' THEN CC_Contractor END))as "57292",
count(distinct(CASE WHEN CC_ItemNumber = '57293' THEN CC_Contractor END))as "57293",
count(distinct(CASE WHEN CC_ItemNumber = '57294' THEN CC_Contractor END))as "57294",
count(distinct(CASE WHEN CC_ItemNumber = '57306' THEN CC_Contractor END))as "57306",
count(distinct(CASE WHEN CC_ItemNumber = '57308' THEN CC_Contractor END))as "57308",
count(distinct(CASE WHEN CC_ItemNumber = '57309' THEN CC_Contractor END))as "57309",
count(distinct(CASE WHEN CC_ItemNumber = '57317' THEN CC_Contractor END))as "57317",
count(distinct(CASE WHEN CC_ItemNumber = '57325' THEN CC_Contractor END))as "57325",
count(distinct(CASE WHEN CC_ItemNumber = '57327' THEN CC_Contractor END))as "57327",
count(distinct(CASE WHEN CC_ItemNumber = '57328' THEN CC_Contractor END))as "57328",
count(distinct(CASE WHEN CC_ItemNumber = '57330' THEN CC_Contractor END))as "57330",
count(distinct(CASE WHEN CC_ItemNumber = '57331' THEN CC_Contractor END))as "57331",
count(distinct(CASE WHEN CC_ItemNumber = '57332' THEN CC_Contractor END))as "57332",
count(distinct(CASE WHEN CC_ItemNumber = '57333' THEN CC_Contractor END))as "57333",
count(distinct(CASE WHEN CC_ItemNumber = '57334' THEN CC_Contractor END))as "57334",
count(distinct(CASE WHEN CC_ItemNumber = '57372' THEN CC_Contractor END))as "57372",
count(distinct(CASE WHEN CC_ItemNumber = '57373' THEN CC_Contractor END))as "57373",
count(distinct(CASE WHEN CC_ItemNumber = '57374' THEN CC_Contractor END))as "57374",
count(distinct(CASE WHEN CC_ItemNumber = '57375' THEN CC_Contractor END))as "57375",
count(distinct(CASE WHEN CC_ItemNumber = '57376' THEN CC_Contractor END))as "57376",
count(distinct(CASE WHEN CC_ItemNumber = '57377' THEN CC_Contractor END))as "57377",
count(distinct(CASE WHEN CC_ItemNumber = '57378' THEN CC_Contractor END))as "57378",
count(distinct(CASE WHEN CC_ItemNumber = '57379' THEN CC_Contractor END))as "57379",
count(distinct(CASE WHEN CC_ItemNumber = '57380' THEN CC_Contractor END))as "57380",
count(distinct(CASE WHEN CC_ItemNumber = '57381' THEN CC_Contractor END))as "57381",
count(distinct(CASE WHEN CC_ItemNumber = '57382' THEN CC_Contractor END))as "57382",
count(distinct(CASE WHEN CC_ItemNumber = '57383' THEN CC_Contractor END))as "57383",
count(distinct(CASE WHEN CC_ItemNumber = '57386' THEN CC_Contractor END))as "57386",
count(distinct(CASE WHEN CC_ItemNumber = '57388' THEN CC_Contractor END))as "57388",
count(distinct(CASE WHEN CC_ItemNumber = '57389' THEN CC_Contractor END))as "57389",
count(distinct(CASE WHEN CC_ItemNumber = '67006' THEN CC_Contractor END))as "67006",
count(distinct(CASE WHEN CC_ItemNumber = '67008' THEN CC_Contractor END))as "67008",
count(distinct(CASE WHEN CC_ItemNumber = '67009' THEN CC_Contractor END))as "67009",
count(distinct(CASE WHEN CC_ItemNumber = '67022' THEN CC_Contractor END))as "67022",
count(distinct(CASE WHEN CC_ItemNumber = '67026' THEN CC_Contractor END))as "67026",
count(distinct(CASE WHEN CC_ItemNumber = '67034' THEN CC_Contractor END))as "67034",
count(distinct(CASE WHEN CC_ItemNumber = '67042' THEN CC_Contractor END))as "67042",
count(distinct(CASE WHEN CC_ItemNumber = '67046' THEN CC_Contractor END))as "67046",
count(distinct(CASE WHEN CC_ItemNumber = '67057' THEN CC_Contractor END))as "67057",
count(distinct(CASE WHEN CC_ItemNumber = '67071' THEN CC_Contractor END))as "67071",
count(distinct(CASE WHEN CC_ItemNumber = '67083' THEN CC_Contractor END))as "67083",
count(distinct(CASE WHEN CC_ItemNumber = '71220' THEN CC_Contractor END))as "71220",
count(distinct(CASE WHEN CC_ItemNumber = '71221' THEN CC_Contractor END))as "71221",
count(distinct(CASE WHEN CC_ItemNumber = '71222' THEN CC_Contractor END))as "71222",
count(distinct(CASE WHEN CC_ItemNumber = '71224' THEN CC_Contractor END))as "71224",
count(distinct(CASE WHEN CC_ItemNumber = '71225' THEN CC_Contractor END))as "71225",
Count(distinct(CASE WHEN CC_ItemNumber = '71226' THEN CC_Contractor END))as "71226",
count(distinct(CASE WHEN CC_ItemNumber = '71228' THEN CC_Contractor END))as "71228",
count(distinct(CASE WHEN CC_ItemNumber = '71250' THEN CC_Contractor END))as "71250",
count(distinct(CASE WHEN CC_ItemNumber = '71255' THEN CC_Contractor END))as "71255",
count(distinct(CASE WHEN CC_ItemNumber = '71257' THEN CC_Contractor END))as "71257",
count(distinct(CASE WHEN CC_ItemNumber = '71259' THEN CC_Contractor END))as "71259",
count(distinct(CASE WHEN CC_ItemNumber = '71270' THEN CC_Contractor END))as "71270",
count(distinct(CASE WHEN CC_ItemNumber = '71271' THEN CC_Contractor END))as "71271",
count(distinct(CASE WHEN CC_ItemNumber = '71272' THEN CC_Contractor END))as "71272",
count(distinct(CASE WHEN CC_ItemNumber = '71273' THEN CC_Contractor END))as "71273",
count(distinct(CASE WHEN CC_ItemNumber = '71274' THEN CC_Contractor END))as "71274",
count(distinct(CASE WHEN CC_ItemNumber = '71275' THEN CC_Contractor END))as "71275",
count(distinct(CASE WHEN CC_ItemNumber = '71320' THEN CC_Contractor END))as "71320",
count(distinct(CASE WHEN CC_ItemNumber = '71326' THEN CC_Contractor END))as "71326",
count(distinct(CASE WHEN CC_ItemNumber = '71328' THEN CC_Contractor END))as "71328",
count(distinct(CASE WHEN CC_ItemNumber = '71329' THEN CC_Contractor END))as "71329",
count(distinct(CASE WHEN CC_ItemNumber = '71500' THEN CC_Contractor END))as "71500",
count(distinct(CASE WHEN CC_ItemNumber = '71501' THEN CC_Contractor END))as "71501",
count(distinct(CASE WHEN CC_ItemNumber = '71502' THEN CC_Contractor END))as "71502",
count(distinct(CASE WHEN CC_ItemNumber = '71512' THEN CC_Contractor END))as "71512",
count(distinct(CASE WHEN CC_ItemNumber = '71513' THEN CC_Contractor END))as "71513",
count(distinct(CASE WHEN CC_ItemNumber = '71517' THEN CC_Contractor END))as "71517",
count(distinct(CASE WHEN CC_ItemNumber = '71520' THEN CC_Contractor END))as "71520",
count(distinct(CASE WHEN CC_ItemNumber = '71521' THEN CC_Contractor END))as "71521",
count(distinct(CASE WHEN CC_ItemNumber = '71598' THEN CC_Contractor END))as "71598",
count(distinct(CASE WHEN CC_ItemNumber = '71600' THEN CC_Contractor END))as "71600",
count(distinct(CASE WHEN CC_ItemNumber = '71601' THEN CC_Contractor END))as "71601",
count(distinct(CASE WHEN CC_ItemNumber = '71602' THEN CC_Contractor END))as "71602",
count(distinct(CASE WHEN CC_ItemNumber = '71604' THEN CC_Contractor END))as "71604",
count(distinct(CASE WHEN CC_ItemNumber = '71606' THEN CC_Contractor END))as "71606",
count(distinct(CASE WHEN CC_ItemNumber = '71608' THEN CC_Contractor END))as "71608",
count(distinct(CASE WHEN CC_ItemNumber = '71610' THEN CC_Contractor END))as "71610",
count(distinct(CASE WHEN CC_ItemNumber = '71612' THEN CC_Contractor END))as "71612",
count(distinct(CASE WHEN CC_ItemNumber = '71613' THEN CC_Contractor END))as "71613",
count(distinct(CASE WHEN CC_ItemNumber = '71614' THEN CC_Contractor END))as "71614",
count(distinct(CASE WHEN CC_ItemNumber = '71615' THEN CC_Contractor END))as "71615",
count(distinct(CASE WHEN CC_ItemNumber = '71616' THEN CC_Contractor END))as "71616",
count(distinct(CASE WHEN CC_ItemNumber = '71620' THEN CC_Contractor END))as "71620",
count(distinct(CASE WHEN CC_ItemNumber = '71622' THEN CC_Contractor END))as "71622",
count(distinct(CASE WHEN CC_ItemNumber = '71624' THEN CC_Contractor END))as "71624",
count(distinct(CASE WHEN CC_ItemNumber = '71626' THEN CC_Contractor END))as "71626",
count(distinct(CASE WHEN CC_ItemNumber = '71628' THEN CC_Contractor END))as "71628",
count(distinct(CASE WHEN CC_ItemNumber = '71630' THEN CC_Contractor END))as "71630",
count(distinct(CASE WHEN CC_ItemNumber = '71631' THEN CC_Contractor END))as "71631",
count(distinct(CASE WHEN CC_ItemNumber = '71632' THEN CC_Contractor END))as "71632",
count(distinct(CASE WHEN CC_ItemNumber = '71633' THEN CC_Contractor END))as "71633",
count(distinct(CASE WHEN CC_ItemNumber = '71634' THEN CC_Contractor END))as "71634",
count(distinct(CASE WHEN CC_ItemNumber = '71640' THEN CC_Contractor END))as "71640",
count(distinct(CASE WHEN CC_ItemNumber = '71641' THEN CC_Contractor END))as "71641",
count(distinct(CASE WHEN CC_ItemNumber = '71642' THEN CC_Contractor END))as "71642",
count(distinct(CASE WHEN CC_ItemNumber = '71777' THEN CC_Contractor END))as "71777",
count(distinct(CASE WHEN CC_ItemNumber = '71778' THEN CC_Contractor END))as "71778",
count(distinct(CASE WHEN CC_ItemNumber = '83100' THEN CC_Contractor END))as "83100",
count(distinct(CASE WHEN CC_ItemNumber = '83102' THEN CC_Contractor END))as "83102",
count(distinct(CASE WHEN CC_ItemNumber = '83104' THEN CC_Contractor END))as "83104",
count(distinct(CASE WHEN CC_ItemNumber = '83106' THEN CC_Contractor END))as "83106",
count(distinct(CASE WHEN CC_ItemNumber = '83108' THEN CC_Contractor END))as "83108",
count(distinct(CASE WHEN CC_ItemNumber = '83110' THEN CC_Contractor END))as "83110",
count(distinct(CASE WHEN CC_ItemNumber = '83112' THEN CC_Contractor END))as "83112",
count(distinct(CASE WHEN CC_ItemNumber = '83113' THEN CC_Contractor END))as "83113",
count(distinct(CASE WHEN CC_ItemNumber = '83114' THEN CC_Contractor END))as "83114",
count(distinct(CASE WHEN CC_ItemNumber = '83116' THEN CC_Contractor END))as "83116",
count(distinct(CASE WHEN CC_ItemNumber = '83118' THEN CC_Contractor END))as "83118",
count(distinct(CASE WHEN CC_ItemNumber = '83120' THEN CC_Contractor END))as "83120",
count(distinct(CASE WHEN CC_ItemNumber = '83122' THEN CC_Contractor END))as "83122",
count(distinct(CASE WHEN CC_ItemNumber = '83124' THEN CC_Contractor END))as "83124",
count(distinct(CASE WHEN CC_ItemNumber = '83126' THEN CC_Contractor END))as "83126",
count(distinct(CASE WHEN CC_ItemNumber = '83128' THEN CC_Contractor END))as "83128",
count(distinct(CASE WHEN CC_ItemNumber = '83130' THEN CC_Contractor END))as "83130",
count(distinct(CASE WHEN CC_ItemNumber = '83132' THEN CC_Contractor END))as "83132",
count(distinct(CASE WHEN CC_ItemNumber = '83134' THEN CC_Contractor END))as "83134",
count(distinct(CASE WHEN CC_ItemNumber = '83135' THEN CC_Contractor END))as "83135",
count(distinct(CASE WHEN CC_ItemNumber = '83136' THEN CC_Contractor END))as "83136",
count(distinct(CASE WHEN CC_ItemNumber = '83137' THEN CC_Contractor END))as "83137",
count(distinct(CASE WHEN CC_ItemNumber = '83138' THEN CC_Contractor END))as "83138",
count(distinct(CASE WHEN CC_ItemNumber = '83139' THEN CC_Contractor END))as "83139",
count(distinct(CASE WHEN CC_ItemNumber = '83140' THEN CC_Contractor END))as "83140",
count(distinct(CASE WHEN CC_ItemNumber = '83141' THEN CC_Contractor END))as "83141",
count(distinct(CASE WHEN CC_ItemNumber = '83142' THEN CC_Contractor END))as "83142",
count(distinct(CASE WHEN CC_ItemNumber = '83143' THEN CC_Contractor END))as "83143",
count(distinct(CASE WHEN CC_ItemNumber = '83144' THEN CC_Contractor END))as "83144",
count(distinct(CASE WHEN CC_ItemNumber = '83777' THEN CC_Contractor END))as "83777",
count(distinct(CASE WHEN CC_ItemNumber = '83898' THEN CC_Contractor END))as "83898",
count(distinct(CASE WHEN CC_ItemNumber = '83899' THEN CC_Contractor END))as "83899",
count(distinct(CASE WHEN CC_ItemNumber = '84014' THEN CC_Contractor END))as "84014",
count(distinct(CASE WHEN CC_ItemNumber = '84015' THEN CC_Contractor END))as "84015",
count(distinct(CASE WHEN CC_ItemNumber = '84017' THEN CC_Contractor END))as "84017",
count(distinct(CASE WHEN CC_ItemNumber = '84050' THEN CC_Contractor END))as "84050",
count(distinct(CASE WHEN CC_ItemNumber = '84051' THEN CC_Contractor END))as "84051",
count(distinct(CASE WHEN CC_ItemNumber = '84052' THEN CC_Contractor END))as "84052",
count(distinct(CASE WHEN CC_ItemNumber = '84053' THEN CC_Contractor END))as "84053",
count(distinct(CASE WHEN CC_ItemNumber = '84055' THEN CC_Contractor END))as "84055",
count(distinct(CASE WHEN CC_ItemNumber = '84056' THEN CC_Contractor END))as "84056",
count(distinct(CASE WHEN CC_ItemNumber = '84057' THEN CC_Contractor END))as "84057",
count(distinct(CASE WHEN CC_ItemNumber = '84058' THEN CC_Contractor END))as "84058",
count(distinct(CASE WHEN CC_ItemNumber = '84059' THEN CC_Contractor END))as "84059",
count(distinct(CASE WHEN CC_ItemNumber = '84060' THEN CC_Contractor END))as "84060",
count(distinct(CASE WHEN CC_ItemNumber = '84061' THEN CC_Contractor END))as "84061",
count(distinct(CASE WHEN CC_ItemNumber = '84062' THEN CC_Contractor END))as "84062",
count(distinct(CASE WHEN CC_ItemNumber = '91002' THEN CC_Contractor END))as "91002",
count(distinct(CASE WHEN CC_ItemNumber = '99890' THEN CC_Contractor END))as "99890",
count(distinct(CASE WHEN CC_ItemNumber = '99891' THEN CC_Contractor END))as "99891",
FROM TBL_ContractorCost with (nolock) INNER JOIN
TBL_ContractorWorkArea with (nolock) ON TBL_ContractorCost.CC_AddressID = TBL_ContractorWorkArea.CZ_LocationID
WHERE (TBL_ContractorWorkArea.CZ_IsEnabled = 1) AND (TBL_ContractorCost.CC_IsEnabled = 1) AND (NOT (TBL_ContractorCost.CC_Cost IS NULL))
group by CZ_ZipCode
Click to expand...

What? :laugh:
 
Markbnj

Markbnj

Elite Member <br>Moderator Emeritus
Moderator
Sep 16, 2005
15,682
14
81
www.markbetz.net
[MassiveQuery equips Bludgeon of Stack Overflow]
[MassiveQuery's Bludgeon of Stack Overflow hits you for 1250 (+231) damage!]
[MassiveQuery casts Aura of Failure]
[MassiveQuery's Aura of Failure hits you for 945 (-20) damage!]
[You cast Bolt of Recursion]
[Your Bolt of Recursion hits MassiveQuery for 35 (-1003) damage!]
[MassiveQuery's Bludgeon of Stack Overflow hits you for 1150 (+160) damage!]
[MassiveQuery casts Emergency Conference Call]
[MassiveQuery's Emergency Conference Call hits for for 1560 (+571) damage!]
[You have died!]
[You drop 2750 gold]
[MassiveQuery dances with you]
[MassiveQuery laughs]
 
Red Squirrel

Red Squirrel

No Lifer
May 24, 2003
70,568
13,803
126
www.anyf.ca
Wonder if mysql would handle that ok.

I did learn there is a limit to how many collumns can be in a table. Something around 10k it craps out. :p
 
B

brandonb

Diamond Member
Oct 17, 2006
3,731
2
0
Thats a pretty simple query actually. It's probably because of the max number of columns that can be returned. I believe there is a limit of 256 columns, but I can't really remember off the top of my head. Actually the distinct actually works? hmm. I'm not sure you even want that in there, maybe thats the problem.
 
Evadman

Evadman

Administrator Emeritus<br>Elite Member
Feb 18, 2001
30,990
5
81
Originally posted by: brandonb
Thats a pretty simple query actually. It's probably because of the max number of columns that can be returned. I believe there is a limit of 256 columns, but I can't really remember off the top of my head. Actually the distinct actually works? hmm. I'm not sure you even want that in there, maybe thats the problem.
Click to expand...

Sql 2000 is 4096, same as SQl 2008. I think you are confusing max columns in a table with max columns in a select statement. The above is about 900 odd. MS Access is about 350 or so in a crosstab; which is basicly what my query is.

Originally posted by: Markbnj
[MassiveQuery equips Bludgeon of Stack Overflow]
[MassiveQuery's Bludgeon of Stack Overflow hits you for 1250 (+231) damage!]
[MassiveQuery casts Aura of Failure]
[MassiveQuery's Aura of Failure hits you for 945 (-20) damage!]
[You cast Bolt of Recursion]
[Your Bolt of Recursion hits MassiveQuery for 35 (-1003) damage!]
[MassiveQuery's Bludgeon of Stack Overflow hits you for 1150 (+160) damage!]
[MassiveQuery casts Emergency Conference Call]
[MassiveQuery's Emergency Conference Call hits for for 1560 (+571) damage!]
[You have died!]
[You drop 2750 gold]
[MassiveQuery dances with you]
[MassiveQuery laughs]
Click to expand...

That is probably the funniest thing I have read this year. :cookie:
 
BoberFett

BoberFett

Lifer
Oct 9, 1999
37,562
9
81
Not sure what you'd do with that kind of output, but based on what you appear to want I usually use Reporting Services to turn things like into a matrix.

select
CZ_ZipCode,
CC_ItemNumber
FROM TBL_ContractorCost with (nolock) INNER JOIN
TBL_ContractorWorkArea with (nolock) ON TBL_ContractorCost.CC_AddressID = TBL_ContractorWorkArea.CZ_LocationID
WHERE (TBL_ContractorWorkArea.CZ_IsEnabled = 1) AND (TBL_ContractorCost.CC_IsEnabled = 1) AND (NOT (TBL_ContractorCost.CC_Cost IS NULL))
group by CZ_ZipCode, CC_ItemNumber

The Reporting Services wizard would take that query and output the exacty data you want with about half a dozen clicks.
 
skyking

skyking

Lifer
Nov 21, 2001
22,765
5,929
146
Originally posted by: Markbnj
[MassiveQuery equips Bludgeon of Stack Overflow]
[MassiveQuery's Bludgeon of Stack Overflow hits you for 1250 (+231) damage!]
[MassiveQuery casts Aura of Failure]
[MassiveQuery's Aura of Failure hits you for 945 (-20) damage!]
[You cast Bolt of Recursion]
[Your Bolt of Recursion hits MassiveQuery for 35 (-1003) damage!]
[MassiveQuery's Bludgeon of Stack Overflow hits you for 1150 (+160) damage!]
[MassiveQuery casts Emergency Conference Call]
[MassiveQuery's Emergency Conference Call hits for for 1560 (+571) damage!]
[You have died!]
[You drop 2750 gold]
[MassiveQuery dances with you]
[MassiveQuery laughs]
Click to expand...

This is great!
 
You must log in or register to reply here.

TRENDING THREADS

COMPANY
RESOURCES
FOLLOW
Top Bottom