Yearly WGQ Purchases Query

Go to FILESERVER

Open SQL Server Studio

Create a query on BABHOS

Copy and run the query below

Copy results with headers and paste it into an excel doc

select i.STID, StockNumber, DateOfStock, DisposalDate, BrandName, ModelNumber, ModelDescription, Cost, InternalBookValue
from dbo.Invntry i

join dbo.Model m on i.ModID = m.ModID

join dbo.Brand b on m.BrandID = b.BrandID
where DateOfStock between '????-??-??' and '????-??-??';