Hi,

first try this ,

select ItemCode [Item Code],

OnHand [Stock],

Qty_Sales [Qty Sales],

Qty_Sales_Month_1 [Qty Sales_Last],

([Total days]- Days) Days,

[Total days],

(case when TURNOVER_IN_MONTH > 0 then 'Sales' else 'No Sales'end) [TURNOVER_IN_MONTH ],

TURNOVER_DAYS

from (

SELECT TOP 100 PERCENT ItemCode,

ItemName,

OnHand,

/*YOUR STATEMENT*/

OR T0.ONHAND > 0 ORDER BY 1

) AS X

ARUN SAS