Solved

Store Result after executing 2 Select statement by EXCEPT

Posted on 2010-11-26
1
346 Views
Last Modified: 2012-05-10

I have an SQL Statement:

select x,y from AC
except
select x,y from DC

I want to store the result set of this query into another table in the database. How can I do it? Please help.

Thanks
Ziad
0
Comment
Question by:Ziad Iqbal
1 Comment
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 34216688
you mean:
insert into othertable ( x,y )
select x,y from AC
except
select x,y from DC

Open in new window

0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored Procedure 2 47
CROSS APPLY 4 45
How to revise an Access 2003 query into a SQL Server 2008 SQL statement? 1 25
Sql Query Datatype 2 19
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now