Software license contracts expiring in less than 90 days
Meets all the following criteria:
- Software license contract
- Contract expiration date in 1-90 days
Sorted on:
- Software name
Select Top 1000000 tblLicenses.softwareName As License,
tblLicenses.Priceperlicense,
tblLicenses.LicenseExpiration
From tblLicenses
Where tblLicenses.LicenseContract = 1 And
DateDiff(day, GetDate(), tblLicenses.LicenseExpiration) <= 90
Order By License
