Groups > microsoft.public.sqlserver.programming > #31355

Re: How do I order the columns on a pivot table?

Newsgroups	microsoft.public.sqlserver.programming
Date	2020-04-12 12:27 -0700
References	<32b39068-acc8-48ef-ac56-7f80bc2ee65b@googlegroups.com> <XnsAB9D8E503D7CEYazorman@127.0.0.1>
Message-ID	<e6e7c619-b673-4aec-b915-3d02be7ede67@googlegroups.com> (permalink)
Subject	Re: How do I order the columns on a pivot table?
From	John Hall <foundarecord@gmail.com>

Show all headers | View raw

On Sunday, April 12, 2020 at 7:59:26 AM UTC-4, Erland Sommarskog wrote:
> 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

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   ParameterEntries PE
JOIN   ParametersUsed PU ON PE.ParameterID = PU.ParameterID
WHERE TestID IN (SELECT TestID FROM Subgroups WHERE CharID = 502107 AND DateTime = '08/29/2017 10:29:25' )
GROUP  BY PE.TestID
TestID  Param1          Param2          Param3  Param4  Param5
519802	201487332	201487332	2.20	1.54	1.80

SELECT ParameterID, TextValue FROM ParameterEntries WHERE TestID = 519802
154	201487332
502009	5w
502022	2.20
502023	1.54
502024	1.80

So, why is Param1 getting duplicated into Param2 but 3, 4, & 5 are fine?

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-11 09:08 -0700
  Re: How do I order the columns on a pivot table? Erland Sommarskog <esquel@sommarskog.se> - 2020-04-12 13:59 +0200
    Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-12 12:02 -0700
      Re: How do I order the columns on a pivot table? Erland Sommarskog <esquel@sommarskog.se> - 2020-04-12 21:32 +0200
      Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-15 12:54 -0700
        Re: How do I order the columns on a pivot table? Erland Sommarskog <esquel@sommarskog.se> - 2020-04-16 20:02 +0200
    Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-12 12:27 -0700
    Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-12 12:43 -0700
      Re: How do I order the columns on a pivot table? Erland Sommarskog <esquel@sommarskog.se> - 2020-04-12 22:31 +0200
        Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-12 14:10 -0700
          Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-12 14:14 -0700
          Re: How do I order the columns on a pivot table? Erland Sommarskog <esquel@sommarskog.se> - 2020-04-12 23:15 +0200
        Re: How do I order the columns on a pivot table? John Hall <foundarecord@gmail.com> - 2020-04-12 14:18 -0700
          Re: How do I order the columns on a pivot table? Erland Sommarskog <esquel@sommarskog.se> - 2020-04-12 23:41 +0200

csiph-web