<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
T-SQL
,
EXCEPT
Items 1 to 7 of 7
Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)
A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.
Read more...
By
Jeff Moden
2012/03/29
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
13,203 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Read more...
By
David Poole
2011/12/23 (first published: 2009/07/20)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
39,452 reads
exceptional logic
Read more...
By
BenWard
2011/10/11
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,435 reads
The EXCEPT and INTERSECT Operators in SQL Server
The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.
Read more...
By
Additional Articles
2011/03/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
Rate this
|
Briefcase
|
5,321 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Read more...
By
David Poole
2011/12/23 (first published: 2009/07/20)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
39,452 reads
Caution with EXCEPT
The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.
Read more...
By
Stephen Tirone
2010/01/18
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
12,855 reads
Intersect, Except, Union, All and Any
Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.
Read more...
By
David Poole
2011/12/23 (first published: 2009/07/20)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
39,452 reads
Items 1 to 7 of 7
Tags
intersect
(2)
union
(2)
group by
(1)
having
(1)
subquery
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
