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 |
|
dougancil
Posting Yak Master
217 Posts |
 Posted - 2011-02-24 : 13:35:45
|
| I have the following queries:insert into msbtotal.dbo.newclientsSELECT distinct tcms_members.dbo.memberdata2.* FROM tcms_members.dbo.memberdata2 left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata2.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id isnullselect distinct * into newclientsfrom msbtotal.dbo.newclientsthat is supposed to compare two databases and then put the new clients into a newclients database but isn't working. Can anyone offer an idea as to why? What I'm needing to have happen here is that whatever new clients are put into the tcms_members.dbo.memberdata when compared with the msbtotal.dbo.memberdata, that the new clients are then put into the newclient database.I've ran this and notice that it's not working but it also produces no error. Thank youDoug |
|
|
|
|
|
Compasion of two databases