Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Ids TABLE (
- Id VARCHAR(50)
- )
- INSERT INTO @Ids (Id)
- SELECT
- '5-14724'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14726'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14730'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14732'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14733'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14734'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14735'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14739'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14748'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14750'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14752'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14765'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14771'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14773'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14774'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14775'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14777'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14778'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14779'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14781'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14782'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14784'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14785'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14787'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14790'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14793'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14794'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14799'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14800'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14803'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14809'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14812'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14816'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14818'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14820'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14821'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14825'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14828'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14830'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14835'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14836'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14837'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14838'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14841'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14842'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14844'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14845'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14846'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14848'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14849'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14850'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14851'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14853'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14857'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14859'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14860'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14862'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14863'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14864'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14868'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14870'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14876'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14877'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14878'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14888'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14889'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14890'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14892'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14893'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14895'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14899'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14903'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14906'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14914'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14915'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14917'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14918'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14919'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14922'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14930'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14931'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14938'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14939'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14940'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14952'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14954'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14957'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14958'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14960'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14962'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14965'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14966'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14967'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14968'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14970'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14971'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14972'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14973'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14974'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14977'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14979'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14980'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14983'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14986'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14991'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14992'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14993'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14994'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14995'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14996'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14997'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14998'
- INSERT INTO @Ids (Id)
- SELECT
- '5-14999'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15000'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15001'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15002'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15003'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15004'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15005'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15006'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15007'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15008'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15009'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15010'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15011'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15012'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15013'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15014'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15015'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15016'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15017'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15486'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15487'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15492'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15494'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15495'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15496'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15498'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15502'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15504'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15505'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15507'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15509'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15513'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15521'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15523'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15526'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15527'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15529'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15530'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15533'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15536'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15537'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15538'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15540'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15543'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15547'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15548'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15549'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15551'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15552'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15554'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15558'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15559'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15560'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15561'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15562'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15563'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15564'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15568'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15569'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15571'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15572'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15573'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15574'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15575'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15579'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15580'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15581'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15583'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15584'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15585'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15586'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15587'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15588'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15591'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15592'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15593'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15595'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15596'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15597'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15599'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15600'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15601'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15603'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15604'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15607'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15608'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15611'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15612'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15614'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15615'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15617'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15619'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15621'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15628'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15630'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15640'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15642'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15645'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15647'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15651'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15662'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15664'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15666'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15668'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15671'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15673'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15675'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15677'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15678'
- INSERT INTO @Ids (Id)
- SELECT
- '5-15680'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16038'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16040'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16041'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16042'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16044'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16045'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16047'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16049'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16050'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16057'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16062'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16063'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16065'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16067'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16069'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16070'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16074'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16075'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16080'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16082'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16083'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16084'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16085'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16086'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16087'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16089'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16092'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16093'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16098'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16099'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16100'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16101'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16105'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16106'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16108'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16109'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16110'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16111'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16112'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16113'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16116'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16117'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16118'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16119'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16120'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16121'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16122'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16124'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16125'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16126'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16127'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16128'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16129'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16130'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16134'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16136'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16137'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16138'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16139'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16147'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16149'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16150'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16152'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16155'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16156'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16157'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16158'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16160'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16161'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16162'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16163'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16171'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16172'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16173'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16174'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16176'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16177'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16178'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16179'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16180'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16182'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16183'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16185'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16187'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16188'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16189'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16190'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16191'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16195'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16196'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16197'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16198'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16201'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16205'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16209'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16210'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16211'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16212'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16214'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16215'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16216'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16217'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16218'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16220'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16221'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16222'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16223'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16230'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16231'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16232'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16233'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16563'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16565'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16568'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16569'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16571'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16572'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16573'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16574'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16581'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16583'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16587'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16588'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16591'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16596'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16597'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16599'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16602'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16604'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16605'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16611'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16617'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16618'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16620'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16621'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16624'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16625'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16627'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16630'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16631'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16632'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16635'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16636'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16637'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16638'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16642'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16644'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16645'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16646'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16647'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16648'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16649'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16651'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16652'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16655'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16658'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16660'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16661'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16662'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16665'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16666'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16670'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16671'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16672'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16674'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16675'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16677'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16679'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16681'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16690'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16694'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16699'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16701'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16702'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16704'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16707'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16712'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16713'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16715'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16717'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16720'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16723'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16724'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16725'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16726'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16729'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16731'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16732'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16734'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16735'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16740'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16741'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16745'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16753'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16754'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16756'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16757'
- INSERT INTO @Ids (Id)
- SELECT
- '5-16761'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17083'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17086'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17087'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17090'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17091'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17092'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17093'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17096'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17097'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17098'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17099'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17103'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17104'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17105'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17108'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17110'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17113'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17114'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17120'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17124'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17126'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17130'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17131'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17132'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17139'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17140'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17141'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17144'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17145'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17156'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17160'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17166'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17168'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17175'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17180'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17185'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17187'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17188'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17191'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17193'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17197'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17199'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17200'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17201'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17204'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17205'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17206'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17207'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17208'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17209'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17210'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17211'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17212'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17213'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17214'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17215'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17216'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17217'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17218'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17220'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17221'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17222'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17223'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17224'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17225'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17226'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17227'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17228'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17229'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17230'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17232'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17233'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17234'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17236'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17238'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17239'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17243'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17245'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17248'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17251'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17261'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17265'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17271'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17272'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17275'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17276'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17277'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17279'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17622'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17626'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17628'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17629'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17630'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17633'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17635'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17642'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17643'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17644'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17645'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17647'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17648'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17651'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17653'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17663'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17736'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17737'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17741'
- INSERT INTO @Ids (Id)
- SELECT
- '5-17744'
- INSERT INTO @Ids (Id)
- SELECT
- '5-19375'
- INSERT INTO @Ids (Id)
- SELECT
- '5-19400'
- INSERT INTO @Ids (Id)
- SELECT
- '5-19450'
- INSERT INTO @Ids (Id)
- SELECT
- '5-19715'
- INSERT INTO @Ids (Id)
- SELECT
- '5-19761'
- INSERT INTO @Ids (Id)
- SELECT
- '5-19762'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20077'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20200'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20203'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20945'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20954'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20955'
- INSERT INTO @Ids (Id)
- SELECT
- '5-20956'
- INSERT INTO @Ids (Id)
- SELECT
- '5-21208'
- INSERT INTO @Ids (Id)
- SELECT
- '5-21242'
- INSERT INTO @Ids (Id)
- SELECT
- '5-21273'
- INSERT INTO @Ids (Id)
- SELECT
- '5-21699'
- INSERT INTO @Ids (Id)
- SELECT
- '5-21857'
- INSERT INTO @Ids (Id)
- SELECT
- '5-21859'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22025'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22159'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22437'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22660'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22840'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22841'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22842'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22923'
- INSERT INTO @Ids (Id)
- SELECT
- '5-22933'
- INSERT INTO @Ids (Id)
- SELECT
- '5-23475'
- INSERT INTO @Ids (Id)
- SELECT
- '5-23479'
- INSERT INTO @Ids (Id)
- SELECT
- '5-24829'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25077'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25084'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25088'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25092'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25383'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25764'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25772'
- INSERT INTO @Ids (Id)
- SELECT
- '5-25787'
- INSERT INTO @Ids (Id)
- SELECT
- '5-26251'
- INSERT INTO @Ids (Id)
- SELECT
- '5-26448'
- INSERT INTO @Ids (Id)
- SELECT
- '5-26801'
- INSERT INTO @Ids (Id)
- SELECT
- '5-27605'
- INSERT INTO @Ids (Id)
- SELECT
- '5-28394'
- INSERT INTO @Ids (Id)
- SELECT
- '5-28446'
- INSERT INTO @Ids (Id)
- SELECT
- '5-28481'
- INSERT INTO @Ids (Id)
- SELECT
- '5-28549'
- INSERT INTO @Ids (Id)
- SELECT
- '5-28981'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29173'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29276'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29345'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29346'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29495'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29500'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29551'
- INSERT INTO @Ids (Id)
- SELECT
- '5-29560'
- INSERT INTO @Ids (Id)
- SELECT
- '5-30037'
- INSERT INTO @Ids (Id)
- SELECT
- '5-30677'
- INSERT INTO @Ids (Id)
- SELECT
- '5-30906'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31355'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31361'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31380'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31383'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31386'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31734'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31887'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31911'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31913'
- INSERT INTO @Ids (Id)
- SELECT
- '5-31916'
- INSERT INTO @Ids (Id)
- SELECT
- '5-32504'
- INSERT INTO @Ids (Id)
- SELECT
- '5-34056'
- INSERT INTO @Ids (Id)
- SELECT
- '5-34061'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37668'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37699'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37734'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37747'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37752'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37764'
- INSERT INTO @Ids (Id)
- SELECT
- '5-37902'
- INSERT INTO @Ids (Id)
- SELECT
- '5-38845'
- INSERT INTO @Ids (Id)
- SELECT
- '5-38851'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41669'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41671'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41672'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41679'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41682'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41875'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41877'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41938'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41947'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41949'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41951'
- INSERT INTO @Ids (Id)
- SELECT
- '5-41952'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42018'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42047'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42048'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42049'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42050'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42052'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42053'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42054'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42057'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42058'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42104'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42106'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42107'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42111'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42123'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42125'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42127'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42128'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42129'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42131'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42149'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42200'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42201'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42218'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42241'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42242'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42246'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42316'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42465'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42467'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42514'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42573'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42577'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42597'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42598'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42615'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42622'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42624'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42625'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42628'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42660'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42668'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42671'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42697'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42698'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42700'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42717'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42721'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42734'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42797'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42798'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42813'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42815'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42816'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42831'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42835'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42844'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42845'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42850'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42851'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42867'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42871'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42921'
- INSERT INTO @Ids (Id)
- SELECT
- '5-42965'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43208'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43212'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43218'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43219'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43221'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43246'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43248'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43255'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43257'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43259'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43339'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43357'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43358'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43366'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43561'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43589'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43590'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43591'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43592'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43593'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43705'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43750'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43812'
- INSERT INTO @Ids (Id)
- SELECT
- '5-43980'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44028'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44126'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44144'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44191'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44211'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44213'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44215'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44220'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44329'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44330'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44544'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44553'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44582'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44583'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44704'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44790'
- INSERT INTO @Ids (Id)
- SELECT
- '5-44796'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45182'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45214'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45261'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45384'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45388'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45582'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45602'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45756'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45757'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45885'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45891'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45900'
- INSERT INTO @Ids (Id)
- SELECT
- '5-45975'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46117'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46253'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46255'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46259'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46272'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46273'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46340'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46471'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46482'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46497'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46633'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46634'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46635'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46636'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46703'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46706'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46727'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46755'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46895'
- INSERT INTO @Ids (Id)
- SELECT
- '5-46942'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47004'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47007'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47049'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47096'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47098'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47130'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47131'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47259'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47260'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47517'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47519'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47520'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47523'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47553'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47555'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47570'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47578'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47615'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47617'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47618'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47651'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47669'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47690'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47691'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47740'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47781'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47782'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47811'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47818'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47907'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47910'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47912'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47969'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47970'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47971'
- INSERT INTO @Ids (Id)
- SELECT
- '5-47972'
- INSERT INTO LocationStatus (LocationId, WreathsYearId, StatusId, StatusById, StatusNote)
- SELECT
- wlp.LocationId
- ,wlp.WreathsDayId
- ,8
- ,'0fa57843-d743-4397-b032-00df9b091c95'
- ,NULL
- FROM wh_LogisticsPlanning wlp
- JOIN (SELECT
- Id
- FROM @Ids
- GROUP BY Id) ids
- ON wlp.Id = ids.Id
- UPDATE wlp
- SET wlp.LastStatusId = ls.Id
- FROM wh_LogisticsPlanning wlp
- JOIN (SELECT
- Id
- FROM @Ids
- GROUP BY Id) ids
- ON wlp.Id = ids.Id
- JOIN (SELECT
- MaxId = MAX(Id)
- ,LocationId
- ,WreathsYearId
- FROM LocationStatus ls
- GROUP BY LocationId
- ,WreathsYearId) ls_max
- ON wlp.LocationId = ls_max.LocationId
- AND wlp.WreathsDayId = ls_max.WreathsYearId
- JOIN LocationStatus ls
- ON ls_max.MaxId = ls.Id
Add Comment
Please, Sign In to add comment