Posts by Marcel Leandro • 11 points

• 1

  votes

  3

  answers

  830

  views

  A: Convert rows to columns (Pivot?)

  SELECT Campo1,Exemplo1,Exemplo2,Exemplo3 FROM ( select Campo1,Campo2,'Exemplo' +convert(varchar(10),ROW_NUMBER () over (partition by Campo1 Order By Campo2)) as Sequencia from Tabela1 )Apelido1…

  sql sql-server

  answered 8 years, 9 months ago Marcel Leandro 11