Very neat! Thanks.

Vijaya Kadiyala (4/8/2009)

---

Hi jeff, this is not about replication.:-D Its about moving...

I would like to take this issue into a different direction. As I mentioned above, I am in the planning phase...

No it is not. One of the legacy applications (A) uses 'Access_Level' as VARCHAR which only uses "1", "2", "3",....."8". The second application (B) uses the 'Access_Leval'...

Do I have to use CAST/CONVERT when I change data type from [VARCHAR] to [int]? My VARCHAR has only values of "1", "2", "3", .... "8". I read something about...

I was trying to find which records in table A that not...

When you say compare, you want to find the records which are not in another table or find teh common records or !!

In either case If you use FULL...

Table 'ClientsDB.Users' is in 'MyClientsDB' database and table 'MarketingDB.Users' is in 'MyMarketingDB'. Table 'ClientsDB.Users' has 12,000 records that I want to copy to 'MarketingDB.Users'. I got the number of records...

Awesome, worked like a charm.

My bad. I am using SQL...

I changed the 20 to 64 and I am using this random string as a handshake token between two applications. My next task is to replicate this random string on...

I think I got it. I entered 'dbo.fn_RandomString()' and it worked.

Very nice sample. So now I have a function called 'fn_RandomString' and in the table field I set the 'Default Value for Binding' to 'fn_RandomString()'. But when records are inserted...

Ramesh (3/14/2009)

---

Doesn't you mean to INSERT new records from TableA to TableB than to UPDATE? If not the latter case, then you have to do something like this.

INSERT INTO...

I know that the following will do the comparison, but I'm not sure about the update in the same code.

Select FilePath

From tblArticles

Where NOT EXISTS (Select URL

From rating_urls

Where tblArticles.filepath = rating_urls.url

)