WHEN I EXECUTE THE FOLLOWING QUERY, I GOT A ERROR.
SELECT INVENTORY_TABLE.ITEM_MAS_ID, INVENTORY_TABLE.TOTAL_USAGE
INTO MasIdAndTotalUsage
FROM INVENTORY_TABLE INNER JOIN ITEM_MASTER
ON INVENTORY_TABLE.ITEM_MAS_ID = ITEM_MASTER.ITEM_MAS_ID
WHERE
ITEM_MASTER.CO_ID = 35 AND
ITEM_MASTER.LOC_ID = 5
THE ERROR IS,
ODBC: MSG 0, LEVEL 19, STATE 1
SQLDupmpExceptionHandler: Process 15 generated fatal exception c0000093 EXCEPTION_FLT_UNDERFLOW. SQL Server is terminating this process.
TABLE STRUCTURE:
1. ITEM_MASTER
NO. OF FIELDS …. 50
NO. OF RECORDS …. 228966
PRIMARY KEY …. ITEM_MAS_ID
2. INVENTORY_TABLE
NO. OF FIELDS …. 46
NO. OF RECORDS …. 224153
PRIMARY KEY …. ITEM_MAS_ID + INV_ID
FOREIGH KEY …. ITEM_MASTER.ITEM_MS_ID
Could you please give the solution