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
 General SQL Server Forums
 New to SQL Server Programming
 SQL CODING

Author  Topic 

jagganaveen
Starting Member

6 Posts

Posted - 2007-08-28 : 07:54:20
Hi all,


I want codeing for to find (subtotal & total)the following

Input

productname qty_A_grade Qty_B_grade
abc 10 5
def 5 5
subtotal
gh 10 10
ab 10 10
Total


output

productname qty_A_grade Qty_B_grade
abc 10 5
def 5 5
subtotal 15 10
gh 10 10
ab 10 10
Total 20 20

pbguy
Constraint Violating Yak Guru

319 Posts

Posted - 2007-08-28 : 08:06:35
What isthe criteria for subtotal and total...Is total in ur post is correct...

It is again a subtotal of gh and ab...clear it

--------------------------------------------------
S.Ahamed
Go to Top of Page

jagganaveen
Starting Member

6 Posts

Posted - 2007-08-28 : 08:10:35
hI,
THIS IS CORRECT IN MY QUERY I WANT TO SHOW SUBTOTAL AND TOTAL


quote:
Originally posted by pbguy

What isthe criteria for subtotal and total...Is total in ur post is correct...

It is again a subtotal of gh and ab...clear it

--------------------------------------------------
S.Ahamed


Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-28 : 08:12:40
Duplicate of http://sqlteam.com/forums/topic.asp?TOPIC_ID=88507
You should do this in Reports

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -