SELECT commits.*, SPACE(30) as Part_No, SPACE(5) as Revision, SPACE(40) as Customer, SPACE(10) as Type,SPACE(35) AS "refPartNo", UPDATE #target SET "refPartNo" = part_noMartinaJ
>SELECT * INTO #Attrib FROM spot_light_Dbo...prodattrib WHERE crefpart <> '' > > SELECT commits.*, SPACE(30) as Part_No, SPACE(5) as Revision, SPACE(40) as Customer, SPACE(10) as Type,SPACE(35) AS refPartNo, > SPACE(10) as Part_Class, space(3) as buyer_type,so.price,ack.sono,ack.poack, > ISNULL(atr.nSMT_PlcMnts, 00000) As nSMT_PlcMnts, > ISNULL(atr.nSMT_LItems, 00000) As nSMT_LItems, ISNULL(atr.nCalc_Comp, 1) As nCalc_Comp, > ISNULL(atr.nBtlNkTPut, 00000.00) As nBtlNkTPut, ISNULL(atr.nProdCt, 00000.00) As nProdCt , > ISNULL(atr.nBtlNkYld, 000) As nBtlNkYld, Space(250) As Sub_Assy, NULL As ShipStart, > 0000000.00 As DailyShip, NULL As ShipEnd, atr.cCritComnt, cBtlNkOp As BtlNkOp, nKit_LItems > INTO #target > FROM table > JOIN other table > JOIN (select statement) > JOIN #attrib atr >>
>UPDATE #target SET type = 'FORECAST' WHERE ref like 'FC%'; --> no problem saving >UPDATE #target SET revision = part_no --> no problem saving >UPDATE #target SET refPartNo = part_no --> Msg 207, Level 16, State 1 Invalid column name 'refPartNo'>