Can you post the exact statement you use to delete global temp table?

chandramohann, any kind of query from 3 tables containing under 50k rows all together should not take more than couple of seconds, unless you running it on a server with...

+ CHAR(13) + CHAR(10) +

If other strings are NVARCHAR and result must be NVARCHAR you need to use

+ NCHAR(13) + NCHAR(10) +

Check permissions for the account running SQL Server Agent.

It could be not the same as for SQL Server.

You can easily read Unix flat files using BULK INSERT with a little help from Format File.

See "BULK INSERT", "Using Format Files" topics in BOL.

If you would open BOL you could find this in there:

A nonnullable timestamp column is semantically equivalent to a binary(8) column. A nullable timestamp column is semantically equivalent to a...

How do you "verify that all data on these equivalent tables on both databases are syncronized (to avoid missing data)"?

Consider that insert into view will be single transaction.

You don't need to play with transactions, with locking. SQL Server will do it for you.

And you can perform set inserts, not...

It does not make any sense.

Timestamp does not hold any useful information, so there is no point to copy it across.

Only point of timestamp column - is to indicate if...

DECLARE @InvoicesToReturn

SET @InvoicesToReturn = 2 -- ideally this value must be stored in database

SET ROWCOUNT @InvoicesToReturn

SELECT RowID

INTO #SelectedInvoices

FROM dbo.Invoice

ORDER BY ....

SET ROWCOUNT 0

SELECT I.*

FROM dbo.Invoice I

INNER JOIN #SelectedInvoices S ON...

I would create a view from these 2 tables and INSTEAD OF INSERT rigger on it.

Trigger will populate the tables using code similar yours.

You may add grouping to eliminate duplicate...

I don't see any difference between 'Allegic to Dogs, Cats, Shellfish' and 'Allegic to Dogs, Shellfish, Cats'?

So, there not gonna be any cobinations.

Every assessment sets some current conditions.

After every assessment...

Jeff, can you appoint "End Date" for your medical condition?

You must have very good connections up there to do it.

Most people don't.

That's why...

You need to read EXECUTE topic in BOL.

@return_status is what you gonna be interested in the most.

It does not explain why you need RBAR operation.

INSERT INTO Item

(LegalNumber, Col list)

SELECT N.LegalNumber, ColumnsList

FROM DataSourse S

INNER JOIN LegalNumbers N ON S.SomeID = N.SomeID