CREATE ASSEMBLY [LCSAssembly]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103007BD8C7670000000000000000E00002210B010800000800000006000000000000AE260000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000602600004B000000004000009002000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B4060000002000000008000000020000000000000000000000000000200000602E72737263000000900200000040000000040000000A0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000E00000000000000000000000000004000004200000000000000000000000000000000902600000000000048000000020005004022000020040000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013300800D901000001000011000F00280400000A2D0C0F01280400000A16FE012B0116130B110B2D0C7E0500000A130A38AD0100000F00280600000A178D06000001130C110C161F2C9D110C6F0700000A0A0F01280600000A178D06000001130C110C161F2C9D110C6F0700000A0B068E690C078E690D081758091758730800000A13041713053885000000001713062B6A0006110517599A07110617599A280900000A16FE01130B110B2D1E11041105110611041105175911061759280A00000A1758280B00000A2B2A1104110511061104110517591106280A00000A1104110511061759280A00000A280C00000A280B00000A00110617581306110609FE0216FE01130B110B2D8800110517581305110508FE0216FE01130B110B3A6AFFFFFF08130709130872010000701309388D0000000006110717599A07110817599A280900000A16FE01130B110B2D3E0006110717599A11097201000070280900000A2D0E72030000701109280D00000A2B057201000070280D00000A1309110717591307110817591308002B331104110717591108280A00000A1104110711081759280A00000AFE0216FE01130B110B2D081107175913072B06110817591308001107163107110816FE022B0116130B110B3A5DFFFFFF1109730E00000A130A2B00110A2A1E02280F00000A2A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C00000074010000237E0000E00100006001000023537472696E6773000000004003000008000000235553004803000010000000234755494400000058030000C800000023426C6F620000000000000002000001471502080900000000FA01330016000001000000080000000200000002000000020000000F000000030000000100000001000000010000000200000000000A0001000000000006002E0027000A005600410006009C007C000600BC007C000A00F900DE0006002801270006002D01270006004E01270000000000010000000000010001000100100012000000050001000100502000000000960060000A00010035220000000086186C001300030000000100720000000200770019006C00170021006C00130029006C00130011000E01410011001901450011001E014900390034014D000C006C005C0039003A0162000C00460168000C004A016E00410053017500390057017B0011006C00810009006C00130020001B001C002E000B00A0002E001300A90086005400048000000000000000000000000000000000DA00000002000000000000000000000001001E0000000000020000000000000000000000010035000000000000000000003C4D6F64756C653E006C63732E646C6C004C435346756E6374696F6E006D73636F726C69620053797374656D004F626A6563740053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E67004C637353657175656E6365002E63746F72007365713100736571320053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006C6373004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E417474726962757465006765745F49734E756C6C004E756C6C006765745F56616C7565004368617200537472696E670053706C6974006F705F457175616C6974790047657400536574004D617468004D617800436F6E636174000000000100032C000000F7D4419E10F18E4DA0EABD7E2DB4B3CD0008B77A5C561934E089080002110911091109032000010420010108240100020054020F497344657465726D696E6973746963015402094973507265636973650103200002030611090320000E0620011D0E1D030714080200020000052002010808050002020E0E052002080808062003010808080500020808080500020E0E0E042001010E19070D1D0E1D0E080814080200020000080808080E1109021D030801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773018826000000000000000000009E260000002000000000000000000000000000000000000000000000902600000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000340200000000000000000000340234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00494010000010053007400720069006E006700460069006C00650049006E0066006F0000007001000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000030000800010049006E007400650072006E0061006C004E0061006D00650000006C00630073002E0064006C006C0000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000003800080001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000006C00630073002E0064006C006C000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E0030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000B03600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = UNSAFE
GO

CREATE FUNCTION dbo.lcs(@seq1 NVARCHAR(MAX), @seq2 NVARCHAR(MAX))
RETURNS NVARCHAR(MAX) 
AS EXTERNAL NAME LCSAssembly.LCSFunction.LcsSequence;


select dw.dbo.lcs('A,B,C,D,E,F', 'G,B,C,D,F,E')