Scaling decimal value data truncation error

R

Ray S.

I have the following query running against linked files on ODBC. The linked
files are:

UNITS
RESOURCES
RESOURCE_CLASSES
TIME_SHEETS


RESOURCES.LAST_NAME, RESOURCES.FIRST_NAME, RESOURCES.ID,
RESOURCE_CLASSES.SHORT_DESC, UNITS.SHORT_DESC, UNITS.MANAGER_RES_ID,
DatePart('ww',[TIME_DATE]) AS Week, ([REQUIRED_HRS]/5) AS ReqHrs,
TIME_SHEETS.NUM_HRS, FROM UNITS INNER JOIN (RESOURCE_CLASSES INNER JOIN
(RESOURCES INNER JOIN TIME_SHEETS ON RESOURCES.ID = TIME_SHEETS.RESOURCE_ID)
ON RESOURCE_CLASSES.CODE = RESOURCES.CLASS_CODE) ON UNITS.CODE =
RESOURCES.UNIT_CODE
GROUP BY RESOURCES.LAST_NAME, RESOURCES.FIRST_NAME, RESOURCES.ID,
RESOURCE_CLASSES.SHORT_DESC, UNITS.SHORT_DESC, UNITS.MANAGER_RES_ID,
DatePart('ww',[TIME_DATE]), ([REQUIRED_HRS]/5), TIME_SHEETS.NUM_HRS,
RESOURCES.ADMIN_AREA_CODE, RESOURCES.ACTIVE_FLAG_YN
HAVING (((RESOURCES.ADMIN_AREA_CODE)="1") AND
((RESOURCES.ACTIVE_FLAG_YN)='Y'))
ORDER BY RESOURCES.LAST_NAME, DatePart('ww',[TIME_DATE]);

The query runs fine and gives me the results I expect, but if I try to run a
query on this query I get an error that says "scaling of decimal value
resulted in data truncation," also, if I try to turn the query into a make
table query I get the same error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
SCALING OF DECIMAL VALUE RESULTED IN DATA TRUNCATION 3
scaling of decimal value resulted in data truncation 0
Get date for start of week 3
error scaling of decimal value resulted in truncation 0
Scaling results in data truncation 2
Data Type mismatch error 2
Can't outer join or append. 2

Top