![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
无语逍遥
这个作者很懒,什么都没留下…
展开
-
按月、按周列举统计最近10个月 10周的数据计算
10个月的数据统计 select a.f_year,a.f_month , Convert(decimal(5,2),100-100*numQualified/nullif(numFeed,0)) KpiUnqualified , Convert(decimal(5,2),numQualified/nullif((timeProduction/60),0)/nullif(theoryUPH,0)) KpiOEE , Convert(decimal(5,2),100*numQualified/nul.原创 2021-05-27 15:07:02 · 106 阅读 · 0 评论 -
sql server 列举获取最近10个月。10周
1.列举最近10个月 selectyear(F_MonthDay) f_year,month(F_MonthDay) f_month from( SELECTDATEADD(mm,number,dateadd(mm,-9,getdate())) ASF_MonthDay FROMmaster..spt_values WHERETYPE = 'P'ANDDATEADD(mm,number,dateadd(mm,-9,getdate())) <= getdate() )...原创 2021-05-27 15:05:14 · 281 阅读 · 0 评论