因为工作需要，开始研究MOSS 2010，同时为了学习新买的《SQL Server 2008商业智能完美解决方案》，也从微软官网一并下载了MSSQL 2010的180天体验版还有SP2的补丁。另外，告诉大家一下以前的网页制作工作FrontPage现在改名叫做Sharepoint Designer呢。
最后分享一段计算ERP LN系统的可用库存和安全库存比较的报表，同时按照可用库存达到安全库存的比例显示不同的颜色。这个是详细记录，最终不同颜色的汇总报表还在写。
<br/>SELECT dbo.LNwhwmd215801.cwar, dbo.LNwhwmd215801.item, dbo.LNwhwmd215801.qhnd, <br/> dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal AS Available, dbo.LNwhwmd210801.sfst, dbo.LNwhwmd210801.reop, <br/> dbo.LNwhwmd215801.qlal, dbo.LNticpr007801.ecpr1, <br/> CASE WHEN dbo.LNwhwmd210801.sfst = 0 THEN 'Green' WHEN (dbo.LNwhwmd210801.sfst > 0 AND <br/> (dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal) <= 0.6) THEN 'Red' WHEN (dbo.LNwhwmd210801.sfst > 0 AND <br/> (dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal) / dbo.LNwhwmd210801.sfst > 0.6 AND <br/> (dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal) / dbo.LNwhwmd210801.sfst <= 0.8) THEN 'Yellow' WHEN (dbo.LNwhwmd210801.sfst > 0 AND <br/> (dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal) / dbo.LNwhwmd210801.sfst > 0.8 AND <br/> (dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal) / dbo.LNwhwmd210801.sfst <= 1.2) THEN 'Green' WHEN (dbo.LNwhwmd210801.sfst > 0 AND <br/> (dbo.LNwhwmd215801.qhnd - dbo.LNwhwmd215801.qlal) / dbo.LNwhwmd210801.sfst > 1.2) THEN 'Purple' ELSE 'Green' END AS 'Color', <br/> dbo.LNticpr007801.ccur<br/>FROM dbo.LNwhwmd215801 INNER JOIN<br/> dbo.LNwhwmd210801 ON dbo.LNwhwmd215801.cwar = dbo.LNwhwmd210801.cwar AND <br/> dbo.LNwhwmd215801.item = dbo.LNwhwmd210801.item INNER JOIN<br/> dbo.LNticpr007801 ON dbo.LNwhwmd210801.item = dbo.LNticpr007801.item<br/>
