SQL Update Statement - using SubSelect

Geeks With Blogs

94 Posts | 66 Comments

SQL Server: I need to get to a remote server and management studio is broken. How can I login without ssms?

1524 views

Visio 2010: How do I change the Title when in Borders & Titles?

1026 views

SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer

835 views

SQL Server: Is there a query I can use that generates similar output to Activity Monitor?

481 views

SQL Server 2012: How do I set "Edit top" rows to a different number?

467 views

Ask Paula! ...bringing you notes from the field...

<< Where is my Host file on Windows? | Home | A 'Get it Done Now!' Approach for transforming SQL Server Data to XML Data >>

SQL Update Statement - using SubSelect

Comments (1) | Share

This is a simple, but helpful example of changing a boolean or bit flag in a table to 'True' when the condition in the subSelect is met. In this context, the SQL statement finds all the cases where a sales agent's email exists in the Metro_SalesForce table and exists in the related table Metro_SalesForceMult. The Metro_SalesForceMult table contains the USA state assignments only for sales agents representing more than a single state.

UPDATE Metro_SalesForce
SET multipleStates = 'True'
WHERE Metro_SalesForce.email in
(
     Select x.email
       From Metro_SalesForce x, Metro_SalesForceMult y
        Where x.email = y.email
) Posted on Friday, May 29, 2009 10:34 AM SQL | Back to top

Comments on this post: SQL Update Statement - using SubSelect

No comments posted yet.

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Enter the code shown above

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure