Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help in a sum query

Status
Not open for further replies.
yehong

yehong

Programmer
Joined
Sep 22, 2003
Messages
291
Location
US
Hi Guys, I am on a tight deadline. I have a query that returns data similar to the following:

State City JanSum FebSum MarSum... DecSum
CA LA 1000 500 300 ... 200
CA SF 500 500 200 ... 300
TX Dallas 300 100 50 ... 150
TX Hou 120 400 0 ... 0

I need help in writing a query that returns the results as follows:

State City JanSum FebSum MarSum... DecSum
All All 1920 1500 550 650
All LA ... ... ... ...
All SF ...
All Dallas ...
All Hou ...
CA All ...
TX All ...

Is this achievable through a query? I am using SQL Server database. Please advise how to achieve this with some sample code if possible. Thanks in advance.
 
Sort by date Sort by votes
You'll need to use a union query. This is more of a question for the SQL Server Programming forum.

As an aside, I think you need to read this: faq222-2244

It is nice to post back and let people who've offered advice know whether it worked or not.

Alex


[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question Question
Help with concatenation of BIG integers
Replies
0
Views
692
tekpr00
tekpr00
ItHurtsWhenIThink
  • Locked
  • Question Question
Using Distinct and count in same query???
Replies
4
Views
840
gk53
gk53
Rene1024
  • Locked
  • Question Question
Help with a Bulk insert statement
Replies
1
Views
753
drlex
drlex
ChewDoggie
  • Locked
  • Question Question
Help with Select statement Substring
Replies
2
Views
825
ChewDoggie
ChewDoggie
betachristopher
  • Locked
  • Question Question
Use IF/ELSE in Query
Replies
3
Views
786
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top