Two queries in one hit

Question

Two queries in one hit

Davroche

SSC Veteran

Points: 217
More actions
September 10, 2008 at 1:22 pm

#92482

I have written many simple queries but I have to run them sequentially. How can I run two questions in one query?
For example:
Give me the total of sales in June
Give me the total of sales in July
I would like the answer thus:
Sales
June
July
I hope this makes sense. Thank you in advance.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Could you give us more info please? Maybe give a couple of the queries you want to combine, show what they return now and show what you want them to return.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

select

datename(mm, SalesDate) as Month,

sum(TotalSale) as TotalSales

from

dbo.SalesOrder

group by

datename(mm, SalesDate)

order by

datepart(mm, SalesDate);

Something like that??

😎

Davroche SSC Veteran Points: 217 More actions · Answer 3

Thank you.

I'll get back with a more detailed example.

Davroche SSC Veteran Points: 217 More actions · Answer 4

Thank you.

I'll get back with a more detailed example.