Operand type clash...pls - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Operand type clash...pls

Author

Topic

sreehari
Starting Member

37 Posts

Posted - 2006-07-09 : 23:05:02

Hi all

When i try to insert the data using the follwing command..
i am getting the follwoing error..

May i know how can i resolve it...
Thanks.

Server: Msg 206, Level 16, State 2, Line 1
Operand type clash: ntext is incompatible with datetime
Server: Msg 260, Level 16, State 1, Line 1
Disallowed implicit conversion from data type datetime to data type numeric, table 'A2RD.dbo.DIM_SALES_ORDER_DETAIL', column 'REQUEST_ID'. Use the CONVERT function to run this query.

INSERT INTO DIM_SALES_ORDER_DETAIL
(SALES_ORDER_ID, SALES_ORDER_DETAIL_ID,
ORDER_STATUS_CODE, ORDER_STATUS_DESC,
CREATE_DATE_TIME,
PROGRAM_ID, CURRENCY_CODE, CONTRACT_NUMBER,
SKU_NUMBER, SKU_DESCRIPTION,
EXTENDED_PRICE, ORDER_QTY,
UNIT_PRICE, ACTUAL_PRICE,
LINE_TAX, LINE_NUMBER,
ISV_SALES_ORG_CODE, PRODUCT_FAMILY_CODE,
CONTRACT_SITE_ID, SITE_GROUP,
POETIC_ORDER_TYPE_CODE, EXPIRE_DATE_TIME,
LAST_RENEWAL_NOTICE_DATE, POETIC_ORDER_TYPE_DESC, PRODUCT_FAMILY_DESC,
ISV_SALES_ORG_DESC,
PRODUCT_TYPE_CODE, PRODUCT_TYPE_DESC, AUTH_REQUEST_DATE, AUTHORIZED_DATE_TIME,
PAYMENT_TERM_CODE, PAYMENT_TERM_DESC,
PAYMENT_METHOD_CODE, PAYMENT_METHOD_DESC,
TAX_RATE, MANUAL_PRICING_ACTION_CODE,
MANUAL_PRICING_ACTION_DESC,
MANUAL_PRICING_VALUE, HEADER_TAX, PRICE_CLASS_CODE,
PRICE_CLASS_DESC,
SKU_START_DATE, SKU_END_DATE, SHIP_QTY, PROGRAM_CODE,
UPD_DATE, REQUEST_ID, RENEW_SUMMARY_STATUS_CODE,
INTEGRATION_MODE_CODE, LICENSE_PURCHASE_DATE, ISV_PROPERTY_ID_1, MANUAL_PRICING_REASON_CODE,
SALES_ORDER_PUB_XREF_NUM, TRADER_ID)
SELECT SALES_ORDER.SALES_ORDER_ID, SALES_ORDER_DETAIL.SALES_ORDER_DETAIL_ID,
SALES_ORDER.ORDER_STATUS_CODE, ORDER_STATUS.DESCRIPTION,
DBO.TO_CHAR(SALES_ORDER.CREATE_DATE_TIME, 'DD-MON-YYYY'),
SALES_ORDER.PROGRAM_ID, SALES_ORDER.CURRENCY_CODE, SALES_ORDER_DETAIL.CONTRACT_NUMBER,
SALES_ORDER_DETAIL.SKU_NUMBER, SALES_ORDER_DETAIL.SKU_DESCRIPTION,
SALES_ORDER_DETAIL.EXTENDED_PRICE, SALES_ORDER_DETAIL.ORDER_QTY,
SALES_ORDER_DETAIL.UNIT_PRICE, isnull(SALES_ORDER_DETAIL.ACTUAL_PRICE, 999999999),
SALES_ORDER_DETAIL.TAX, SALES_ORDER_DETAIL.LINE_NUMBER,
SALES_ORDER.ISV_SALES_ORG_CODE, PRODUCT.FAMILY,
CONTRACT_SITE.CONTRACT_SITE_ID, (CONTRACT_SITE.SITE_PUB_ID +' '+CONTRACT_SITE.SITE_NAME) AS

