如何在SQL服务器上没有“WITH”或子查询的情况下简化此查询？(How can I simplify this query without “WITH” or Subquery on SQL server?)

 我有一个查询，可以在我的仓库和商店中筛选我的表格以查看积极的股票。 
 
 我只需要采取积极的价值，如果其中一个值是积极的，我只拿这个值。 
 
WITH Resultat AS
(
    SELECT AR_Ref,StockDepots,StockStores,
        CASE 
         WHEN StockDepots > 0 AND StockStores > 0  THEN StockDepots + StockStores
         WHEN StockDepots > 0 THEN StockDepots
         WHEN StockStores > 0 THEN StockStores
         ELSE StockDepots + StockStores
        END AS StockMulti
    FROM ArticleStock 
)    
SELECT * FROM Resultat
WHERE StockMulti > 0
ORDER BY AR_Ref
 
 小提琴： http : //rextester.com/RMSU6120 
 
 我的查询结果是好的，我需要知道如何不使用“WITH”或子查询来简化此查询？ 
 
 编辑** 
 
 为什么我不需要WITH或SubQuery是因为我认为在这种情况下是过度杀伤性的，我认为可以在没有WITH或Subquery的情况下进行查询。 

I've a query that filter my table for positive stock in my warehouse and stores.
 
I need to take only positive value and if one of values is positive I take this value only.
 
WITH Resultat AS
(
    SELECT AR_Ref,StockDepots,StockStores,
        CASE 
         WHEN StockDepots > 0 AND StockStores > 0  THEN StockDepots + StockStores
         WHEN StockDepots > 0 THEN StockDepots
         WHEN StockStores > 0 THEN StockStores
         ELSE StockDepots + StockStores
        END AS StockMulti
    FROM ArticleStock 
)    
SELECT * FROM Resultat
WHERE StockMulti > 0
ORDER BY AR_Ref
 
Fiddle : http://rextester.com/RMSU6120
 
My query result is Ok, I need to know How can I simplify this query without "WITH" or Subquery ?
 
EDIT**
 
Why I don't need WITH or SubQuery is because I think is overkill in this case and I think it's possible to make this query without WITH or Subquery.

原文：https://stackoverflow.com/questions/43778165