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 |
|
sardinka
Posting Yak Master
142 Posts |
 Posted - 2005-05-12 : 11:01:32
|
| I have 2 tables with the following structure:CREATE TABLE [dbo].[table1] ( [RID] [int] IDENTITY (1, 1) NOT NULL , [RText] [varchar] (400) NULL , [DateModified] [datetime] NULL ) ON [PRIMARY]CREATE TABLE [dbo].[Table2] ( [GrpRID] [int] IDENTITY (1, 1) NOT NULL , [GrpID] [varchar] (10) NOT NULL , [RID] [int] NOT NULL , [Status] [bit] NULL , [SortOrder] [int] NULL , [DateModified] [datetime] NULL ) ON [PRIMARY]GOI am transfering 2 table between 2 SQL server based on GrpRID from table2.Since RID is identity in table1 sometimes it is different text for spesificRid in second server. Some how I need to get the match the right text from server1to server2 and if text doesn't exists create a bew entry in table1 with the update to table2wich should reflect correct RID. |
|
|
|
|
|
Logic