-
-
Save lbehm/563db9921e96a84b878ba01152e74363 to your computer and use it in GitHub Desktop.
Revisions
-
lbehm revised this gist
Jan 24, 2018 . 2 changed files with 12 additions and 11 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -13,7 +13,7 @@ MaxByteSize = -1, Name = "STRING_AGG" )] public class STRING_AGG : IBinarySerialize { /// <summary> /// Stores the concatenated string @@ -23,15 +23,15 @@ public struct STRING_AGG : IBinarySerialize /// <summary> /// Store the Separator /// </summary> public String Separator { get; private set; } /// <summary> /// Appends the Separator if necessary /// </summary> private void AddSeparator() { if (Result.Length > 0) Result.Append(Separator); } /// <summary> @@ -40,15 +40,16 @@ private void AddSeparator() public void Init() { Result = new StringBuilder(); Separator = string.Empty; } /// <summary> /// Stores separator in instance and appends value to the Result /// </summary> public void Accumulate(SqlString value, SqlString separator) { if (!separator.IsNull) Separator = separator.Value; if (value.IsNull) return; @@ -75,7 +76,7 @@ public void Merge(STRING_AGG group) public SqlString Terminate() { //return new SqlString(_intermediateResult == null ? string.Empty : _intermediateResult.ToString()); return new SqlString(Result.ToString()); } #region IBinarySerialize @@ -89,7 +90,7 @@ public void Read(BinaryReader reader) throw new ArgumentNullException("Serialized Data is NULL"); Result = new StringBuilder(reader.ReadString()); Separator = reader.ReadString(); } /// <summary> @@ -102,7 +103,7 @@ public void Write(BinaryWriter writer) throw new ArgumentNullException("Serialization Writer is NULL"); writer.Write(Result.ToString()); writer.Write(Separator); } #endregion IBinarySerialize } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -8,9 +8,9 @@ BEGIN DROP ASSEMBLY [STRING_AGG] CREATE ASSEMBLY [STRING_AGG] -- FROM N'.\STRING_AGG.dll' -- compiled with .NET 2.0 / SQL Server 2014 FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C01030075E1685A0000000000000000E00002210B010B00000E000000060000000000006E2D0000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000202D00004B000000004000001803000000000000000000000000000000000000006000000C000000E82B00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000740D000000200000000E000000020000000000000000000000000000200000602E7273726300000018030000004000000004000000100000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001400000000000000000000000000004000004200000000000000000000000000000000502D000000000000480000000200050084210000640A000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E027B010000042A2202037D010000042A1E027B020000042A2202037D020000042A860228010000066F1300000A1631120228010000060228030000066F1400000A262A5E02731500000A2802000006027E1600000A28040000062AEA0F02281700000A2D0D020F02281800000A28040000060F01281700000A2C012A0228050000060228010000060F01281800000A6F1400000A262AA2036F010000066F1300000A1631012A022805000006022801000006036F010000066F1900000A262A460228010000066F1A00000A731B00000A2AB2032D0B7201000070731C00000A7A02036F1D00000A731E00000A280200000602036F1D00000A28040000062AB2032D0B7231000070731C00000A7A030228010000066F1A00000A6F1F00000A030228030000066F1F00000A2A1E02282000000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000A0030000237E00000C0400005004000023537472696E6773000000005C0800006C00000023555300C8080000100000002347554944000000D80800008C01000023426C6F6200000000000000020000015717A0010900000000FA253300160000010000001C00000002000000020000000C00000007000000010000002000000014000000010000000200000004000000010000000200000000000A00010000000000060034002D000A006200470006007F0073000A00E600D100060015010B01060027010B010600BA01A8010600D101A8010600EE01A80106000D02A80106002602A80106003F02A80106005A02A80106007502A8010600AD028E020600C1028E020600CF02A8010600E802A8010600180305034F002C03000006005B033B0306007B033B03060099032D000A00AF0347000A00D00347000600D7033B03060004042D0006002F042D000000000001000000000001000100012010001900000005000100010001004001410001005801450050200000000086088D000A000100582000000000810898000F0001006120000000008608A300150002006920000000008108B100190002007220000000008100BF001E0003009420000000008600CC001E000300AC20000000008600F00022000300E720000000008600FB002A0005001021000000008600010130000600222100000000E6012201350006004F2100000000E60134013B0007007C210000000086183A011E000800000001008401000001008401000001008401000002008A01000001009401000001009A0100000100A1010200090039003A01190041003A01190049003A01190051003A01190059003A01190061003A01190069003A01190071003A01190079003A01510081003A01190089003A01190091003A01190099003A015600A9003A015C00B1003A011E00B9003A011E00C1003A016100D1003A011E001900F203E0001900FD03E40019003A011E00D9000B04450021001104EA0021001C0415001900FD03EE0009002604150021003A011900E1003A01190029004504150019003A01190031003401190009003A011E0020009300DB0021009300DB002E001B0004012E002B00F4002E007B006B012E0033000A012E00730062012E000B00F4002E00130004012E00230004012E003B0004012E004B0004012E00530022012E0063004C012E006B00590140009300DB0041009300DB0043008B00670060009300DB0080009300DB000200010000007301480000007A014D0002000100030001000200030002000300050001000400050004800000010000000000000000000000000019000000020000000000000000000000010024000000000002000000000000000000000001003B00000000000000003C4D6F64756C653E00535452494E475F4147472E646C6C00535452494E475F414747006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572006765745F526573756C74007365745F526573756C74006765745F536570617261746F72007365745F536570617261746F7200416464536570617261746F7200496E69740053797374656D2E446174612E53716C54797065730053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F72003C526573756C743E6B5F5F4261636B696E674669656C64003C536570617261746F723E6B5F5F4261636B696E674669656C6400526573756C7400536570617261746F720076616C756500736570617261746F720067726F757000726561646572007772697465720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D617400436F6D70696C657247656E657261746564417474726962757465006765745F4C656E67746800417070656E6400537472696E6700456D707479006765745F49734E756C6C006765745F56616C756500546F537472696E6700417267756D656E744E756C6C457863657074696F6E0052656164537472696E6700002F530065007200690061006C0069007A00650064002000440061007400610020006900730020004E0055004C004C000039530065007200690061006C0069007A006100740069006F006E00200057007200690074006500720020006900730020004E0055004C004C00000089908C5CFD779349B11978061F4B47630008B77A5C561934E089042000120D05200101120D0320000E042001010E03200001072002011111111105200101120804200011110520010112150520010112190306120D02060E042800120D0328000E042001010205200101115104200101080520010111657301000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65FFFFFFFF540E044E616D650A535452494E475F414747040100000003200008052001120D0E03200002052001120D1C0F01000A535452494E475F414747000005010000000017010012436F7079726967687420C2A920203230313800002901002462383662336562612D376332332D343130302D626663332D63623765313238643330373200000C010007312E302E302E3000000801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000000075E1685A00000000020000001C010000042C0000040E0000525344539056BBA08E79A14BBE41BC440F1FDF3A07000000633A5C55736572735C4265686D6F5C446F63756D656E74735C56697375616C2053747564696F20323031325C50726F6A656374735C535452494E475F4147475C535452494E475F4147475C6F626A5C52656C656173655C535452494E475F4147472E706462000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000482D000000000000000000005E2D0000002000000000000000000000000000000000000000000000502D00000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000C00200000000000000000000C00234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00420020000010053007400720069006E006700460069006C00650049006E0066006F000000FC010000010030003000300030003000340062003000000040000B000100460069006C0065004400650073006300720069007000740069006F006E000000000053005400520049004E0047005F0041004700470000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A900200020003200300031003800000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C000000000038000B000100500072006F0064007500630074004E0061006D0065000000000053005400520049004E0047005F0041004700470000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000703D00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE CREATE AGGREGATE [STRING_AGG] (@value [nvarchar](max), @separator [nvarchar](max)) -
Jan 18, 2018 . 1 changed file with 1 addition and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -9,6 +9,7 @@ BEGIN CREATE ASSEMBLY [STRING_AGG] -- FROM ".\STRING_AGG.dll" -- compiled for SQL Server 2014 FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300CDD45F5A0000000000000000E00002210B010B00001000000006000000000000AE2E0000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000542E000057000000004000001803000000000000000000000000000000000000006000000C0000001C2D00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B40E0000002000000010000000020000000000000000000000000000200000602E7273726300000018030000004000000004000000120000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001600000000000000000000000000004000004200000000000000000000000000000000902E0000000000004800000002000500C4210000580B000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E027B010000042A2202037D010000042A1E027B020000042A2202037D020000042A00001330020029000000010000110228010000066F1500000A16311A0228010000060228030000060A1200281600000A6F1700000A262A7202731800000A2802000006027E1900000A731A00000A28040000062A0000033002004000000000000000020F02281B00000A2D03042B0A7E1900000A281C00000A28040000060F01281B00000A2C012A0228050000060228010000060F01281600000A6F1700000A262AAA0F0128010000066F1500000A1631012A0228050000060228010000060F0128010000066F1D00000A262A460228010000066F1E00000A281C00000A2AC6032D0B7201000070731F00000A7A02036F2000000A732100000A280200000602036F2000000A731A00000A28040000062A00133002003400000001000011032D0B7231000070731F00000A7A030228010000066F1E00000A6F2200000A030228030000060A1200281600000A6F2200000A2A42534A4201000100000000000C00000076342E302E33303331390000000005006C000000C4030000237E000030040000BC04000023537472696E677300000000EC0800006C000000235553005809000010000000234755494400000068090000F001000023426C6F6200000000000000020000015717A2010900000000FA253300160000010000002000000002000000020000000B0000000700000001000000220000001500000001000000010000000200000004000000010000000200000000000A00010000000000060034002D000A0065004A000600820076000A00BB00A600060018010E0106002A010E010600BF01A5010600F001DE0106000702DE0106002402DE0106004302DE0106005C02DE0106007502DE0106009002DE010600AB02DE010600E302C4020600F702C40206000503DE0106001E03DE0106004E033B035300620300000600910371030600B10371030600CF032D000A00E5034A000A0006044A0006000D04C40206002304C40206002E047103060065042D00060089042D00060099042D000000000001000000000001000100092110001900000005000100010001003D013E00010055014200502000000000860890000A00010058200000000081089B000F0001006120000000008608C500150002006920000000008108D3001A0002007420000000008100E10020000300A920000000008600EE0020000300C820000000008600F300240003001421000000008600FE002C0005003F21000000008600040115000600512100000000E601250132000600842100000000E601370138000700000001008101000001008101000001008101000002008701000001009101000001009701000001009E01020009003900D80150004100D80150004900D80150005100D80150005900D80150006100D80150006900D80150007100D80150007900D80150008100D80155008900D80150009100D80150009900D8015000A100D8015A00B100D8016000B900D8012000C100D8012000C900D8016500D900D801DF00E900D801200019004904EA0021005404EE0019005E04F2001900D8012000F1006C04FD002100D801500021007204000121007D04040119005E040A01F9009004EE000101D80150002900AF04EE001900D80150003100370150002000A300E5002100A300E5002E0023006A012E002B006A012E0033005A012E007B00C8012E000B0010012E0013005A012E001B006A012E008300D1012E003B0070012E0043006A012E0053006A012E005B0088012E006B00B2012E007300BF014000A300E5004100A300E500430093006B006000A300E5008000A300E500F80002000100000070014600000077014B0002000100030001000200030002000300050001000400050004800000010000000000000000000000000019000000040000000000000000000000010024000000000004000000000000000000000001003E000000000000000000003C4D6F64756C653E00535452494E475F4147472E646C6C00535452494E475F414747006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572006765745F526573756C74007365745F526573756C740053797374656D2E446174612E53716C54797065730053716C537472696E67006765745F536570617261746F72007365745F536570617261746F7200416464536570617261746F7200496E697400416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465003C526573756C743E6B5F5F4261636B696E674669656C64003C536570617261746F723E6B5F5F4261636B696E674669656C6400526573756C7400536570617261746F720076616C756500736570617261746F720067726F757000726561646572007772697465720053797374656D2E52756E74696D652E56657273696F6E696E67005461726765744672616D65776F726B417474726962757465002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E6400436F6D70696C657247656E657261746564417474726962757465006765745F4C656E677468006765745F56616C756500417070656E6400537472696E6700456D707479006765745F49734E756C6C006F705F496D706C69636974004F626A65637400546F537472696E6700417267756D656E744E756C6C457863657074696F6E0052656164537472696E67000000002F530065007200690061006C0069007A00650064002000440061007400610020006900730020004E0055004C004C000039530065007200690061006C0069007A006100740069006F006E00200057007200690074006500720020006900730020004E0055004C004C0000002A3B7DBE4C0C7D49A32C2ACB181F71C50008B77A5C561934E089042000120D05200101120D04200011110520010111110320000107200201111111110520010111080520010112150520010112190306120D03061111042800120D0428001111042001010E042001010205200101115504200101080520010111697301000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65FFFFFFFF540E044E616D650A535452494E475F4147470520010111710401000000032000080320000E052001120D0E040701111102060E0320000205000111110E052001120D1C4901001A2E4E45544672616D65776F726B2C56657273696F6E3D76342E350100540E144672616D65776F726B446973706C61794E616D65122E4E4554204672616D65776F726B20342E350F01000A535452494E475F414747000005010000000017010012436F7079726967687420C2A920203230313800002901002462383662336562612D376332332D343130302D626663332D63623765313238643330373200000C010007312E302E302E3000000801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000CDD45F5A00000000020000001C010000382D0000380F0000525344539056BBA08E79A14BBE41BC440F1FDF3A02000000633A5C55736572735C4265686D6F5C446F63756D656E74735C56697375616C2053747564696F20323031325C50726F6A656374735C535452494E475F4147475C535452494E475F4147475C6F626A5C52656C656173655C535452494E475F4147472E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007C2E000000000000000000009E2E0000002000000000000000000000000000000000000000000000902E00000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000C00200000000000000000000C00234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00420020000010053007400720069006E006700460069006C00650049006E0066006F000000FC010000010030003000300030003000340062003000000040000B000100460069006C0065004400650073006300720069007000740069006F006E000000000053005400520049004E0047005F0041004700470000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A900200020003200300031003800000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C000000000038000B000100500072006F0064007500630074004E0061006D0065000000000053005400520049004E0047005F0041004700470000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000B03E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE -
Jan 17, 2018 . 1 changed file with 23 additions and 21 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,22 +1,24 @@ DECLARE @ver nvarchar(128) = CAST(serverproperty('ProductVersion') AS nvarchar) SET @ver = SUBSTRING(@ver, 1, CHARINDEX('.', @ver) - 1) IF (@ver < 14) -- only until Server 2017 BEGIN IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'STRING_AGG') AND type = N'AF') DROP AGGREGATE [STRING_AGG] IF EXISTS(select 1 from sys.assemblies a WHERE name = N'STRING_AGG') DROP ASSEMBLY [STRING_AGG] CREATE ASSEMBLY [STRING_AGG] -- FROM ".\STRING_AGG.dll" FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300CDD45F5A0000000000000000E00002210B010B00001000000006000000000000AE2E0000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000542E000057000000004000001803000000000000000000000000000000000000006000000C0000001C2D00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B40E0000002000000010000000020000000000000000000000000000200000602E7273726300000018030000004000000004000000120000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001600000000000000000000000000004000004200000000000000000000000000000000902E0000000000004800000002000500C4210000580B000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E027B010000042A2202037D010000042A1E027B020000042A2202037D020000042A00001330020029000000010000110228010000066F1500000A16311A0228010000060228030000060A1200281600000A6F1700000A262A7202731800000A2802000006027E1900000A731A00000A28040000062A0000033002004000000000000000020F02281B00000A2D03042B0A7E1900000A281C00000A28040000060F01281B00000A2C012A0228050000060228010000060F01281600000A6F1700000A262AAA0F0128010000066F1500000A1631012A0228050000060228010000060F0128010000066F1D00000A262A460228010000066F1E00000A281C00000A2AC6032D0B7201000070731F00000A7A02036F2000000A732100000A280200000602036F2000000A731A00000A28040000062A00133002003400000001000011032D0B7231000070731F00000A7A030228010000066F1E00000A6F2200000A030228030000060A1200281600000A6F2200000A2A42534A4201000100000000000C00000076342E302E33303331390000000005006C000000C4030000237E000030040000BC04000023537472696E677300000000EC0800006C000000235553005809000010000000234755494400000068090000F001000023426C6F6200000000000000020000015717A2010900000000FA253300160000010000002000000002000000020000000B0000000700000001000000220000001500000001000000010000000200000004000000010000000200000000000A00010000000000060034002D000A0065004A000600820076000A00BB00A600060018010E0106002A010E010600BF01A5010600F001DE0106000702DE0106002402DE0106004302DE0106005C02DE0106007502DE0106009002DE010600AB02DE010600E302C4020600F702C40206000503DE0106001E03DE0106004E033B035300620300000600910371030600B10371030600CF032D000A00E5034A000A0006044A0006000D04C40206002304C40206002E047103060065042D00060089042D00060099042D000000000001000000000001000100092110001900000005000100010001003D013E00010055014200502000000000860890000A00010058200000000081089B000F0001006120000000008608C500150002006920000000008108D3001A0002007420000000008100E10020000300A920000000008600EE0020000300C820000000008600F300240003001421000000008600FE002C0005003F21000000008600040115000600512100000000E601250132000600842100000000E601370138000700000001008101000001008101000001008101000002008701000001009101000001009701000001009E01020009003900D80150004100D80150004900D80150005100D80150005900D80150006100D80150006900D80150007100D80150007900D80150008100D80155008900D80150009100D80150009900D8015000A100D8015A00B100D8016000B900D8012000C100D8012000C900D8016500D900D801DF00E900D801200019004904EA0021005404EE0019005E04F2001900D8012000F1006C04FD002100D801500021007204000121007D04040119005E040A01F9009004EE000101D80150002900AF04EE001900D80150003100370150002000A300E5002100A300E5002E0023006A012E002B006A012E0033005A012E007B00C8012E000B0010012E0013005A012E001B006A012E008300D1012E003B0070012E0043006A012E0053006A012E005B0088012E006B00B2012E007300BF014000A300E5004100A300E500430093006B006000A300E5008000A300E500F80002000100000070014600000077014B0002000100030001000200030002000300050001000400050004800000010000000000000000000000000019000000040000000000000000000000010024000000000004000000000000000000000001003E000000000000000000003C4D6F64756C653E00535452494E475F4147472E646C6C00535452494E475F414747006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572006765745F526573756C74007365745F526573756C740053797374656D2E446174612E53716C54797065730053716C537472696E67006765745F536570617261746F72007365745F536570617261746F7200416464536570617261746F7200496E697400416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465003C526573756C743E6B5F5F4261636B696E674669656C64003C536570617261746F723E6B5F5F4261636B696E674669656C6400526573756C7400536570617261746F720076616C756500736570617261746F720067726F757000726561646572007772697465720053797374656D2E52756E74696D652E56657273696F6E696E67005461726765744672616D65776F726B417474726962757465002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E6400436F6D70696C657247656E657261746564417474726962757465006765745F4C656E677468006765745F56616C756500417070656E6400537472696E6700456D707479006765745F49734E756C6C006F705F496D706C69636974004F626A65637400546F537472696E6700417267756D656E744E756C6C457863657074696F6E0052656164537472696E67000000002F530065007200690061006C0069007A00650064002000440061007400610020006900730020004E0055004C004C000039530065007200690061006C0069007A006100740069006F006E00200057007200690074006500720020006900730020004E0055004C004C0000002A3B7DBE4C0C7D49A32C2ACB181F71C50008B77A5C561934E089042000120D05200101120D04200011110520010111110320000107200201111111110520010111080520010112150520010112190306120D03061111042800120D0428001111042001010E042001010205200101115504200101080520010111697301000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65FFFFFFFF540E044E616D650A535452494E475F4147470520010111710401000000032000080320000E052001120D0E040701111102060E0320000205000111110E052001120D1C4901001A2E4E45544672616D65776F726B2C56657273696F6E3D76342E350100540E144672616D65776F726B446973706C61794E616D65122E4E4554204672616D65776F726B20342E350F01000A535452494E475F414747000005010000000017010012436F7079726967687420C2A920203230313800002901002462383662336562612D376332332D343130302D626663332D63623765313238643330373200000C010007312E302E302E3000000801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000CDD45F5A00000000020000001C010000382D0000380F0000525344539056BBA08E79A14BBE41BC440F1FDF3A02000000633A5C55736572735C4265686D6F5C446F63756D656E74735C56697375616C2053747564696F20323031325C50726F6A656374735C535452494E475F4147475C535452494E475F4147475C6F626A5C52656C656173655C535452494E475F4147472E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007C2E000000000000000000009E2E0000002000000000000000000000000000000000000000000000902E00000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000C00200000000000000000000C00234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00420020000010053007400720069006E006700460069006C00650049006E0066006F000000FC010000010030003000300030003000340062003000000040000B000100460069006C0065004400650073006300720069007000740069006F006E000000000053005400520049004E0047005F0041004700470000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A900200020003200300031003800000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C000000000038000B000100500072006F0064007500630074004E0061006D0065000000000053005400520049004E0047005F0041004700470000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000B03E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE CREATE AGGREGATE [STRING_AGG] (@value [nvarchar](max), @separator [nvarchar](max)) RETURNS [nvarchar](max) EXTERNAL NAME [STRING_AGG].[STRING_AGG] IF EXISTS(SELECT 1 FROM sys.configurations WHERE name = 'clr enabled' and value = 0) BEGIN EXEC sp_configure 'clr enabled', 1 RECONFIGURE END END -
Jan 17, 2018 . 2 changed files with 25 additions and 6 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -24,7 +24,10 @@ public struct STRING_AGG : IBinarySerialize /// Store the Separator /// </summary> public SqlString Separator { get; private set; } /// <summary> /// Appends the Separator if necessary /// </summary> private void AddSeparator() { if (Result.Length > 0) @@ -40,6 +43,9 @@ public void Init() Separator = new SqlString(string.Empty); } /// <summary> /// Stores separator in instance and appends value to the Result /// </summary> public void Accumulate(SqlString value, SqlString separator) { Separator = separator.IsNull ? string.Empty : separator; @@ -63,9 +69,9 @@ public void Merge(STRING_AGG group) Result.Append(group.Result); } /// <summary> /// Completes the aggregate and returns the SqlString /// </summary> public SqlString Terminate() { //return new SqlString(_intermediateResult == null ? string.Empty : _intermediateResult.ToString()); This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,9 +1,22 @@ IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'STRING_AGG') AND type = N'AF') DROP AGGREGATE [STRING_AGG] IF EXISTS(select 1 from sys.assemblies a WHERE name = 'STRING_AGG') DROP ASSEMBLY [STRING_AGG] CREATE ASSEMBLY [STRING_AGG] -- FROM '.\STRING_AGG.dll' FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300CDD45F5A0000000000000000E00002210B010B00001000000006000000000000AE2E0000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000542E000057000000004000001803000000000000000000000000000000000000006000000C0000001C2D00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B40E0000002000000010000000020000000000000000000000000000200000602E7273726300000018030000004000000004000000120000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001600000000000000000000000000004000004200000000000000000000000000000000902E0000000000004800000002000500C4210000580B000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E027B010000042A2202037D010000042A1E027B020000042A2202037D020000042A00001330020029000000010000110228010000066F1500000A16311A0228010000060228030000060A1200281600000A6F1700000A262A7202731800000A2802000006027E1900000A731A00000A28040000062A0000033002004000000000000000020F02281B00000A2D03042B0A7E1900000A281C00000A28040000060F01281B00000A2C012A0228050000060228010000060F01281600000A6F1700000A262AAA0F0128010000066F1500000A1631012A0228050000060228010000060F0128010000066F1D00000A262A460228010000066F1E00000A281C00000A2AC6032D0B7201000070731F00000A7A02036F2000000A732100000A280200000602036F2000000A731A00000A28040000062A00133002003400000001000011032D0B7231000070731F00000A7A030228010000066F1E00000A6F2200000A030228030000060A1200281600000A6F2200000A2A42534A4201000100000000000C00000076342E302E33303331390000000005006C000000C4030000237E000030040000BC04000023537472696E677300000000EC0800006C000000235553005809000010000000234755494400000068090000F001000023426C6F6200000000000000020000015717A2010900000000FA253300160000010000002000000002000000020000000B0000000700000001000000220000001500000001000000010000000200000004000000010000000200000000000A00010000000000060034002D000A0065004A000600820076000A00BB00A600060018010E0106002A010E010600BF01A5010600F001DE0106000702DE0106002402DE0106004302DE0106005C02DE0106007502DE0106009002DE010600AB02DE010600E302C4020600F702C40206000503DE0106001E03DE0106004E033B035300620300000600910371030600B10371030600CF032D000A00E5034A000A0006044A0006000D04C40206002304C40206002E047103060065042D00060089042D00060099042D000000000001000000000001000100092110001900000005000100010001003D013E00010055014200502000000000860890000A00010058200000000081089B000F0001006120000000008608C500150002006920000000008108D3001A0002007420000000008100E10020000300A920000000008600EE0020000300C820000000008600F300240003001421000000008600FE002C0005003F21000000008600040115000600512100000000E601250132000600842100000000E601370138000700000001008101000001008101000001008101000002008701000001009101000001009701000001009E01020009003900D80150004100D80150004900D80150005100D80150005900D80150006100D80150006900D80150007100D80150007900D80150008100D80155008900D80150009100D80150009900D8015000A100D8015A00B100D8016000B900D8012000C100D8012000C900D8016500D900D801DF00E900D801200019004904EA0021005404EE0019005E04F2001900D8012000F1006C04FD002100D801500021007204000121007D04040119005E040A01F9009004EE000101D80150002900AF04EE001900D80150003100370150002000A300E5002100A300E5002E0023006A012E002B006A012E0033005A012E007B00C8012E000B0010012E0013005A012E001B006A012E008300D1012E003B0070012E0043006A012E0053006A012E005B0088012E006B00B2012E007300BF014000A300E5004100A300E500430093006B006000A300E5008000A300E500F80002000100000070014600000077014B0002000100030001000200030002000300050001000400050004800000010000000000000000000000000019000000040000000000000000000000010024000000000004000000000000000000000001003E000000000000000000003C4D6F64756C653E00535452494E475F4147472E646C6C00535452494E475F414747006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572006765745F526573756C74007365745F526573756C740053797374656D2E446174612E53716C54797065730053716C537472696E67006765745F536570617261746F72007365745F536570617261746F7200416464536570617261746F7200496E697400416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465003C526573756C743E6B5F5F4261636B696E674669656C64003C536570617261746F723E6B5F5F4261636B696E674669656C6400526573756C7400536570617261746F720076616C756500736570617261746F720067726F757000726561646572007772697465720053797374656D2E52756E74696D652E56657273696F6E696E67005461726765744672616D65776F726B417474726962757465002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E6400436F6D70696C657247656E657261746564417474726962757465006765745F4C656E677468006765745F56616C756500417070656E6400537472696E6700456D707479006765745F49734E756C6C006F705F496D706C69636974004F626A65637400546F537472696E6700417267756D656E744E756C6C457863657074696F6E0052656164537472696E67000000002F530065007200690061006C0069007A00650064002000440061007400610020006900730020004E0055004C004C000039530065007200690061006C0069007A006100740069006F006E00200057007200690074006500720020006900730020004E0055004C004C0000002A3B7DBE4C0C7D49A32C2ACB181F71C50008B77A5C561934E089042000120D05200101120D04200011110520010111110320000107200201111111110520010111080520010112150520010112190306120D03061111042800120D0428001111042001010E042001010205200101115504200101080520010111697301000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65FFFFFFFF540E044E616D650A535452494E475F4147470520010111710401000000032000080320000E052001120D0E040701111102060E0320000205000111110E052001120D1C4901001A2E4E45544672616D65776F726B2C56657273696F6E3D76342E350100540E144672616D65776F726B446973706C61794E616D65122E4E4554204672616D65776F726B20342E350F01000A535452494E475F414747000005010000000017010012436F7079726967687420C2A920203230313800002901002462383662336562612D376332332D343130302D626663332D63623765313238643330373200000C010007312E302E302E3000000801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000CDD45F5A00000000020000001C010000382D0000380F0000525344539056BBA08E79A14BBE41BC440F1FDF3A02000000633A5C55736572735C4265686D6F5C446F63756D656E74735C56697375616C2053747564696F20323031325C50726F6A656374735C535452494E475F4147475C535452494E475F4147475C6F626A5C52656C656173655C535452494E475F4147472E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007C2E000000000000000000009E2E0000002000000000000000000000000000000000000000000000902E00000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000C00200000000000000000000C00234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00420020000010053007400720069006E006700460069006C00650049006E0066006F000000FC010000010030003000300030003000340062003000000040000B000100460069006C0065004400650073006300720069007000740069006F006E000000000053005400520049004E0047005F0041004700470000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A900200020003200300031003800000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C000000000038000B000100500072006F0064007500630074004E0061006D0065000000000053005400520049004E0047005F0041004700470000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000B03E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE GO CREATE AGGREGATE [STRING_AGG] (@value [nvarchar](max), @separator [nvarchar](max)) RETURNS [nvarchar](max) EXTERNAL NAME [STRING_AGG].[STRING_AGG] GO IF EXISTS(SELECT 1 FROM sys.configurations WHERE name = 'clr enabled' and value = 0) BEGIN exec sp_configure 'clr enabled', 1 RECONFIGURE END GO -
Jan 17, 2018 . 2 changed files with 2 additions and 2 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -5,7 +5,7 @@ using Microsoft.SqlServer.Server; [Serializable] [SqlUserDefinedAggregate( Format.UserDefined, IsInvariantToNulls = true, IsInvariantToDuplicates = false, This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,5 +1,5 @@ CREATE ASSEMBLY [STRING_AGG] FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300A8CA5F5A0000000000000000E00002210B010B00001000000006000000000000AE2E0000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000542E000057000000004000001803000000000000000000000000000000000000006000000C0000001C2D00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B40E0000002000000010000000020000000000000000000000000000200000602E7273726300000018030000004000000004000000120000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001600000000000000000000000000004000004200000000000000000000000000000000902E0000000000004800000002000500C4210000580B000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E027B010000042A2202037D010000042A1E027B020000042A2202037D020000042A00001330020029000000010000110228010000066F1500000A16311A0228010000060228030000060A1200281600000A6F1700000A262A7202731800000A2802000006027E1900000A731A00000A28040000062A0000033002004000000000000000020F02281B00000A2D03042B0A7E1900000A281C00000A28040000060F01281B00000A2C012A0228050000060228010000060F01281600000A6F1700000A262AAA0F0128010000066F1500000A1631012A0228050000060228010000060F0128010000066F1D00000A262A460228010000066F1E00000A281C00000A2AC6032D0B7201000070731F00000A7A02036F2000000A732100000A280200000602036F2000000A731A00000A28040000062A00133002003400000001000011032D0B7231000070731F00000A7A030228010000066F1E00000A6F2200000A030228030000060A1200281600000A6F2200000A2A42534A4201000100000000000C00000076342E302E33303331390000000005006C000000C4030000237E000030040000BC04000023537472696E677300000000EC0800006C000000235553005809000010000000234755494400000068090000F001000023426C6F6200000000000000020000015717A2010900000000FA253300160000010000002000000002000000020000000B0000000700000001000000220000001500000001000000010000000200000004000000010000000200000000000A00010000000000060034002D000A0065004A000600820076000A00BB00A600060018010E0106002A010E010600BF01A5010600F001DE0106000702DE0106002402DE0106004302DE0106005C02DE0106007502DE0106009002DE010600AB02DE010600E302C4020600F702C40206000503DE0106001E03DE0106004E033B035300620300000600910371030600B10371030600CF032D000A00E5034A000A0006044A0006000D04C40206002304C40206002E047103060065042D00060089042D00060099042D000000000001000000000001000100092110001900000005000100010001003D013E00010055014200502000000000860890000A00010058200000000081089B000F0001006120000000008608C500150002006920000000008108D3001A0002007420000000008100E10020000300A920000000008600EE0020000300C820000000008600F300240003001421000000008600FE002C0005003F21000000008600040115000600512100000000E601250132000600842100000000E601370138000700000001008101000001008101000001008101000002008701000001009101000001009701000001009E01020009003900D80150004100D80150004900D80150005100D80150005900D80150006100D80150006900D80150007100D80150007900D80150008100D80155008900D80150009100D80150009900D8015000A100D8015A00B100D8016000B900D8012000C100D8012000C900D8016500D900D801DF00E900D801200019004904EA0021005404EE0019005E04F2001900D8012000F1006C04FD002100D801500021007204000121007D04040119005E040A01F9009004EE000101D80150002900AF04EE001900D80150003100370150002000A300E5002100A300E5002E0023006A012E002B006A012E0033005A012E007B00C8012E000B0010012E0013005A012E001B006A012E008300D1012E003B0070012E0043006A012E0053006A012E005B0088012E006B00B2012E007300BF014000A300E5004100A300E500430093006B006000A300E5008000A300E500F80002000100000070014600000077014B0002000100030001000200030002000300050001000400050004800000010000000000000000000000000019000000040000000000000000000000010024000000000004000000000000000000000001003E000000000000000000003C4D6F64756C653E00535452494E475F4147472E646C6C00535452494E475F414747006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572006765745F526573756C74007365745F526573756C740053797374656D2E446174612E53716C54797065730053716C537472696E67006765745F536570617261746F72007365745F536570617261746F7200416464536570617261746F7200496E697400416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465003C526573756C743E6B5F5F4261636B696E674669656C64003C536570617261746F723E6B5F5F4261636B696E674669656C6400526573756C7400536570617261746F720076616C756500736570617261746F720067726F757000726561646572007772697465720053797374656D2E52756E74696D652E56657273696F6E696E67005461726765744672616D65776F726B417474726962757465002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E6400436F6D70696C657247656E657261746564417474726962757465006765745F4C656E677468006765745F56616C756500417070656E6400537472696E6700456D707479006765745F49734E756C6C006F705F496D706C69636974004F626A65637400546F537472696E6700417267756D656E744E756C6C457863657074696F6E0052656164537472696E67000000002F530065007200690061006C0069007A00650064002000440061007400610020006900730020004E0055004C004C000039530065007200690061006C0069007A006100740069006F006E00200057007200690074006500720020006900730020004E0055004C004C000000B459DA0ADFE1B44C9F5F655E1CCB3BF70008B77A5C561934E089042000120D05200101120D04200011110520010111110320000107200201111111110520010111080520010112150520010112190306120D03061111042800120D0428001111042001010E042001010205200101115504200101080520010111697301000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65FFFFFFFF540E044E616D650A535452494E475F4147470520010111710401000000032000080320000E052001120D0E040701111102060E0320000205000111110E052001120D1C4901001A2E4E45544672616D65776F726B2C56657273696F6E3D76342E350100540E144672616D65776F726B446973706C61794E616D65122E4E4554204672616D65776F726B20342E350F01000A535452494E475F414747000005010000000017010012436F7079726967687420C2A920203230313800002901002462383662336562612D376332332D343130302D626663332D63623765313238643330373200000C010007312E302E302E3000000801000200000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000A8CA5F5A00000000020000001C010000382D0000380F0000525344531E84613F7BE7734C8A43D35C469DDC1801000000633A5C55736572735C4265686D6F5C446F63756D656E74735C56697375616C2053747564696F20323031325C50726F6A656374735C535452494E475F4147475C535452494E475F4147475C6F626A5C52656C656173655C535452494E475F4147472E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007C2E000000000000000000009E2E0000002000000000000000000000000000000000000000000000902E00000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000C00200000000000000000000C00234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00420020000010053007400720069006E006700460069006C00650049006E0066006F000000FC010000010030003000300030003000340062003000000040000B000100460069006C0065004400650073006300720069007000740069006F006E000000000053005400520049004E0047005F0041004700470000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A900200020003200300031003800000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C000000000038000B000100500072006F0064007500630074004E0061006D0065000000000053005400520049004E0047005F0041004700470000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000B03E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE GO -
Jan 17, 2018 . 2 changed files with 37 additions and 28 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,29 +1,9 @@ CREATE ASSEMBLY [STRING_AGG] FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006CC85F5A0000000000000000E00002210B010B000010000000060000000000003E2F0000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000E42E000057000000004000001803000000000000000000000000000000000000006000000C000000AC2D00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000440F0000002000000010000000020000000000000000000000000000200000602E7273726300000018030000004000000004000000120000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001600000000000000000000000000004000004200000000000000000000000000000000202F0000000000004800000002000500402200006C0B00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133001000B00000001000011027B010000040A2B00062A2202037D010000042A133001000B00000002000011027B020000040A2B00062A2202037D020000042A133002003100000003000011000228010000066F1500000A16FE0216FE010A062D1A0228010000060228030000060B1201281600000A6F1700000A262A7E0002731800000A280200000600027E1900000A731A00000A2804000006002A000000133002004A0000000400001100020F02281B00000A2D03042B0A7E1900000A281C00000A002804000006000F01281B00000A16FE010A062D022B1A022805000006000228010000060F01281600000A6F1700000A262A0000133002003400000004000011000F0128010000066F1500000A16FE0216FE010A062D022B1A022805000006000228010000060F0128010000066F1D00000A262A133001001600000002000011000228010000066F1E00000A281C00000A0A2B00062A0000133002003C00000004000011000314FE0116FE010A062D0B7201000070731F00000A7A02036F2000000A732100000A28020000060002036F2000000A731A00000A2804000006002A133002003F00000003000011000314FE0116FE010A062D0B7231000070731F00000A7A030228010000066F1E00000A6F2200000A00030228030000060B1201281600000A6F2200000A002A0042534A4201000100000000000C00000076342E302E33303331390000000005006C000000C8030000237E000034040000BC04000023537472696E677300000000F00800006C000000235553005C0900001000000023475549440000006C0900000002000023426C6F6200000000000000020000015717A2010900000000FA253300160000010000002000000002000000020000000B0000000700000001000000220000001500000004000000010000000200000004000000010000000200000000000A00010000000000060034002D000A0065004A000600820076000A00BB00A600060018010E0106002A010E010600BF01A5010600F001DE0106000702DE0106002402DE0106004302DE0106005C02DE0106007502DE0106009002DE010600AB02DE010600E302C4020600F702C40206000503DE0106001E03DE0106004E033B035300620300000600910371030600B10371030600CF032D000A00E5034A000A0006044A0006000D04C40206002304C40206002E047103060065042D00060089042D00060099042D000000000001000000000001000100092110001900000005000100010001003D013E00010055014200502000000000860890000A00010067200000000081089B000F0001007020000000008608C500150002008720000000008108D3001A0002009020000000008100E10020000300CD20000000008600EE0020000300F020000000008600F300240003004821000000008600FE002C0005008821000000008600040115000600AC2100000000E601250132000600F42100000000E601370138000700000001008101000001008101000001008101000002008701000001009101000001009701000001009E01020009003900D80150004100D80150004900D80150005100D80150005900D80150006100D80150006900D80150007100D80150007900D80150008100D80155008900D80150009100D80150009900D8015000A100D8015A00B100D8016000B900D8012000C100D8012000C900D8016500D900D801DF00E900D801200019004904F40021005404F80019005E04FC001900D8012000F1006C0408012100D8015000210072040B0121007D040F0119005E041901F9009004F8000101D80150002900AF04F8001900D80150003100370150002000A300E5002100A300E5002E00230079012E002B0079012E00330069012E007B00D7012E000B001F012E00130069012E001B0079012E008300E0012E003B007F012E00430079012E00530079012E005B0097012E006B00C1012E007300CE014000A300E5004100A300E500430093006B006000A300E5008000A300E500EA00EF000201150102000100000070014600000077014B0002000100030001000200030002000300050001000400050004800000010000000000000000000000000019000000040000000000000000000000010024000000000004000000000000000000000001003E00000000000000003C4D6F64756C653E00535452494E475F4147472E646C6C00535452494E475F414747006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572006765745F526573756C74007365745F526573756C740053797374656D2E446174612E53716C54797065730053716C537472696E67006765745F536570617261746F72007365745F536570617261746F7200416464536570617261746F7200496E697400416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465003C526573756C743E6B5F5F4261636B696E674669656C64003C536570617261746F723E6B5F5F4261636B696E674669656C6400526573756C7400536570617261746F720076616C756500736570617261746F720067726F757000726561646572007772697465720053797374656D2E52756E74696D652E56657273696F6E696E67005461726765744672616D65776F726B417474726962757465002E63746F720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E6400436F6D70696C657247656E657261746564417474726962757465006765745F4C656E677468006765745F56616C756500417070656E6400537472696E6700456D707479006765745F49734E756C6C006F705F496D706C69636974004F626A65637400546F537472696E6700417267756D656E744E756C6C457863657074696F6E0052656164537472696E67000000002F530065007200690061006C0069007A00650064002000440061007400610020006900730020004E0055004C004C000039530065007200690061006C0069007A006100740069006F006E00200057007200690074006500720020006900730020004E0055004C004C00000012961F8410BAB74CBA5212438E830D240008B77A5C561934E089042000120D05200101120D04200011110520010111110320000107200201111111110520010111080520010112150520010112190306120D03061111042800120D0428001111042001010E042001010205200101115504200101080520010111697301000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65FFFFFFFF540E044E616D650A535452494E475F4147470520010111710401000000040701120D0407011111032000080320000E052001120D0E05070202111102060E0320000205000111110E03070102052001120D1C4901001A2E4E45544672616D65776F726B2C56657273696F6E3D76342E350100540E144672616D65776F726B446973706C61794E616D65122E4E4554204672616D65776F726B20342E350F01000A535452494E475F414747000005010000000017010012436F7079726967687420C2A920203230313800002901002462383662336562612D376332332D343130302D626663332D63623765313238643330373200000C010007312E302E302E3000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000006CC85F5A00000000020000001C010000C82D0000C80F000052534453DF3B2B01FC7E574094E87416E24F8CB20D000000633A5C55736572735C4265686D6F5C446F63756D656E74735C56697375616C2053747564696F20323031325C50726F6A656374735C535452494E475F4147475C535452494E475F4147475C6F626A5C44656275675C535452494E475F4147472E70646200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C2F000000000000000000002E2F0000002000000000000000000000000000000000000000000000202F00000000000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500200010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000C00200000000000000000000C00234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00420020000010053007400720069006E006700460069006C00650049006E0066006F000000FC010000010030003000300030003000340062003000000040000B000100460069006C0065004400650073006300720069007000740069006F006E000000000053005400520049004E0047005F0041004700470000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000040000F00010049006E007400650072006E0061006C004E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A900200020003200300031003800000048000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000053005400520049004E0047005F004100470047002E0064006C006C000000000038000B000100500072006F0064007500630074004E0061006D0065000000000053005400520049004E0047005F0041004700470000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000403F00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE GO CREATE AGGREGATE [dbo].STRING_AGG (@value [nvarchar](max), @separator [nvarchar](max)) RETURNS [nvarchar](max) EXTERNAL NAME [STRING_AGG].[STRING_AGG] GO This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,29 @@ create table #test( id int identity(1,1) not null primary key , class tinyint not null , name nvarchar(120) not null ) insert into #test values (1, N'This'), (1, N'is'), (1, N'just'), (1, N'a'), (1, N'test'), (2, N','), (3, N'do'), (3, N'not'), (3, N'be'), (3, N'alarmed'), (3, N','), (3, N'this'), (3, N'is'), (3, N'just'), (3, N'a'), (3, N'test') select class, dbo.STRING_AGG(name, ' ') from #test group by class drop table #test -
Jan 17, 2018 . 2 changed files with 69 additions and 43 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -5,71 +5,98 @@ using Microsoft.SqlServer.Server; [Serializable] [Microsoft.SqlServer.Server.SqlUserDefinedAggregate( Format.UserDefined, IsInvariantToNulls = true, IsInvariantToDuplicates = false, IsInvariantToOrder = false, MaxByteSize = -1, Name = "STRING_AGG" )] public struct STRING_AGG : IBinarySerialize { /// <summary> /// Stores the concatenated string /// </summary> public StringBuilder Result { get; private set; } /// <summary> /// Store the Separator /// </summary> public SqlString Separator { get; private set; } private void AddSeparator() { if (Result.Length > 0) Result.Append(Separator.Value); } /// <summary> /// Initializes values for each group /// </summary> public void Init() { Result = new StringBuilder(); Separator = new SqlString(string.Empty); } public void Accumulate(SqlString value, SqlString separator) { Separator = separator.IsNull ? string.Empty : separator; if (value.IsNull) return; AddSeparator(); Result.Append(value.Value); } /// <summary> /// Is called when parallelism is involved /// </summary> public void Merge(STRING_AGG group) { if (group.Result.Length > 0) return; AddSeparator(); Result.Append(group.Result); } /* Terminate * Completes the aggregate and returns the SqlString */ public SqlString Terminate() { //return new SqlString(_intermediateResult == null ? string.Empty : _intermediateResult.ToString()); return Result.ToString(); } #region IBinarySerialize /// <summary> /// Reads the values from the serialized stream /// </summary> /// <param name="reader">The BinaryReader</param> public void Read(BinaryReader reader) { if (reader == null) throw new ArgumentNullException("Serialized Data is NULL"); Result = new StringBuilder(reader.ReadString()); Separator = new SqlString(reader.ReadString()); } /// <summary> /// Writes the values to the stream in order to be stored in serialized form /// </summary> /// <param name="writer">The BinaryWriter</param> public void Write(BinaryWriter writer) { if (writer == null) throw new ArgumentNullException("Serialization Writer is NULL"); writer.Write(Result.ToString()); writer.Write(Separator.Value); } #endregion IBinarySerialize } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,10 +1,10 @@ create table #test( id int identity(1,1) not null primary key , class tinyint not null , name nvarchar(120) not null ) insert into #test values (1, N'This'), (1, N'is'), (1, N'just'), @@ -22,9 +22,8 @@ insert into test values (3, N'a'), (3, N'test') select class, dbo.STRING_AGG(name, ' ') from #test group by class drop table #test -
Jan 17, 2018 . 3 changed files with 19 additions and 19 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,11 +0,0 @@ This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -5,11 +5,12 @@ using Microsoft.SqlServer.Server; [Serializable] [SqlUserDefinedAggregate(Format.UserDefined, IsInvariantToNulls = true, IsInvariantToDuplicates = false, IsInvariantToOrder = false, MaxByteSize = 8000, Name = "STRING_AGG")] public class STRING_AGG : IBinarySerialize { private String _separator; private StringBuilder _intermediateResult; internal string IntermediateResult { get { @@ -22,17 +23,27 @@ public void Init() _intermediateResult = new StringBuilder(); } public void Accumulate(SqlString value, SqlString separator) { if (value.IsNull) return; _separator = separator.IsNull ? string.Empty : separator.Value; if (_intermediateResult.Length > 0) _intermediateResult.Append(_separator); _intermediateResult.Append(value.Value); } public void Merge(STRING_AGG other) { if (null == other) return; if (_intermediateResult.Length > 0) _intermediateResult.Append(_separator); _intermediateResult.Append(other._intermediateResult); } @@ -61,4 +72,4 @@ public void Write(BinaryWriter writer) writer.Write(_intermediateResult.ToString()); } } This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -23,7 +23,7 @@ insert into test values (3, N'test') select dbo.STRING_AGG(name, CHAR(13)) from test group by class -
FilipDeVos revised this gist
Sep 30, 2014 . 1 changed file with 30 additions and 0 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,30 @@ create table test( id int identity(1,1) not null primary key , class tinyint not null , name nvarchar(120) not null ) insert into test values (1, N'This'), (1, N'is'), (1, N'just'), (1, N'a'), (1, N'test'), (2, N','), (3, N'do'), (3, N'not'), (3, N'be'), (3, N'alarmed'), (3, N','), (3, N'this'), (3, N'is'), (3, N'just'), (3, N'a'), (3, N'test') select dbo.Concatenate(name + ' ') from test group by class drop table test -
Sep 30, 2014 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,11 @@ -- This script deploys the dbo.Concatenate() aggregate function on SQL Server. This is compiled from the code Concatenate.cs below. CREATE ASSEMBLY [concat] FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300E3EE2A540000000000000000E00002210B010B00000C00000006000000000000AE2B0000002000000040000000000010002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000602B00004B000000004000009003000000000000000000000000000000000000006000000C000000282A00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B40B000000200000000C000000020000000000000000000000000000200000602E72737263000000900300000040000000040000000E0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001200000000000000000000000000004000004200000000000000000000000000000000902B0000000000004800000002000500B421000074080000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013300100110000000100001100027B010000046F0E00000A0A2B00062A360002730F00000A7D010000042A00133002002500000002000011000F01281000000A16FE010A062D022B13027B010000040F01281100000A6F1200000A262A000000133002002100000002000011001403FE0116FE010A062D022B12027B01000004037B010000046F1300000A262A000000133004004D00000003000011007E1400000A0A027B010000042C13027B010000046F1500000A16FE0216FE012B0117000C082D1A027B0100000416027B010000046F1500000A17596F1600000A0A06731700000A0B2B00072A000000133002002900000002000011000314FE0116FE010A062D0B7201000070731800000A7A02036F1900000A731A00000A7D010000042A000000133002002A00000002000011000314FE0116FE010A062D0B720F000070731800000A7A03027B010000046F0E00000A6F1B00000A002A1E02281C00000A2A000042534A4201000100000000000C00000076322E302E35303732370000000005006C000000D8020000237E0000440300007803000023537472696E677300000000BC0600002000000023555300DC060000100000002347554944000000EC0600008801000023426C6F6200000000000000020000015717A2010900000000FA253300160000010000001700000002000000010000000800000004000000010000001C0000000B00000003000000010000000100000001000000010000000200000000000A00010000000000060031002A000A005F00440006007C0070000A00CF00BA000600FE00F40006001001F40006006801560106007F01560106009C0156010600B50156010600CE0156010600E901560106000202560106001F025601060051023E023F00650200000600940274020600B40274020600D9022A000A00EF0244000A001003440006003C032A00060054032A000000000001000000000001000100012010001500000005000100010001008A000A0050200000000083089E000E0001006D20000000008600B500120001007C20000000008600D90016000100B020000000008600E4001C000200E020000000008600EA00220003003C2100000000E6010B0127000300742100000000E6011D012D000400AA21000000008618230112000500000001003C01000001004201000001004801000001004F0102000900390023013700410023013700490023013700510023013700590023013700610023013700690023013700710023013700790023013C00890023014200910023011200990023011200A10023014700090017030E0019002301120021002003C60021002B030E0019003503CA0019003503D400B1004303DA0019004903DD0019001703E100210023013700B9002301370029006A030E0019002301370031001D0137000900230112002E002B002D012E005B0066012E001300FA002E001B002D012E002300EE002E000B00EE002E003B003C012E00430049012E004B0054012E0053005D0143006B004D00C200D000E70002000100000029013300020001000300048000000100000000000000000000000000D20200000200000000000000000000000100210000000000020000000000000000000000010038000000000000000000003C4D6F64756C653E00636F6E6361742E646C6C00436F6E636174656E617465006D73636F726C69620053797374656D004F626A6563740053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E5465787400537472696E674275696C646572005F696E7465726D656469617465526573756C74006765745F496E7465726D656469617465526573756C7400496E69740053797374656D2E446174612E53716C54797065730053716C537472696E6700416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465002E63746F7200496E7465726D656469617465526573756C740076616C7565006F7468657200726561646572007772697465720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500636F6E6361740053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D617400546F537472696E67006765745F49734E756C6C006765745F56616C756500417070656E6400537472696E6700456D707479006765745F4C656E67746800417267756D656E744E756C6C457863657074696F6E0052656164537472696E6700000000000D720065006100640065007200000D7700720069007400650072000000000049F527D6E78DF44B9985349EF50A43450008B77A5C561934E0890306120D0320000E0320000105200101111105200101120804200011110520010112150520010112190328000E042001010E05200101114104200101080520010111557401000200000005005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F0000540E044E616D650B436F6E636174656E6174650307010E03200002052001120D0E03070102052001120D1C02060E032000080520020E08080607030E1111020B010006636F6E63617400003201002D412053514C205365727665722041676772656761746520746F20636F6E636174656E61746520737472696E677300000E010009466F78547269636B7300000C010007312E302E302E3000000A010005446562756700000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000000000E3EE2A5400000000020000001C010000442A0000440C00005253445349772B2144A9E0409A276A1BD7102D4202000000633A5C55736572735C66696C69702E6465766F735C446F63756D656E74735C436F64655C74726173685C636F6E6361745C636F6E6361745C6F626A5C44656275675C636F6E6361742E70646200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000882B000000000000000000009E2B0000002000000000000000000000000000000000000000000000902B00000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000380300000000000000000000380334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00498020000010053007400720069006E006700460069006C00650049006E0066006F00000074020000010030003000300030003000340062003000000074002E00010043006F006D006D0065006E0074007300000041002000530051004C0020005300650072007600650072002000410067006700720065006700610074006500200074006F00200063006F006E0063006100740065006E00610074006500200073007400720069006E0067007300000034000A00010043006F006D00700061006E0079004E0061006D0065000000000046006F00780054007200690063006B0073000000380007000100460069006C0065004400650073006300720069007000740069006F006E000000000063006F006E0063006100740000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000038000B00010049006E007400650072006E0061006C004E0061006D006500000063006F006E006300610074002E0064006C006C000000000038000A0001004C006500670061006C0043006F007000790072006900670068007400000046006F00780054007200690063006B007300000040000B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000063006F006E006300610074002E0064006C006C0000000000300007000100500072006F0064007500630074004E0061006D0065000000000063006F006E0063006100740000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000B03B00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 WITH PERMISSION_SET = SAFE GO CREATE AGGREGATE [dbo].[Concatenate] (@value [nvarchar](max)) RETURNS [nvarchar](max) EXTERNAL NAME [concat].[Concatenate] GO This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,64 @@ using System; using System.Data.SqlTypes; using System.IO; using System.Text; using Microsoft.SqlServer.Server; [Serializable] [SqlUserDefinedAggregate(Format.UserDefined, IsInvariantToNulls = true, IsInvariantToDuplicates = false, IsInvariantToOrder = false, MaxByteSize = 8000, Name = "Concatenate")] public class Concatenate : IBinarySerialize { private StringBuilder _intermediateResult; internal string IntermediateResult { get { return _intermediateResult.ToString(); } } public void Init() { _intermediateResult = new StringBuilder(); } public void Accumulate(SqlString value) { if (value.IsNull) return; _intermediateResult.Append(value.Value); } public void Merge(Concatenate other) { if (null == other) return; _intermediateResult.Append(other._intermediateResult); } public SqlString Terminate() { var output = string.Empty; if (_intermediateResult != null && _intermediateResult.Length > 0) output = _intermediateResult.ToString(0, _intermediateResult.Length - 1); return new SqlString(output); } public void Read(BinaryReader reader) { if (reader == null) throw new ArgumentNullException("reader"); _intermediateResult = new StringBuilder(reader.ReadString()); } public void Write(BinaryWriter writer) { if (writer == null) throw new ArgumentNullException("writer"); writer.Write(_intermediateResult.ToString()); } }