Prompt Failure w/MERGE statements

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Prompt Failure w/MERGE statements

Postby RRB » Wed Nov 10, 2010 5:32 pm

<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.
RRB
 
Posts: 4
Joined: Fri Jun 19, 2009 4:10 pm

Postby RRB » Wed Nov 10, 2010 5:34 pm

Correction: the prompt failures are ONLY related to the references to the "NewData" object.
RRB
 
Posts: 4
Joined: Fri Jun 19, 2009 4:10 pm


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 1 guest