0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

CREATE table #yourtable
    ([Id] int, [Value] varchar(6), [ColumnName] varchar(13))
;
    
INSERT INTO #yourtable
    ([Id], [Value], [ColumnName])
VALUES
    (1, 'John', 'FirstName'),
    (2, '2.4', 'Amount'),
    (3, 'ZH1E4A', 'PostalCode'),
    (4, 'Fork', 'LastName'),
    (5, '857685', 'AccountNumber'),
    (6, 'Jacob', 'FirstName'),
    (7, '4.3', 'Amount'),
    (8, 'ZH1E4A', 'PostalCode'),
    (9, 'Doe', 'LastName'),
    (10, '857685', 'AccountNumber')
;


select Firstname, Amount, PostalCode, LastName, AccountNumber
from
(
  select value, columnname
  from #yourtable
) d
pivot
(
  max(value)
  for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber)
) piv;

fork query

edited jun 15 21 anonymous

created jun 8 16 bluefeet