Forum Discussion

Antonio Jr Candido's avatar
Antonio Jr Candido
Copper Contributor
Nov 09, 2018

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

Resources