0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

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, 'ADA', 'FirstName'),
    (7, '2.1', 'Amount'),
    (8, 'DADA', 'PostalCode'),
    (9, 'DIDI', 'LastName'),
    (10, 'DUDU', 'AccountNumber')
;


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

fork query

edited dec 7 anonymous

created jun 8 16 bluefeet