PIVOT TABLE HELP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

PIVOT TABLE HELP

Author

Topic

julius.delorino
Starting Member

29 Posts

Posted - 2012-09-27 : 03:14:24

-------------
Source Table
-------------
TerminalID TerminalDesc msgtype ResponseCode ErrorDesc ErrorGroup TotalCount
8880001 NATCCO CF 210 00NH BATCH IN PROG Customer-Related Rejects 6
8880001 NATCCO CF 210 00NG NULL Customer-Related Rejects 1
8880001 NATCCO CF 210 92 DESTINATION NOT FOUND Customer-Related Rejects 3
8880001 NATCCO CF 210 91 ISSUERISDOWN Customer-Related Rejects 4
8880001 NATCCO CF 210 75 MAXPINTRY Customer-Related Rejects 24
8880001 NATCCO CF 210 68 TIMEOUT Customer-Related Rejects 4
8880001 NATCCO CF 210 61 EXCEEDEDDAILYAMTLIMIT Customer-Related Rejects 10
8880001 NATCCO CF 210 55 INVALID PIN Customer-Related Rejects 24
8880001 NATCCO CF 210 52 INVALID ACCOUNT Customer-Related Rejects 12
8880001 NATCCO CF 210 51 INSUFFICIENT FUNDS Customer-Related Rejects 50
8880001 NATCCO CF 210 38 NULL Customer-Related Rejects 14
8880001 NATCCO CF 210 30 INVALIDMSGFORMAT Customer-Related Rejects 1
8880001 NATCCO CF 210 25 INVALIDCURRENTACCT Customer-Related Rejects 10
8880001 NATCCO CF 210 19 SYSTEMERROR Customer-Related Rejects 5
8880001 NATCCO CF 210 14 INVALID CARD NUMBER Customer-Related Rejects 2
8880001 NATCCO CF 210 12 INVALIDTRANCODE Customer-Related Rejects 2
8880001 NATCCO CF 210 5 UNABLETOPROCESS Customer-Related Rejects 10
8880001 NATCCO CF 210 0 APPROVED Customer-Related Rejects 1000

---------------
Desired Output
---------------
ResponseCode ErrorDesc ErrorGroup 8880001
00NH BATCH IN PROG Customer-Related Rejects 6
00NG NULL Customer-Related Rejects 1
92 DESTINATION NOT FOUND Customer-Related Rejects 3
91 ISSUERISDOWN Customer-Related Rejects 4
75 MAXPINTRY Customer-Related Rejects 24
68 TIMEOUT Customer-Related Rejects 4
61 EXCEEDEDDAILYAMTLIMIT Customer-Related Rejects 10
55 INVALID PIN Customer-Related Rejects 24
52 INVALID ACCOUNT Customer-Related Rejects 12
51 INSUFFICIENT FUNDS Customer-Related Rejects 50
38 NULL Customer-Related Rejects 14
30 INVALIDMSGFORMAT Customer-Related Rejects 1
25 INVALIDCURRENTACCT Customer-Related Rejects 10
19 SYSTEMERROR Customer-Related Rejects 5
14 INVALID CARD NUMBER Customer-Related Rejects 2
12 INVALIDTRANCODE Customer-Related Rejects 2
5 UNABLETOPROCESS Customer-Related Rejects 10
0 APPROVED Customer-Related Rejects 1000

please help me how to attain that kind of output table,thank you and more power.

sql-programmers
Posting Yak Master

190 Posts

Posted - 2012-09-27 : 05:38:11

You can get desired output from this query then Why you are going to PIVOT?

SELECT ResponseCode, ErrorDesc, ErrorGroup, TotalCount FROM <TABLE NAME>

SQL Server Programmers and Consultants
http://www.sql-programmers.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-09-27 : 10:27:38

where did you get value 8880001 from?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources