<Extract>
MERGE Wine.Producer AS CurrentData
USING
(
SELECT DISTINCT ProducerID, ProducerName
FROM Wine.Import
) AS NewData
ON CurrentData.ProducerID = NewData.ProducerID
WHEN MATCHED THEN
UPDATE
SET
CurrentData.ProducerName = NewData.
</Extract>
SQL Prompt fails to suggest any of the column names for the "NewData" object (or any other for that matter) after I enter the final period as shown in the extract. No error messages of any kind are generated.
MERGE Wine.Producer AS CurrentData
USING
(
SELECT DISTINCT ProducerID, ProducerName
FROM Wine.Import
) AS NewData
ON CurrentData.ProducerID = NewData.ProducerID
WHEN MATCHED THEN
UPDATE
SET
CurrentData.ProducerName = NewData.
</Extract>
SQL Prompt fails to suggest any of the column names for the "NewData" object (or any other for that matter) after I enter the final period as shown in the extract. No error messages of any kind are generated.