Red Gate forums :: View topic - Formatting help
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

Formatting help

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



Joined: 04 Aug 2010
Posts: 1

PostPosted: Wed Aug 04, 2010 12:39 am    Post subject: Formatting help Reply with quote

Does anyone know how to get the following formatting to work?

From
IF EXISTS ( SELECT TOP 1
1
FROM
inserted )
IF EXISTS ( SELECT TOP 1
1
FROM
deleted )
/*Update Block*/

To
IF EXISTS ( SELECT TOP 1 1 FROM inserted )
IF EXISTS ( SELECT TOP 1 1 FROM deleted )

AND
This
FROM
deleted
INNER JOIN INSERTED
ON DELETED.PeopleId = INSERTED.PeopleId

to
FROM deleted
.INNER JOIN INSERTED
ON DELETED.PeopleId = INSERTED.PeopleId

Thanks all
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 684
Location: Cambridge

PostPosted: Thu Aug 05, 2010 9:19 am    Post subject: Reply with quote

Many thanks for your post.

We have logged two support calls for you F0037421 and F0037422.
_________________
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