Get the non-moving items from Inventory using views

Occasional Visitor

Hi Expert,



Need some help please, I need to create a views in sql server 2017 but I have encountred to put into views. This is my normal query.


Select distinct [Description], (COUNT (ItemNo)) As CycleCount,MIN(QtyReceived) As MinRequested,MAX(QtyReceived) As MaxRequested,AVG(QtyReceived) As Average,SUM(QtyReceived) As TotalItemsRelease
From dbo.PerWithdrawalSlip
group by Description
order by CycleCount desc;


Thank you


0 Replies