Msg 9803, Level 16, State 1, Line 1
Invalid data for type
"numeric".
Fix: Use TO_CHAR function. See below
example
SELECT * FROM OPENQUERY(TEST,'SELECT PRIMARY_ID,
ORGANIZATION,
SUB_LINE_STATUS_CODE,
ORGANIZATION_ID,
CONTRACT_NUMBER,
TO_CHAR(CLE_ID) AS CLE_ID,
TO_CHAR(LOCATION_ID) AS LOCATION_ID,
INSTANCE_NUMBER,
THIRD_PARTY_FLAG,
SYSTEM_STATUS,
TO_CHAR(SALESREP_ID) AS SALESREP_ID,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE6,
FROM TEST>TEST_V')
Msg 206, Level 16, State 2, Procedure
SP_Sync_ContractLineSummary, Line 27
Operand type clash: datetime2 is incompatible with
int
Fix: Check if there are any datetime columns
declared with datatype int and alter it.
alter table [dbo].[TestSummary]
alter column
[ConversionRateDate] datetime null
Refer below Microsoft link for datatype mapping
No comments:
Post a Comment