accesser2003
Registered User.
- Local time
- Today, 19:09
- Joined
- Jun 2, 2007
- Messages
- 124
I would like to write a stored procedure that insert data from table [SourceEvents] located at a DB linked to DSN called CARDAX into another table [AllAttendanceEvents] located at the same DB of the stored procedure, which this DB is linked to a DSN called BAHRAIN.
If both tables are located at the same databases, the stored procedure will be as follow
Create Stored Prcoedure SP1 AS
INSERT INTO dbo.AllAttendanceEvents.*
SELECT dbo.SourceEvents.*
FROM dbo.SourceEvents
But how it will be if the case as explained above??
Thanks,
If both tables are located at the same databases, the stored procedure will be as follow
Create Stored Prcoedure SP1 AS
INSERT INTO dbo.AllAttendanceEvents.*
SELECT dbo.SourceEvents.*
FROM dbo.SourceEvents
But how it will be if the case as explained above??
Thanks,