‎11-20-2014 01:43 PM
Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseContract = 1 And
DateDiff(day, GetDate(), tblLicenses.LicenseExpiration) <= 60
Order By License
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now