SELECT BOOK_TYPE_CODE, BUSINESS_UNIT, DEPARTMENT, DEPARTMENT_DESCRIPTION, ASSET_NUMBER, ASSET_DESCRIPTION, MAJOR_CATEGORY, PR_NUMBER, SERIAL_NUMBER, TAG_NUMBER, PO_NUMBER, LEGACY_ASSET_NUMBER, CUSTODIAN, DETAILED_LOCATION, EQ_NUMBER, CALIBRATION_DATE, NEXT_CALIBRATION_DATE, COUNT_CYCLE, DATE_PLACED_IN_SERVICE, QUANTITY, COST, ACCUM_DEPRN, NET_BOOK_VALUE, CAPITALIZED_FLAG, Getdate()
from OpenQuery(PART1I,'select * from XXFA.XXFA_COUNT')