SITE_GROUP,
SALES_ORDER.POETIC_ORDER_TYPE_CODE, SALES_ORDER.EXPIRE_DATE_TIME,
SALES_ORDER.LAST_RENEWAL_NOTICE_DATE, POETIC_ORDER_TYPE.DESCRIPTION, FAMILY.DESCRIPTION,
ISV_SALES_ORG.DESCRIPTION,
PRODUCT.PRODUCT_TYPE, PRODUCT_TYPE.DESCRIPTION, SALES_ORDER.AUTH_REQUEST_DATE,

SALES_ORDER.AUTHORIZED_DATE_TIME,
SALES_ORDER.PAYMENT_TERM_CODE, PAYMENT_TERM.DESCRIPTION,
SALES_ORDER.PAYMENT_METHOD_CODE, PAYMENT_METHOD.DESCRIPTION,
SALES_ORDER_DETAIL.TAX_RATE, SALES_ORDER_DETAIL.MANUAL_PRICING_ACTION_CODE,
MANUAL_PRICING_ACTION.DESCRIPTION,
SALES_ORDER_DETAIL.MANUAL_PRICING_VALUE, SALES_ORDER.TAX, SALES_ORDER.PRICE_CLASS_CODE,
PRICE_CLASS.DESCRIPTION,
SALES_ORDER_DETAIL.SKU_START_DATE, SALES_ORDER_DETAIL.SKU_END_DATE, SHIP_QTY,

PROGRAM.PROGRAM_CODE,
SALES_ORDER_DETAIL.UPD_DATE, SALES_ORDER.REQUEST_ID, SALES_ORDER.RENEW_SUMMARY_STATUS_CODE,
SALES_ORDER.INTEGRATION_MODE_CODE, SALES_ORDER_DETAIL.LICENSE_PURCHASE_DATE,

PRODUCT.ISV_PROPERTY_ID_1, MANUAL_PRICING_REASON_CODE,
SALES_ORDER_PUB_XREF_NUM, TRADER_ID
FROM SALES_ORDER, SALES_ORDER_DETAIL, CONTRACT_SITE, PRODUCT, PROGRAM,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'ORDER_STATUS') ORDER_STATUS,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'POETIC_ORDER_TYPE') POETIC_ORDER_TYPE,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'FAMILY') FAMILY,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'ISV_SALES_ORG') ISV_SALES_ORG,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'PRODUCT_TYPE') PRODUCT_TYPE,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'PAYMENT_TERM') PAYMENT_TERM,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'PAYMENT_METHOD') PAYMENT_METHOD,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'MANUAL_PRICING_ACTION') MANUAL_PRICING_ACTION,
(SELECT * FROM LKP_STATIC_DATA WHERE LIST_NAME = 'PRICE_CLASS') PRICE_CLASS
WHERE SALES_ORDER.SALES_ORDER_ID = SALES_ORDER_DETAIL.SALES_ORDER_ID
AND SALES_ORDER_DETAIL.CONTRACT_SITE_ID *= CONTRACT_SITE.CONTRACT_SITE_ID
AND SALES_ORDER_DETAIL.PRODUCT_ID = PRODUCT.PRODUCT_ID
AND SALES_ORDER_DETAIL.PROGRAM_ID = PROGRAM.PROGRAM_ID
AND SALES_ORDER.ORDER_STATUS_CODE = ORDER_STATUS.CODE
AND SALES_ORDER.POETIC_ORDER_TYPE_CODE = POETIC_ORDER_TYPE.CODE
AND SALES_ORDER.ISV_SALES_ORG_CODE *= ISV_SALES_ORG.CODE
AND SALES_ORDER.PAYMENT_TERM_CODE *= PAYMENT_TERM.CODE
AND SALES_ORDER.PAYMENT_METHOD_CODE = PAYMENT_METHOD.CODE
AND SALES_ORDER_DETAIL.MANUAL_PRICING_ACTION_CODE *= MANUAL_PRICING_ACTION.CODE
AND SALES_ORDER.PRICE_CLASS_CODE *= PRICE_CLASS.CODE
AND PRODUCT.FAMILY = FAMILY.CODE
AND PRODUCT.PRODUCT_TYPE = PRODUCT_TYPE.CODE;

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-07-09 : 23:17:42

Isn't the error message clear ? And also how to resolve it ?

"Disallowed implicit conversion from data type datetime to data type numeric, table 'A2RD.dbo.DIM_SALES_ORDER_DETAIL', column 'REQUEST_ID'. Use the CONVERT function to run this query."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-10 : 02:37:10

Are you using SQL Server?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources