Select Asset_Status_ID from tbl_Assets where Asset_ID=