一个经典的报表sql提问 大虾们请进来看看
select @sql=@sql+'SUM(CASE WHEN dateadd(month,'+@monthspan +',a.ser_start_date)>= '''+@year+'-01-01'''+' and dateadd(month,'+@monthspan +',a.ser_start_date)< '''+@year+'-02-01'''+' then 1 else 0 end) AS '''+ @year+'01' +''','
+ 'SUM(CASE WHEN dateadd(month,'+@monthspan +',a.ser_start_date)>= '''+@year+'-02-01'''+' and dateadd(month,'+@monthspan +',a.ser_start_date)< '''+@year+'-03-01'''+' then 1 else 0 end) AS '''+ @year+'02' +''','
+ 'SUM(CASE WHEN dateadd(month,'+@monthspan +',a.ser_start_date)>= '''+@year+'-03-01'''+' and dateadd(month,'+@monthspan +',a.ser_start_date)< '''+@year+'-04-01'''+' then 1 else 0 end) AS '''+ @year+'03' +''','
+ 'SUM(CASE WHEN dateadd(month,'+@monthspan +',a.ser_start_date)>= '''+@year+'-04-01'''+' and dateadd(month,'+@monthspan +',a.ser_start_date)< '''+@year+'-05-01'''+' then 1 else 0 end) AS '''+ @year+'04' +''','
+ 'SUM(CASE WHEN dateadd(month,'+@monthspan +',a.ser_start_date)>= '''+@year+'-05-01'''+' and dateadd(month,'+@monthspan +',a.ser_start_date)< '''+@year+'-06-01'''+' then 1 else 0 end) AS '''+ @year+'05' +''''
select @sql= @sql+' from object a '
提问:如果我要是在页面使用datagrid绑定,如何来用引用as后面的别名来进行字段绑定,请大虾们给个提示。因为现在这里用的是AS '''+ @year+'03' +'''这种方式。能否改变一下像as aa,这样我就可以在datagrid中直接用aa进行绑定了。