获取当月天数

SELECT DATEPART(MM,GETDATE()) AS '月',32 - DAY(GETDATE() + 32 - DAY(GETDATE())) AS '天数'

获取上个月天数

SELECT DATEPART(MM,GETDATE()) -1 AS '月',DAY(GETDATE() - DAY(GETDATE())) AS '天数'

获取当月剩余多少天

SELECT DATEPART(MM,GETDATE()) AS '月', (32 - DAY(GETDATE() + 32 - DAY(GETDATE()))) - DAY(GETDATE()) AS '剩余天数'

获取指定月份的天数

DECLARE @FMONTH VARCHAR(6)
SET @FMONTH = '202304'
SELECT @FMONTH AS '年月', DAY(DATEADD(MONTH,1,@FMONTH+'01') - 1) AS '天数'

统计本周的销量数据

SELECT CAST(SUM(t1.FQTY) AS DECIMAL(18,2)) AS '本周'
FROM T_SAL_ORDER t0
INNER JOIN T_SAL_ORDERENTRY t1 ON t0.FID = t1.FID
WHERE DATEDIFF(WEEK,t0.FDATE, GETDATE()) = 0

统计本月的销量数据

SELECT CAST(SUM(t1.FQTY) AS DECIMAL(18,2)) AS '本月'
FROM T_SAL_ORDER t0
INNER JOIN T_SAL_ORDERENTRY t1 ON t0.FID = t1.FID
WHERE DATEDIFF(MONTH,t0.FDATE, GETDATE()) = 0

统计上月的销量数据

SELECT CAST(SUM(t1.FQTY) AS DECIMAL(18,2)) AS '上月'
FROM T_SAL_ORDER t0
INNER JOIN T_SAL_ORDERENTRY t1 ON t0.FID = t1.FID
WHERE DATEDIFF(MONTH,t0.FDATE, GETDATE()) = 1

统计本年的销量数据

SELECT CAST(SUM(t1.FQTY) AS DECIMAL(18,2)) AS '本年'
FROM T_SAL_ORDER t0
INNER JOIN T_SAL_ORDERENTRY t1 ON t0.FID = t1.FID
WHERE DATEDIFF(YEAR,t0.FDATE, GETDATE()) = 0

统计本季度销量数据

SELECT CAST(SUM(t1.FQTY) AS DECIMAL(18,2)) AS '本季度'
FROM T_SAL_ORDER t0
INNER JOIN T_SAL_ORDERENTRY t1 ON t0.FID = t1.FID
WHERE DATEPART(QQ,t0.FDATE) = DATEPART (QQ, GETDATE()) 
AND DATEPART(YY,t0.FDATE) = DATEPART(YY, GETDATE())