>Hi,
>
>I am writing (what appears to be) a simple stored procedure where the first equal sign (=) always shown with squiggly red underline and the message 'Incorrect syntax new ='
>
>
> IF NOT EXISTS (SELECT @InvenPk = INVEN_PK, @UnitPrice = Unit_Price, @CurrStockQty = INSTOCK FROM Parts where inv_code = @Inv_Code)
>
>
>If I remove the first column select the error moves to the next one.
>
>What am I missing?
Disregard this, I did not see the responses that followed.
Dmitry,
What is the rest of the statement? Can you execute with just the inner SELECT statement if you remove the 'IF NOT EXISTS' portion?
Timothy Bryan