有一个存储过程，应该统计季度的金额情况,传入参数为年，与1，2，3，4这样的值型，后面代表四个季度
例如
select ... from table1 where date1 ....
date1为日期型
这里的where 怎么写比较方便
另外因为其它原因不方便用
declare @sql varchar(2000)
set @sql= "select ....from "
execute (@sql）这样的方式，有什么好办法吗
------解决方案--------------------
datepart(quarter,getdate())
------解决方案--------------------
declare @year as int
set @year = 2007
declare @quarter as int
set @quarter = 3
select * from tb where year(date1) = @year and datepart(quarter,date1) = @quarter
------解决方案--------------------
declare @year as int
set @year = 2007
declare @quarter as int
set @quarter = 3
select sum(金额) as cast(@year as varchar) + '年第 ' + cast(@quarter) + '季度金额统计情况 ' from tb where year(date1) = @year and datepart(quarter,date1) = @quarter