→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
10-08-2019 05:25 PM
10-09-2019 05:21 PM
SELECT
...
CASE
WHEN tblAssetCustom.Model IN ('OptiPlex 7010', 'OptiPlex 9010')
OR tblAssetCustom.Model LIKE 'Latitude E6530%' THEN 2012
WHEN tblAssetCustom.Model = 'OptiPlex 7020' THEN 2014
WHEN tblAssetCustom.Model = 'OptiPlex 7040' THEN 2015
WHEN tblAssetCustom.Model = 'OptiPlex 7050' THEN 2018
WHEN tblAssetCustom.Model LIKE 'Latitude 6540' THEN 2013
etc.
END AS [model year]
...
FROM
...
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now