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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-18 : 08:39:32
|
Nazim writes "Hi Every1 there,
I have 3 tables
Items
-----
Item_code
item_desc
gp_code
cat_code
and
inv_header
---------
invhkey
trnno
trndate
tot_amount
tot_discount
inv_Details
----------
invdetkey
invhkey
item_code
qty
rate
discount
i want a way in which i should b able to view the information in this format.
Gp_code Item_code item_Description
eg: 01aa abc abcdedf
Sales
May2001 Apr2001 Mar2001 Feb2001 Jan2001 Dec2000 till May2000(i.e 1 year)
if possible i want a flexibility wherein i should b able to give the gp_code and all the items in tht gp_code should b displayed in above format where in the starting monthh will b the current month .
Any help will b highly appreciated.
Thanx." |
|
|
|
|
|
Cross Tab