How can we help you today? How can we help you today?

Formatting help

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
CraigRichards
0

Comments

1 comment

Sort by
  • Anu D
    Many thanks for your post.

    We have logged two support calls for you F0037421 and F0037422.
    Anu D
    0

Add comment

Please sign in to leave a comment.