I have the following query:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE YourProcedure AS
insert into msbtotal.dbo.newclients
SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join
msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id =
msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is
null
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
that is supposed to check for any differences between the memberdata table in TCMS_members and MSBTotal and see if there are null values. I have supplied some sample data to the TCMS_members database to check if this is working and it doesnt appear to be inserting any data into the newclient database at all. It's also not giving me any errors.
How this is supposed to happen is that these two databases compare each other, and then if there is "new" data, that data is then inserted into my "newclient" table. Can anyone offer me an idea as to why they think that this isn't giving me any data?
Thank you
Doug
Inserting data into another database
Posted - 09/16/2010 : 15:41:36
