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

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

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 23:15:44 +0200
Organization	Erland Sommarskog
Lines	13
Message-ID	<XnsAB9DECA314306Yazorman@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> <XnsAB9DE50FF9274Yazorman@127.0.0.1> <bba1f50c-e0ae-4466-a0fb-fee3ef82c465@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="26484"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19Q8tIgYv270sGC4dVBcTj1"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:7nKp3NgtEKdPvEcoLvosh/NJb9E=
Xref	csiph.com microsoft.public.sqlserver.programming:31361

Show key headers only | View raw

John Hall (foundarecord@gmail.com) writes:
> I want to replace the ParameterEntries query with one that orders the
> TextValues in the order of their ParameterIDs in PresentOrder in
> ParametersUsed 
> 

Please post CREATE TABLE statements for your tables and INSERT statements 
with sample data, enough to illustrate all angles of the problem, and the 
expected results given the query. I can't work from your query. It's using 
the PIVOT keyword (which I never bothered to learn) and the RIGHT JOIN 
operator (which gives me a headache).

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