It could look like this:

CREATE TRIGGER TR_TEST

ON MyTable

INSTEAD OF INSERT

AS

BEGIN

TRUNCATE TABLE MyTable

INSERT INTO MyTable

SELECT *

FROM INSERTED

END

Hope this helps

Gianluca

You cannot BULK INSERT from HTTP. You will have to download the file first.

The file can be downloaded with some tool like cURL (http://curl.haxx.se/).

Hope this helps

Gianluca

I suppose indexes are the same and statistics are up to date...

I think some more details are required here to understand what goes on. Please take a look at this...

Try this:

http://dotnetslackers.com/articles/net/BarcodeImageGenerationMadeEasy.aspx

1st Google result for "barcode .net image", btw.

Don't worry: I lost hours and hours in the past because of typos.... and I still do!:-D

Would renaming Priotity to Priority fix the issue?

DECLARE @PriorityAmount table (

Amount Decimal(18,2)

,Priotity int) -- shouldn't be Priority??

I would not install fonts to display barcodes, I'd rather build the barcode image with some software and store the picture in a binary column.

You could use barbecue[/url], for instance.

Hope...

To ensure the results are always sorted in the same way you have to add an ORDER BY clause.

If you don't provide an explicit order, results are not sorted in...

laptop: got one, company paid

sql books: never seen one

university: cs degree

driving license: you must have it here to survive

certification: I'm planning to take one, but I will have to pay...

.... ooops!

That's what I was trying to say, but something short-circuited between my mind and my fingers...

Thanks for correcting!

Thanks for clarifying.

I'm afraid you will have to do it the old way:

1) update ... from src inner join dest

2) insert into .... where not exists....

This query is a real nightmare...

First of all, I would say that this query will never perform well, since you are using several correlated subqueries in the select list.

I...

MERGE is a new feature of SQL Server 2008, there's no such feature in SQL Server 2005.

I don't see any CASE in your query: am I missing something?

INSERT INTO TABLE1 select *, date_deleted

from TABLE2

Where KEY_ID In (Select KEY_ID From table3 Where Invoice_Num in (select Invoice_num from #TempDelete))

I suggest that you replace the * wildcard with...

With SAN, cluster and backups you should be ok.

SAN and cluster for immediate recovery, backup for delayed recovery.

I wouldn't set up a replicated db just to have data immediately...