Function for Converting List to Table in Sql
CREATE FUNCTION ConvertListToTable ( @Delimiter nvarchar(5), @List nvarchar(max) ) RETURNS @TableOfValues TABLE ( RowNumber smallint IDENTITY(1,1), RowValue nvarchar(50) ) AS BEGIN DECLARE @LenString int WHILE len( @List ) >…