Red Gate forums :: View topic - SQL-Prompt Professional layout Merge statement
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

SQL-Prompt Professional layout Merge statement

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
bauerju



Joined: 18 Apr 2008
Posts: 5

PostPosted: Wed Nov 19, 2008 11:33 am    Post subject: SQL-Prompt Professional layout Merge statement Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Wed Nov 17, 2010 2:29 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group