Hi All,
when i am trying to insert records from excel sheet to wko table in my database. My Excel sheet contains 400 records. I am getting the error message. please check this code and advise me.
INSERT [dbo].[wko]([wko_workorderid], [wko_itemid],[wko_origstartdate], [wko_startdate],
[wko_origrequireddate], [wKO_requireddate],[wko_routusedflag], [wko_barcodeprintflag],
[wko_printflag], [wko_backflushflag],[wko_fwdschedflag], [wko_wIPInspflag], [wko_startqty],
[wko_origstartqty],[wko_requiredqty], [Wko_origrequiredqty], [wko_scrapqty], [wko_scrapamt],
[wko_rejectqty], [wko_rejectamt], [wko_completeqty], [wko_statuscode], [wko_workordertypecode],
[wko_lastsplitnbr], [wko_actualsetupamt],[wko_actuallabamt], [wko_actualmatlamt], [wko_actualoutplantamt],
[wko_actualvarburdamt],[wko_actualfixburdamt], [wko_actualmatlburdamt],[wko_stdlabamt],
[wko_stdoutplantamt], [wko_stdvarburdamt],[wko_stdfixburdamt],[wko_stdmatlburdamt], [wko_estlabamt],
[wko_estoutplantamt], [wko_estvarburdamt], [wko_estfixburdamt], [wko_estmatlburdamt],
[wko_closedlabamt], [wko_closedmatlamt], [wko_closedoutplantamt],[wko_closedvarburdamt],
[wko_closedfixburdamt], [wko_closedmatlburdamt],[wko_issueovershort],[wko_backflushoperationseq],
[wko_backflushlabor],[wko_labcostpluspercent], [wko_matlcostpluspercent])
SELECT [wko_workorderid], [wko_itemid],[wko_origstartdate], [wko_startdate],
[wko_origrequireddate], [wKO_requireddate],[wko_routusedflag], [wko_barcodeprintflag],
[wko_printflag], [wko_backflushflag],[wko_fwdschedflag], [wko_wIPInspflag], [wko_startqty],
[wko_origstartqty],[wko_requiredqty], [Wko_origrequiredqty], [wko_scrapqty], [wko_scrapamt],
[wko_rejectqty], [wko_rejectamt], [wko_completeqty], [wko_statuscode], [wko_workordertypecode],
[wko_lastsplitnbr], [wko_actualsetupamt],[wko_actuallabamt], [wko_actualmatlamt], [wko_actualoutplantamt],
[wko_actualvarburdamt],[wko_actualfixburdamt], [wko_actualmatlburdamt],[wko_stdlabamt],
[wko_stdoutplantamt], [wko_stdvarburdamt],[wko_stdfixburdamt],[wko_stdmatlburdamt], [wko_estlabamt],
[wko_estoutplantamt], [wko_estvarburdamt], [wko_estfixburdamt], [wko_estmatlburdamt],
[wko_closedlabamt], [wko_closedmatlamt], [wko_closedoutplantamt],[wko_closedvarburdamt],
[wko_closedfixburdamt], [wko_closedmatlburdamt],[wko_issueovershort],[wko_backflushoperationseq],
[wko_backflushlabor],[wko_labcostpluspercent], [wko_matlcostpluspercent]
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Documents and Settings\mohammed\Desktop\test.xls;IMEX=1',
'SELECT * FROM [Sheet1$]') Rowset_1
WHERE (wko_workorderid LIKE N'A%')
I am getting error message like this:
Server: Msg 512, Level 16, State 1, Procedure WKO_ITrig, Line 20
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Thanks