Rolling Sum SQL CLR Deployment Script

USE Sandpit; -- Change to the name of your test database
GO
EXECUTE sys.sp_configure
    @configname = 'clr enabled',
    @configvalue = 1;
GO
RECONFIGURE;
GO
ALTER DATABASE Sandpit -- Change to the name of your database
SET TRUSTWORTHY ON;
GO
CREATE ASSEMBLY RollingSum
AUTHORIZATION dbo
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300338FF6550000000000000000E00002210B010B000024000000060000000000003E43000000200000006000000000001000200000000200000400000000000000040000000000000000A000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000E84200005300000000600000B002000000000000000000000000000000000000008000000C000000B04100001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000044230000002000000024000000020000000000000000000000000000200000602E72737263000000B0020000006000000004000000260000000000000000000000000000400000402E72656C6F6300000C0000000080000000020000002A000000000000000000000000000040000042000000000000000000000000000000002043000000000000480000000200050018290000981800000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002004800000001000011280F00000A6F1000000A027B0A0000043315027B090000041FFE330B02167D09000004020A2B0716731B0000060A06027B0C0000047D0B00000406027B0E0000047D0D000004062A1E0228140000062A1B300400E705000002000011027B090000040B07162E15071A5945020000007B0300007B05000038BA05000002157D0900000402731100000A7D0F000004027B0F000004027B0B0000046F1200000A027B0F000004027B0D0000046F1300000A027B0F000004166F1400000A027B0F000004176F1500000A02027B0F0000046F1600000A731700000A7D1000000402177D09000004027B100000046F1800000A02027B100000046F1900000A7D1100000402187D09000004027B1100000472010000706F1A00000A02027B11000004176F1B00000A7D1200000402197D090000040273130000067D13000004021F2D731C00000A7D14000004021F2D731D00000A7D150000040216731E00000A7D18000004027B120000046F1F00000A3903040000027B13000004027B12000004166F2000000A6F0A000006027B13000004027B12000004176F2100000A6F0C000006027B13000004027B12000004186F2000000A6F0E000006027B13000004027B13000004027B12000004196F2200000A250C6F10000006086F1200000602027B130000046F090000067D1600000402027B130000046F0B0000067D1700000402027B130000046F110000067D18000004027B150000040273080000067D1C000004027B1C000004027B130000046F0B0000066F05000006027B1C000004027B130000046F0F0000066F07000006027B1C0000046F2300000A027B140000040273130000067D1D000004027B1D000004027B160000046F0A000006027B1D000004027B130000046F0B0000066F0C000006027B1D000004027B130000046F0D0000066F0E000006027B1D000004027B130000046F0F0000066F10000006027B1D0000046F2400000A3877020000027B13000004027B12000004166F2000000A6F0A000006027B13000004027B12000004176F2100000A6F0C000006027B13000004027B12000004186F2000000A6F0E000006027B13000004027B12000004196F2200000A6F10000006027B130000046F09000006027B16000004333E027B130000046F0B000006027B17000004282500000A39C30000002B2102257B18000004027B150000046F2600000A6F06000006282700000A7D18000004027B150000046F2800000A163173027B17000004027B150000046F2900000A6F040000060D1203230000000000804640282A00000A282B00000A2DA32B4302027B140000046F2C00000A7D19000004027B19000004027B180000046F1200000602027B190000047D08000004021A7D09000004170ADD4F02000002197D09000004027B140000046F2D00000A1630AF02027B130000046F0B0000067D1700000402257B18000004027B130000046F0F000006282E00000A7D18000004027B130000046F09000006027B160000042E44027B150000046F2F00000A02027B130000046F090000067D1600000402027B130000046F0B0000067D1700000402027B130000046F0F0000067D1800000416283000000A027B150000040273080000067D1A000004027B1A000004027B130000046F0B0000066F05000006027B1A000004027B130000046F0F0000066F07000006027B1A0000046F2300000A027B140000040273130000067D1B000004027B1B000004027B160000046F0A000006027B1B000004027B130000046F0B0000066F0C000006027B1B000004027B130000046F0D0000066F0E000006027B1B000004027B130000046F0F0000066F10000006027B1B0000046F2400000A027B120000046F1F00000A3A79FDFFFF2B2102257B18000004027B150000046F2600000A6F06000006282700000A7D18000004027B150000046F2800000A163176027B130000046F0B000006027B150000046F2900000A6F0400000613041204230000000000804640282A00000A282B00000A2D9D2B4002027B140000046F2C00000A7D1E000004027B1E000004027B180000046F1200000602027B1E0000047D08000004021B7D09000004170ADE4F02197D09000004027B140000046F2D00000A1630B2027B150000046F2F00000A027B140000046F3100000A02147D1300000402281E00000602281D00000602281C000006160ADE07022819000006DC062A00411C00000400000000000000DE050000DE05000007000000000000001E027B080000042A1A733200000A7A001B3002007E00000003000011027B090000040A061759450500000001000000010000000100000001000000010000002A027B090000040B0718594504000000020000000200000002000000020000002B2F027B090000040C08195945030000000200000002000000020000002B09DE0702281E000006DCDE0702281D000006DCDE0702281C000006DC2A00000128000002006200026400070000000002004500286D0007000000000200240052760007000000001E027B080000042A7A02283300000A02037D0900000402280F00000A6F1000000A7D0A0000042A6E02157D09000004027B100000042C0B027B100000046F0C00000A2A6E02177D09000004027B110000042C0B027B110000046F0C00000A2A6E02187D09000004027B120000042C0B027B120000046F0C00000A2A001330020018000000010000111FFE731B0000060A06027D0C00000406037D0E000004062A133002005A000000040000110274040000020A03066F09000006283400000A810300000104066F0B000006810400000105066F0D000006283400000A81030000010E04066F0F000006283500000A81050000010E05066F11000006283500000A81050000012A1E02283300000A2A1E027B010000042A2202037D010000042A1E027B020000042A2202037D020000042A1E02283300000A2A1E027B030000042A2202037D030000042A1E027B040000042A2202037D040000042A1E027B050000042A2202037D050000042A1E027B060000042A2202037D060000042A1E027B070000042A2202037D070000042A1E02283300000A2A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000084070000237E0000F00700008809000023537472696E677300000000781100004C03000023555300C4140000100000002347554944000000D4140000C403000023426C6F6200000000000000020000015717A20B0902000000FA253300160000010000001F000000050000001E0000001E0000001000000005000000360000002200000004000000030000000900000010000000070000000400000001000000030000000300000000000A00010000000000060053004C0006006D005A000A00A50090000600AE004C000A00B7009000060001014C000A00920277020600D402B5020600FA02E70227000E03000006003D031D0306005D031D030A007B0377020600BC03A1030600CA03A1030600D8035A000600E4034C000A00A60590050A00CB0590050A00E40590050A00F90590050E002206A10306007807E7020600A10790070A00250812080A00540812080A00740812080A008E0884000A00AC081208060049094C0006006B091D0300000000010000000000010001000100100019000000050001000100030010002E000000050001000400030010003B0000000500030009000301100090030000050008001400010027013F000100480143000100E7015A00010027013F00010002025A0001004801430001002402430001007804C802010021055A0001002C055A0006006A02D40206006C05D4020600A402D40206007E05D4020600C105D7020600D905DB020600EF05DF0206000706E30206001106E70206002A06EB0206003D06F302060052065A00060067063F0006007906430006008A06E70206009C06FB020600AC06E7020600BC06FB020600CC06E7020600DC06E702FC2700000000960079000A0001002028000000009600C000110003008628000000008618D300250009008E28000000008608D900290009009628000000008608ED002E0009009F28000000008608090134000A00A728000000008608180139000A00B028000000008618D30025000B00B8280000000086087F0151000B00C0280000000086088D0155000B00C928000000008608D90029000C00D128000000008608ED002E000C00DA280000000086089B0151000D00E228000000008608B00155000D00EB28000000008608090134000E00F328000000008608180139000E00FC28000000008608C50134000F000429000000008608D60139000F000D29000000008618D30025001000502000000000E101F003AE021000A42000000000E1014204BF021000AC2000000000E1016F04C4021000BC2600000000E1098504CB021000C42600000000E101D30425001000CC2600000000E101FE0425001000802700000000E1094105CB0210008827000000008618D30055001000A727000000008100E60625001100C327000000008100F50625001100DF27000000008100040725001100000001006A0200000200A40200000100B102020002004202020003006401020004004C02020005007401020006005D0200000100E10200000100E10200000100E10200000100E10200000100E10200000100E10200000100E102000001002105050006000500090005000A0005004100050045003900D30025004100D30025004900D30074005900D30055006100D30025006900D30025000C003404B60211003404BF0281006F04C4021400C704CF028100F80425008900190525008100C704CB02B900D3002500C100A8070803C100BA0751009100D30025009100CE0712039100DD0712039100F00717039100FB071703C9003F081C039900D3001203D10061082500990066082003D9007E081203A1009E0825031C00D30055002400D30055003100D3005500E900B908C402E900BE083A03E900C7083F03E900D30845032400DE084B031C00DE084B032100E60851032400F408CF023100FC08590324000B09510024001509CF0221001A0962032100220951031C00F408CF021C000B09510031003109590324003D092500C100430968031C003D092500F100D30025000900D300250019005F097E0329005F098403F900D3002500200033007A002100B301030324000B0061002E001B0090032E002B00A2032E00230099034100B301030344000B0061006100B30103038000B30103038100B3010303A000B3010303A100B3010303A300B3010303C000B3010303C100B3010303E000B3010303E100B30103032001B30103034001B30103036001B30103038001B3010303A001B3010303C001B3010303E001B30103030002B30103032002B30103034002B3010303800273000303A00273000303E002730003030003730003034003730003036003730003030D036D0378038B03030001000400030005000800000064014700000074014C00000042025D0000006401470000004C025D00000074014C0000005D024C0000001307FF0200005107FF0202000400030001000500030002000600050001000700050002000900070001000A00070001000C00090002000B00090002000D000B0001000E000B00010010000D0002000F000D00010012000F00020011000F0002001700110002001A001300050028000F0005002A00110005002C00130005002E001500050030001700050032001900050034001B00A202A8022C033303048000000000000000000000000000000000790000000200000000000000000000000100430000000000020000000000000000000000010084000000000002000000000000000000000001004C000000000003000200040002000500020000000000003C4D6F64756C653E00526F6C6C696E6753756D2E646C6C0055736572446566696E656446756E6374696F6E730044617465436F7374496E666F00526F77496E666F006D73636F726C69620053797374656D004F626A6563740053797374656D2E436F6C6C656374696F6E730049456E756D657261626C6500526F6C6C696E6753756D0053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C496E743332004461746554696D650053716C4D6F6E657900526F6C6C696E6753756D5F46696C6C526F77002E63746F72006765745F5472616E73616374696F6E44617465007365745F5472616E73616374696F6E4461746500446563696D616C006765745F41637475616C436F7374007365745F41637475616C436F7374003C5472616E73616374696F6E446174653E6B5F5F4261636B696E674669656C64003C41637475616C436F73743E6B5F5F4261636B696E674669656C64005472616E73616374696F6E446174650041637475616C436F7374006765745F50726F647563744944007365745F50726F647563744944006765745F5265666572656E63654F726465724944007365745F5265666572656E63654F726465724944006765745F526F6C6C696E6753756D3435007365745F526F6C6C696E6753756D3435003C50726F6475637449443E6B5F5F4261636B696E674669656C64003C5265666572656E63654F7264657249443E6B5F5F4261636B696E674669656C64003C526F6C6C696E6753756D34353E6B5F5F4261636B696E674669656C640050726F647563744944005265666572656E63654F72646572494400526F6C6C696E6753756D343500496E7374616E63654E616D65004D6963726F736F66742E53716C5365727665722E5365727665720053716C46616365744174747269627574650044617461626173654E616D65006F626A0053797374656D2E52756E74696D652E496E7465726F705365727669636573004F75744174747269627574650076616C75650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053716C46756E6374696F6E417474726962757465003C526F6C6C696E6753756D3E645F5F340053797374656D2E436F6C6C656374696F6E732E47656E657269630049456E756D657261626C6560310049456E756D657261746F7260310049456E756D657261746F720049446973706F7361626C650053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261626C653C53797374656D2E4F626A6563743E2E476574456E756D657261746F7200476574456E756D657261746F720053797374656D2E436F6C6C656374696F6E732E49456E756D657261626C652E476574456E756D657261746F72004D6F76654E657874003C3E325F5F63757272656E740053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E4F626A6563743E2E6765745F43757272656E74006765745F43757272656E740053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E52657365740052657365740053797374656D2E49446973706F7361626C652E446973706F736500446973706F7365003C3E315F5F7374617465003C3E6C5F5F696E697469616C54687265616449640053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E6765745F43757272656E74003C3E335F5F496E7374616E63654E616D65003C3E335F5F44617461626173654E616D650053797374656D2E446174612E53716C436C69656E740053716C436F6E6E656374696F6E537472696E674275696C646572003C6373623E355F5F350053716C436F6E6E656374696F6E003C636F6E6E3E355F5F360053716C436F6D6D616E64003C636D643E355F5F370053716C44617461526561646572003C7264723E355F5F38003C63757272656E74526F773E355F5F390051756575656031003C73616D6544617465526F77733E355F5F61003C636163686564436F7374496E666F3E355F5F62003C63757272656E7450726F647563743E355F5F63003C63757272656E74446174653E355F5F64003C63757272656E7453756D3E355F5F65003C73616D6544617465526F773E355F5F66003C3E675F5F696E69744C6F63616C32003C3E675F5F696E69744C6F63616C33003C3E675F5F696E69744C6F63616C30003C3E675F5F696E69744C6F63616C31003C71693E355F5F3130003C3E6D5F5F46696E616C6C793131003C3E6D5F5F46696E616C6C793132003C3E6D5F5F46696E616C6C7931330053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E4F626A6563743E2E43757272656E740053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E43757272656E7400446562756767657248696464656E4174747269627574650053797374656D2E546872656164696E6700546872656164006765745F43757272656E74546872656164006765745F4D616E616765645468726561644964007365745F44617461536F75726365007365745F496E697469616C436174616C6F67007365745F456E6C697374007365745F496E746567726174656453656375726974790053797374656D2E446174612E436F6D6D6F6E004462436F6E6E656374696F6E537472696E674275696C646572006765745F436F6E6E656374696F6E537472696E67004462436F6E6E656374696F6E004F70656E00437265617465436F6D6D616E64004462436F6D6D616E64007365745F436F6D6D616E645465787400436F6D6D616E644265686176696F72004578656375746552656164657200446244617461526561646572005265616400476574496E743332004765744461746554696D6500476574446563696D616C00456E7175657565006F705F496E657175616C6974790044657175657565006F705F5375627472616374696F6E006765745F436F756E74005065656B0041646444617973006F705F477265617465725468616E006F705F4164646974696F6E00436C65617200536C656570004E6F74537570706F72746564457863657074696F6E006F705F496D706C6963697400436F6D70696C657247656E6572617465644174747269627574650000000083470D000A0020002000200020002000200020002000200020002000200020002000200020002000200020002000530045004C004500430054000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E00500072006F006400750063007400490044002C000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E005400720061006E00730061006300740069006F006E0044006100740065002C000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E005200650066006500720065006E00630065004F007200640065007200490044002C000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E00410063007400750061006C0043006F00730074000D000A0020002000200020002000200020002000200020002000200020002000200020002000200020002000460052004F004D002000500072006F00640075006300740069006F006E002E005400720061006E00730061006300740069006F006E0048006900730074006F00720079002000410053002000540048000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020004F0052004400450052002000420059000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E00500072006F006400750063007400490044002C000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E005400720061006E00730061006300740069006F006E0044006100740065002C000D000A00200020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000540048002E005200650066006500720065006E00630065004F007200640065007200490044003B000000007727443C06454B46A717E2BBAC6399400008B77A5C561934E08906000212090E0E130006011C10110D10111110110D10111510111503200001042000111105200101111104200011190520010111190306111103061119042800111104280011190320000804200101080206080328000812010001005408074D617853697A65800000000520010111298226010004005455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A446174614163636573730100000054557F4D6963726F736F66742E53716C5365727665722E5365727665722E53797374656D446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038391053797374656D4461746141636365737300000000540E1146696C6C526F774D6574686F644E616D6512526F6C6C696E6753756D5F46696C6C526F77540E0F5461626C65446566696E6974696F6E80C50D0A20202020202020202020202050726F64756374494420696E7465676572204E554C4C2C200D0A2020202020202020202020205472616E73616374696F6E446174652064617465204E554C4C2C0D0A2020202020202020202020205265666572656E63654F72646572494420696E7465676572204E554C4C2C200D0A20202020202020202020202041637475616C436F7374206D6F6E6579204E554C4C2C200D0A202020202020202020202020526F6C6C696E6753756D3435206D6F6E6579204E554C4C05151239011C0515123D011C07200015123D011C08200015123D01130004200012410320000202061C0320001C042000130002060E030612490306124D0306125103061255030612100706151259011210070615125901120C0306120C0328001C040100000004000012610407011214042001010E04200101020320000E042000125106200112551171061512590112100615125901120C0420010808052001111108052001111908052001011300070002021111111108000211191119111905200111110D04000101080A07050208111911111111050703080808050001110D080600011115111904070112100801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000000000338FF65500000000020000001C010000CC410000CC2300005253445310629DC36AED4448A56796CD82BD6E1F02000000633A5C55736572735C5061756C2057686974655C446F63756D656E74735C56697375616C2053747564696F20323031335C50726F6A656374735C4461746162617365325C4461746162617365325C6F626A5C52656C656173655C526F6C6C696E6753756D2E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001043000000000000000000002E4300000020000000000000000000000000000000000000000000002043000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058600000540200000000000000000000540234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004B4010000010053007400720069006E006700460069006C00650049006E0066006F0000009001000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000052006F006C006C0069006E006700530075006D002E0064006C006C00000000002800020001004C006500670061006C0043006F00700079007200690067006800740000002000000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000052006F006C006C0069006E006700530075006D002E0064006C006C0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000C000000403300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = EXTERNAL_ACCESS;
GO
CREATE FUNCTION dbo.RollingSum
(
    @InstanceName sysname,
    @DatabaseName sysname
)
RETURNS TABLE
(
    ProductID integer NULL,
    TransactionDate date NULL,
    ReferenceOrderID integer NULL,
    ActualCost money NULL,
    RollingSum45 money NULL
)
WITH EXECUTE AS CALLER
ORDER (ProductID, TransactionDate, ReferenceOrderID)
AS EXTERNAL NAME RollingSum.UserDefinedFunctions.RollingSum;