Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shemayb
Posting Yak Master
159 Posts |
 Posted - 2007-11-20 : 21:18:44
|
Is there a way to create a query which compares two result sets of results?for example the result set of my first select statement is 7,1,8 and the second result set is 7,1,9..is there a query wherein i can compare the two results? i just wanted to reveal that there is a diffrence between the two..thank you.. Funnyfrog |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-20 : 21:27:03
|
insert the result of both select statement into a separate temp table and use FULL OUTER JOIN to compare
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2007-11-20 : 21:43:38
|
| Is that also applicable if in my select statement is compose of 3 joined tables?Funnyfrog |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-20 : 21:44:59
|
it doesn't matter
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2007-11-20 : 21:45:48
|
| ok i will try it now..thank you..Funnyfrog |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-21 : 00:48:29
|
| http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
comparing set of results