Database

    SELECT  IDENTITY(int, 1,1) AS REC_NO,
    LIS_KEY,
    FUNC_KEY,
    UNIT_NO,
    RIGHTS_ZONING,
    USE_CODE,
    [OWNER],
    RATEABILITY,
    EXCLUSION,
    MARKET_VALUE,
    EFFECTIVE_DATE,
    CATEGORY_CODE,
    SUPPLE_NUM,
    AREA,
    PROPERTY_ID,
    OLD_MARKET_VALUE,
    VALUATION_ID,
    NOTIFICATION_ID,
    REASON,
    SORT_DATE
INTO    SDE.EXPORT_OITPS_GV_SUPP_RECON
FROM
    (
    SELECT  DISTINCT TOP 100 PERCENT P.LIS_KEY,
            CASE LEN(FUNC_KEY)
            WHEN 8 THEN SUBSTRING(FUNC_KEY, 1, 5) + '0' + SUBSTRING(FUNC_KEY, 6, 3)
            ELSE FUNC_KEY
            END AS FUNC_KEY,
            CASE LEN(FUNC_KEY)
            WHEN 8 THEN SUBSTRING(FUNC_KEY,5,1)+ '0' + SUBSTRING(FUNC_KEY, 6, 4)
            ELSE SUBSTRING(FUNC_KEY,5, 5)
            End AS UNIT_NO,
            SUBSTRING(NEW_ATTRIB_CODE, 1, 2) AS RIGHTS_ZONING,
            SUBSTRING(NEW_ATTRIB_CODE, 3, 2) AS USE_CODE,
            ISNULL(P.OWN_NAME, '') AS OWNER,
            CASE SUBSTRING(NEW_ATTRIB_CODE, 7, 1)
            WHEN '1' THEN 'R'
            WHEN '4' THEN 'E'
            ELSE 'N'
            END AS RATEABILITY,
            CASE
            WHEN P.PROP_CATEGORY_ID = '2' THEN 'RES'
            WHEN P.PROP_CATEGORY_ID = '4' THEN 'PSI'
            WHEN SUBSTRING(V.NEW_ATTRIB_CODE, 7, 2) = '41' OR SUBSTRING(V.NEW_ATTRIB_CODE, 7, 2) = '42' THEN 'REL'
            ELSE ' '
            END AS EXCLUSION,
            CONVERT(FLOAT,V.NEW_IMPROVED_VALUE) AS [MARKET_VALUE],
            (
                CASE WHEN CONVERT(VARCHAR,DATEPART(DD, EFFECTIVE_DATE)) < 10
                THEN '0' + CONVERT(VARCHAR,DATEPART(DD, EFFECTIVE_DATE))
                ELSE CONVERT(VARCHAR,DATEPART(DD, EFFECTIVE_DATE))
                END +
                CASE WHEN CONVERT(VARCHAR,DATEPART(MM, EFFECTIVE_DATE)) < 10
                THEN '0' + CONVERT(VARCHAR,DATEPART(MM, EFFECTIVE_DATE))
                ELSE CONVERT(VARCHAR,DATEPART(MM, EFFECTIVE_DATE))
                END +
                CONVERT(VARCHAR, DATEPART(YYYY, EFFECTIVE_DATE))
            ) AS EFFECTIVE_DATE,
            SUBSTRING(V.NEW_ATTRIB_CODE,7,2) AS CATEGORY_CODE,
            'S' + CONVERT(VARCHAR, SUPPL_YEAR) + '/' +  CONVERT(VARCHAR, SUPPL_NO) AS SUPPLE_NUM,
            CONVERT(INT, ISNULL(P.ACTUAL_EXTENT, 0)) AS AREA,
             P.PROPERTY_ID,
            CONVERT(INT,  ISNULL(P.IMPROVED_VALUE, -1)) AS OLD_MARKET_VALUE,
            V.VALUATION_ID,
            0 AS NOTIFICATION_ID,
            LU_V.VAL_REASON AS REASON,
            V.STATUS_DATE AS SORT_DATE

    FROM            SDE.PROPERTY_SUMMARY P
                    LEFT JOIN SDE.AUTHORITY A
                    ON A.AUTHORITY_ID = P.AUTHORITY_ID
                    INNER JOIN sde.VALUATION V
                    ON P.PROPERTY_ID = V.PROPERTY_ID
                    LEFT JOIN (SELECT   GISCODE, MIN(OWN_NAME)   AS OWN_NAME
                    FROM        SDE.VW_PROPERTY_DEED
                    GROUP BY    GISCODE) D
                    ON P.LIS_KEY = D.GISCODE
                    LEFT JOIN SDE.LU_VAL_REASON LU_V
                    ON V.VAL_REASON_ID = LU_V.VAL_REASON_ID
                    WHERE
                    V.ARCHIVE_DATE IS NULL
                    AND V.ARCHIVE_DATE IS NULL
                    AND V.NEW_ATTRIB_CODE IS NOT NULL
                    AND V.EFFECTIVE_DATE = '2008/01/07'
                    AND V.NEW_ATTRIB_CODE <> '0009000900'
                    ORDER BY SORT_DATE
                    ) TMP

Msg 232, Level 16, State 3, Line 6<br />
Arithmetic overflow error for type int, value = 3886000000.000000.<br />
The statement has been terminated.