SELECT IdAss, AssetSn, AssetName, AssetEnglish, Model, BrandAssets, NowNum, BarCode, SuppSn, TypeSn, PartId, Buyid, Deprecion, AssetConfig,
ServiceTime, AssetPrice, AssetUnit, AssetStatus, EmpSn, MakeDate, getAssetDate, UseDate, AssetTracking, BuySn, WarrantyNum, Remarks, JLsn,
AllonSN, BadType, AssetUseSn, DepartMentSn, AssetSource, StorSn, UserMan, RZDate, tradType, SaveAdrees, TagRemark, Salvage, life, InputMan,
EditTime, EditMan, passStatus
FROM dbo.AssetInfo
WHERE (life * 365 - (GETDATE() - UseDate) <=
(SELECT CONVERT(int, NumbersRole) AS dateNumbers
FROM dbo.Ment
WHERE (Type = 4)))
注意转换 CONVERT(int, NumbersRole)