Forum Discussion
Antonio Jr Candido
Nov 09, 2018Copper Contributor
Get the non-moving items from Inventory using views
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
No RepliesBe the first to reply