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

Formatting help

CraigRichardsCraigRichards Posts: 2
edited August 5, 2010 4:19AM in SQL Prompt Previous Versions
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

Comments

Sign In or Register to comment.