Q&A for people interested in the history and origins of science and mathematics
CREATE table #yourtable ([Id] int, [Value] varchar(10), [ColumnName] varchar(13),[RowId] varchar(13),[Lid] int,[Pid] int) ; INSERT INTO #yourtable ([Id], [Value], [ColumnName],[RowId],[Lid],[Pid]) VALUES (1, 'John', 'FirstName','E01',1,2), (2, '2.4', 'Amount','E01',1,2), (3, 'ZH1E4A', 'PostalCode','E01',1,2), (4, 'Fork', 'LastName','E01',1,2), (5, '857685', 'AccountNumber','E01',1,2), (6, 'E01', 'RowId','E01',1,2), (7, 'John1', 'FirstName','E011',1,2), (8, '2.41', 'Amount','E011',1,2), (9, 'ZH1E4A1', 'PostalCode','E011',1,2), (10, 'Fork1', 'LastName','E011',1,2), (11, '8576851', 'AccountNumber','E011',1,2), (12, 'E011', 'RowId','E011',1,2), (13, 'John', 'LAST_NAME','E01',1,1), (14, '24', 'AGE','E01',1,1), (15, 'ZH1E4A', 'PostalCode','E01',1,1), (16, 'Fork', 'LastName','E01',1,1), (17, '857685', 'AccountNumber','E01',1,1), (18, 'E01', 'RowId','E01',1,1); DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX); DECLARE @PID AS INT; DECLARE @LID AS INT; SET @PID=1; SET @LID=1;