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 |
|
mentor101
Starting Member
2 Posts |
 Posted - 2011-06-09 : 12:50:58
|
| I have a realy simple report to create that I have done in Crystal already but can't seem to figure out how to do the same in resporting services. I have 2 files with order number. Both are ODBC connections. I just need to display order number that are in the first and not in the second. Should be simple I would think.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-06-12 : 04:34:45
|
| you need to get them onto tow tables and then use LEFT JOIN and where condition check on NULL for pk column of second table to get records in one table not in second------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
scprideandms
Starting Member
2 Posts |
Posted - 2011-06-21 : 14:10:20
|
| Use an except join |
|
|
|
|
|
|
Unmatched records 2 data sources