当前位置: 代码迷 >> Sql Server >> 求季度报表where写法解决方案
  详细解决方案

求季度报表where写法解决方案

热度:120   发布时间:2016-04-27 19:49:32.0
求季度报表where写法
有一个存储过程,应该统计季度的金额情况,传入参数为年,与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
  相关解决方案