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

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

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	microsoft.public.sqlserver.programming
Subject	Re: How do I order the columns on a pivot table?
Date	2020-04-12 22:31 +0200
Organization	Erland Sommarskog
Message-ID	<XnsAB9DE50FF9274Yazorman@127.0.0.1> (permalink)
References	<32b39068-acc8-48ef-ac56-7f80bc2ee65b@googlegroups.com> <XnsAB9D8E503D7CEYazorman@127.0.0.1> <7a25939e-1e2d-4de3-9315-edef91428a1a@googlegroups.com>

Show all headers | View raw

John Hall (foundarecord@gmail.com) writes:
> 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
> 
> The SQL Management studio is saying this is a view not a pivot table and
> can't have an ORDER BY.  I simplified this for my question.  I need to
> order the results and JOIN it on TestID with yet another table. 
> 

Could explain more closely what you are doing? The above is not a view, it 
is a query, since, well, that seemed to be what you asked for. But 
obviously, you could make a it view by adding CREATE VIEW on top.

You cannot have ORDER BY in a view definition.

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