Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: microsoft.public.sqlserver.programming
Subject: Re: How do I order the columns on a pivot table?
Date: Sun, 12 Apr 2020 13:59:23 +0200
Organization: Erland Sommarskog
Lines: 9
Message-ID: <XnsAB9D8E503D7CEYazorman@127.0.0.1>
References: <32b39068-acc8-48ef-ac56-7f80bc2ee65b@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="ff96d794c89c0239ea5bf45a2c7528e6"; logging-data="28044"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19VemzJZOht6xAkI5n4XQrD"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:2TexCvGXbYe0AoZydmCXFOCxHhE=
Xref: csiph.com microsoft.public.sqlserver.programming:31353

SELECT PE.TestID,
       MIN(CASE PU.PresentOrder WHEN 1 THEN PE.TextValue END) AS Param1,
       MIN(CASE PU.PresentOrder WHEN 2 THEN PE.TextValue END) AS Param2,
       MIN(CASE PU.PresentOrder WHEN 3 THEN PE.TextValue END) AS Param3,
       MIN(CASE PU.PresentOrder WHEN 4 THEN PE.TextValue END) AS Param4,
       MIN(CASE PU.PresentOrder WHEN 5 THEN PE.TextValue END) AS Param5
FROM   ParametersEntries PE
JOIN   ParametersUser PU ON PE.TestID = PU.TestID
GROUP  BY PE.TestID