DECLARE @date datetime DECLARE @year int SET @date = '2014-01-01' SET @year = Year(@date) SELECT a.companyname, a.saler, b.bargainname, Month(b.bargaindate) [month], SUM(b.bargainsales) bargainsales FROM dbo.business AS a JOIN dbo.salescontract AS b ON a.id = b.myid WHERE Year(b.bargaindate) = @year GROUP BY a.companyname, a.saler, b.bargainname, [month] DECLARE @date datetime DECLARE @month int SET @date = '2014-01-01' SET @month = Year(@date) SELECT a.companyname, a.saler, b.bargainname, Year(b.bargaindate) [year], SUM(b.bargainsales) bargainsales FROM dbo.business AS a JOIN dbo.salescontract AS b ON a.id = b.myid WHERE Month(b.bargaindate) = @month GROUP BY a.companyname, a.saler, b.bargainname, [year]
DECLARE @year int
SET @date = '2014-01-01'
SET @year = Year(@date) SELECT a.companyname,
a.saler,
b.bargainname,
Month(b.bargaindate) [month],
SUM(b.bargainsales) bargainsales
FROM dbo.business AS a
JOIN dbo.salescontract AS b
ON a.id = b.myid
WHERE Year(b.bargaindate) = @year
GROUP BY a.companyname,
a.saler,
b.bargainname,
[month]
DECLARE @date datetime
DECLARE @month int
SET @date = '2014-01-01'
SET @month = Year(@date) SELECT a.companyname,
a.saler,
b.bargainname,
Year(b.bargaindate) [year],
SUM(b.bargainsales) bargainsales
FROM dbo.business AS a
JOIN dbo.salescontract AS b
ON a.id = b.myid
WHERE Month(b.bargaindate) = @month
GROUP BY a.companyname,
a.saler,
b.bargainname,
[year]
列名 'month' 无效 列名 'year' 无效 怎么破?