阅读背景:

How to combine me 2 query to get my second count side by side each

来源:互联网 

I have this query:

我有这个问题:

SELECT   DATENAME(MONTH,dbo.fn_dstoffset(CREATED)) AS MON, 
         SR_AREA, 
         COUNT(*) AS COUNT
FROM     S_SRV_REQ
WHERE   (INS_PRODUCT = 'PS') 
  AND   (dbo.fn_dstoffset(CREATED) BETWEEN '10/1/2015' AND '11/1/2015')
GROUP BY DATENAME(MONTH,dbo.fn_dstoffset(CREATED)), 
         SR_AREA
SELECT   DATENAM



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: