What are the challenges you face when working across database platforms? Take the survey
Options

SQL-Prompt Professional layout Merge statement

bauerjubauerju Posts: 33 Bronze 3
edited November 17, 2010 8:29AM in SQL Prompt Previous Versions
Hi
I'am using SQl-Prompt 3.9.0.43 on SSMS 2008 with SqlServer 2008 and have problems with the new MERGE-statement.

Layout and candidate listing don't work:
for example:
DECLARE @T1 TABLE ( Tab1 INT,TAb2 INT )
DECLARE @T2 TABLE ( Tab1 INT,TAb2 INT )
MERGE @T1 S USING @T2 D ON S.Tab1 = D.Tab1 WHEN MATCHED THEN UPDATE SET Tab2 = d.Tab2 WHEN NOT MATCHED THEN INSERT ( Tab1,TAb2 ) VALUES ( d.tab1,d.tab2 ) ;


It should be layoutet like
MERGE @T1 S
____USING @T2 D
________ON S.Tab1 = D.Tab1
____WHEN MATCHED THEN
________UPDATE
____________SET Tab2 = d.Tab2
____WHEN NOT MATCHED THEN
________INSERT ( Tab1,TAb2 )
____________VALUES ( d.tab1,d.tab2 ) ;


What can I do?

Jürgen

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    Latest patch for SQL Prompt 3 will fix the issue SQL Prompt not prompting MERGE in candidate list and the formatting issue is fixed in SQL Prompt 4.

    If you email us your serial number I can find the best option for you.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.