using aliases on delete/update statement

[chris123321]

How would I shorten this query by using aliases?

        DELETE tblEventContacts
        FROM tblEventContacts 
          INNER JOIN @Contact C
            ON tblEventContacts.ContactID_F = C.ContactID
        WHERE tblEventContacts.EventID_F = @EventID AND C.Removed = 1

        UPDATE tblEventContacts 
        SET tblEventContacts.Accepted = C.Accepted, 
            tblEventContacts.Declined = C.Declined, 
            tblEventContacts.DidNotRespond = C.DidNotRespond,
            tblEventContacts.Attended = C.Attended, 
            tblEventContacts.Comment = C.Comment
        FROM tblEventContacts 
        INNER JOIN @Contact C
          ON tblEventContacts.ContactID_F = C.ContactID
        WHERE C.Modified = 1 AND tblEventContacts.EventID_F = @EventID

Thanks.

 

[SQLSister]

The same way you used an alias for @contact

"NOTHING is more important in a database than integrity." ESquared

 

[ca8msm]

Here's an example of how to use an alias. I'm sure you'll be able to do the rest yourself.

Select [!]p[/!].Name
From Persons [!]p[/!]

____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.