SQL-Prompt Professional layout Merge statement

[bauerju]

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

[Anu Deshpande]

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