Looking for an best idea for my below problem

Posted by Kondapallisrinivas under Others on 7/5/2013 | Points: 10 | Views : 732 | Status : [Member] | Replies : 2
Dear All

Can any one suggest some best idea for my below problem.

We are getting two different results from two different sources.

500+ rows from source 1.
500+ rows from source 2.

So we need to compare the result 1 with result 2 and after comparison need missing data information as a as a final result.

Requesting all suggest some idea to compare the data and get missing data information…..

Feel free to send a mail(kondapallisrinivas15@gmail.com) if you need any more information or suggest some ideas.




Responses

Posted by: Neeraaj.Sharma on: 7/5/2013 [Member] Starter | Points: 25

Up
0
Down

If this question belongs to sql server than this can be doe by using Except Operator,
please see the example below , if any other query then ask.



Create table #table1 (id int)
insert into #table1
select 1 union all
select 2
GO

Create table #table2 (id int )
insert into #table2
select 1 union all
select 3
GO


Select * FRom #table1
except
Select * FRom #table2



visit my blog : www.tutorialsqlserver.com


Kondapallisrinivas, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kondapallisrinivas on: 7/5/2013 [Member] Starter | Points: 25

Up
0
Down
Hello All

Can any one suggest an good idea, to proceed further.

Kondapallisrinivas, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response