Welsh Corgi (8/3/2011)

---

Do you know what DDL and sample data is?

Iulian -207023 (8/3/2011)

---

or instead of :

ARRIVAL_SCHEDULE_DT <= dateadd(mm, 3, getdate())

you can use this condition too:

datediff(mm, ARRIVAL_SCHEDULE_DT, getdate()) <= 3

Iulian

John Mitchell-245523 (8/3/2011)

---

Something like this?

SELECT <column list>

FROM MyTable

EXCEPT

SELECT <column list>

FROM MyTable

WHERE PORT_CD = 'BEZEE'

AND ARRIVAL_SCHEDULE_DT < dateadd(mm, 3, getdate())

John

Dwayne Dibley (8/3/2011)

---

WHERE PORT_CD = 'BEZEE'

AND ARRIVAL_SCHEDULE_DT < = dateadd(mm, 3, getdate()

steveb. (7/26/2011)

---

You can setup one-way transactional replication.

Also I don't see how running an SSIS packages is any more secure..

Gianluca Sartori (7/26/2011)

---

Did you register the linked server?

Gianluca Sartori (7/26/2011)

---

This should do:

Select *

Into #TempA

From TB_ARTICLE

Where ARTICLE_ID not in (Select ARTICLE_ID from remote_server_name.database_name.schema_name.TB_ARTICLE)

EXEC('USE database_name; set identity_insert TB_ARTICLE on') AT remote_server_name

Insert into remote_server_name.database_name.schema_name.TB_ARTICLE

Select * From #TempA

Hope this helps

Gianluca

Gianluca Sartori (7/26/2011)

---

Looks like a good place for replication.

Have you checked that option?

steveb. (7/26/2011)

---

You can setup one-way transactional replication.

Also I don't see how running an SSIS packages is any more secure..