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