Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: microsoft.public.sqlserver.programming Subject: Re: How do I order the columns on a pivot table? Date: Sun, 12 Apr 2020 23:41:30 +0200 Organization: Erland Sommarskog Lines: 7 Message-ID: References: <32b39068-acc8-48ef-ac56-7f80bc2ee65b@googlegroups.com> <7a25939e-1e2d-4de3-9315-edef91428a1a@googlegroups.com> <3e7cf417-607c-4659-aed2-d4c4668e592b@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="5073"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18Tpfq6WbSpl1pThR0VPBiX" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:xy0ZBiwYuVbM4jgx4xQZmWDX0kc= Xref: csiph.com microsoft.public.sqlserver.programming:31363 John Hall (foundarecord@gmail.com) writes: > This time it didn't give an error but, returned NULL for all ParamX values > and incorrect DataValues > Please refer to my previous post. I don't know your data and table, and I am not inclined to make further gueses.