Data shown in a tabular form - 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 2000 Forums

SQL Server Development (2000)

Data shown in a tabular form

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-17 : 07:52:24

George writes "Hi,
I have the following data:

Table Data:


Stage	       Bank    Amount
Application 	LLB	5000
Offer	        LLB     1000
Offer	       Prime	2000
Offer	       Prime	2000
Application    Prime	1000
Application 	LLB	2000

and I want to produce the following report
by running a query against the table
Report Structure:


Application	  LLB	 Prime
Number of Cases	   2	   1
Amount	          7000	 1000

I want to see the ‘number of cases’ and ‘Amount’ in
the same column.How do I go about it? Thanks"

Antonio
Posting Yak Master

168 Posts

Posted - 2006-10-17 : 08:38:42

quote:
Originally posted by AskSQLTeam

George writes "Hi,
I have the following data:

Table Data:

Stage Bank Amount
Application LLB 5000
Offer LLB 1000
Offer Prime 2000
Offer Prime 2000
Application Prime 1000
Application LLB 2000

and I want to produce the following report
by running a query against the table
Report Structure:

Application LLB Prime
Number of Cases 2 1
Amount 7000 1000

I want to see the ‘number of cases’ and ‘Amount’ in
the same column.How do I go about it? Thanks"

Refer to the following article for further help :

[url]http://www.sqlteam.com/item.asp?ItemID=2955[/url]

_________________________________________________________________________________________________________________________
Inability is a disaster; patience is bravery; abstinence is a treasure, self-restraint is a shield; and the best companion is submission to Divine Will.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-21 : 08:39:46

Also read about Cross-tab Reports in sql server help file

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources