quote:

---

Originally posted by pecunn

Hi,
i have 2 queries and i need to know how to combine into 1 query.


SELECT
--DATEPART(MONTH, LodgementDateTime) as 'month value',
DATENAME(month,LodgementDateTime) + CAST(DATEPART(YEAR,LodgementDateTime) AS nvarchar(50)) as 'Year2010',
COUNT(*) as ' Number of sales 2010 '
FROM
Application
WHERE
LodgementDateTime BETWEEN '01-Jul-2009' AND '30-Jun-2010'
GROUP BY
DATENAME(MONTH,LodgementDateTime),
DATEPART(MONTH, LodgementDateTime),
DATEPART(YEAR,LodgementDateTime)
ORDER BY
DATEPART(YEAR,LodgementDateTime) ASC,
DATEPART(MONTH, LodgementDateTime)



SELECT
--DATEPART(MONTH, LodgementDateTime) as 'month value',
DATENAME(month,LodgementDateTime) + CAST(DATEPART(YEAR,LodgementDateTime) AS nvarchar(50)) as 'Year2011',
COUNT(*) as ' Number of sales 2011 '
FROM
Application
WHERE
LodgementDateTime BETWEEN '01-Jul-2010' AND '30-Jun-2011'
GROUP BY
DATENAME(MONTH,LodgementDateTime),
DATEPART(MONTH, LodgementDateTime),
DATEPART(YEAR,LodgementDateTime)
ORDER BY
DATEPART(YEAR,LodgementDateTime) ASC,
DATEPART(MONTH, LodgementDateTime)

---