SQL Server 2000

I can't decide if this statement should be a insert or a Update
What I need to do is for option and feature from table item I should create a record in table itemsysmbolstatus. the information is what should be populated. The itemid will be carried over from table item and symbolstatusid is set to the GUID which is 'ED860B5D-53FF-4071-B74A-E826411C3397'
this is my script.

SELECT i.itemid INTO #tblItemSymbolStatus
FROM tblItem i
LEFT JOIN tblItemSymbolStatus iss ON i.ItemID = iss.ItemID
WHERE iss.ItemID is NULL AND
SymbolStatusID = 'ED860B5D-53FF-4071-B74A-E826411C3397'

INSERT INTO tblItemSymbolStatus (ItemSymbolStatusID)
SELECT ItemID,
('BF972786-4C93-4DAC-B3C7-928315070114',
'20A83DF6-3311-4B19-A4DA-8B72BE7515DE',
'16C7A03E-B255-4CEE-A2A1-8605612C302C',
'A18C8817-5D04-4268-9890-EDAD3DD2B67D',
'D05EFB52-C1F3-4006-A62C-67C9BA98F35',
'E13B5701-B6C6-43C5-93C3-785E4669A652',
'F8E20C3E-ED42-468C-9FC9-87864F298F93') AS ItemSymbolStatusID --- all these are new records that are suppose to be added to the itemsysbolstatusid

FROM #tblItemSymbolStatus

DROP table #tblItemSymbolStatus

 

This is a matter of understanding what you just said. You've answered your own question.

create=insert
append=update

 

Update or Insert

Then why am I getting an error..

 

because you're inserting this


'BF972786-4C93-4DAC-B3C7-928315070114',
'20A83DF6-3311-4B19-A4DA-8B72BE7515DE',
'16C7A03E-B255-4CEE-A2A1-8605612C302C',
'A18C8817-5D04-4268-9890-EDAD3DD2B67D',
'D05EFB52-C1F3-4006-A62C-67C9BA98F35',
'E13B5701-B6C6-43C5-93C3-785E4669A652',
'F8E20C3E-ED42-468C-9FC9-87864F298F93'

into one record