Looking for an best idea for my below problem

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	Hello All Can any one suggest an good idea, to proceed further. Kondapallisrinivas, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts