John Peter Fernandes (5/3/2010)

---

Sergiy.. thanks for this, this returns the value of the new TagId if inserted and the TagId of the already existing Tag.

however if it exists i get...

INSERT INTO mt_tags(tag,type)

SELECT @tag, @type

WHERE NOT EXISTS (SELECT ID FROM mt_tags WHERE tag=@tag)

SELECT @TagID = ID

FROM mt_tags

WHERE tag=@tag

@TagID will contain correct ID regardless if it's new or...

1. Make sure you have clustered indexes on column so_timestamp and other columns used in range selection.

2. Don't shrink databases. It's a quite useless exersise.

Unless you want to upgrade disks...

SET ROWCOUNT 1

{Do your update as it is}

SET ROWCOUNT 0

Make business_day_dt (or whatever the names are in background tables) a 1st column of clustered index on every table.

Warning about missing statistics usualy means that your WHERE clause uses non-indexed columns.

Please read the post from Ronald San Juan above and answer the questions in there.

You welcome.

And thank you for providing perfect coding and data samples.

It made it really easy to help you.

🙂

I guess you update the whole remote table, not only records you want to update.

Try this:

UPDATE dst

...

You need to make sure number of columns in the table matches number of columns in the file.

This works perfectly with the file you provided:

if exists (select * from dbo.sysobjects...

It's a bug in SQL Server.

Instead of applying ORDER BY condition to the outcome of OUTER join (as it should be according to ANSI)...

Conversions varchar to datetime and back are the worst cpoosible conversions from performance point of view.

They may be very comfortable for a human eye, so keep them where they belong...

No, you cannot.

It's SQL 7,2000 - TSQL forum, and ROW_NUMBER() OVER was introduced in SQL...

What if name variations

Chris Smith

C. Smith

Smith, Chris

belong actually to Christine Smith, not to Christopher Smith?

I don't think any universal thing will work here.

Pagination normally goes together with line sorting.

And to define which column to use in ORDER BY you need to change the procedure.

So,...

I suppose you have some auto-generator for unique 16-char codes.

Let's say it's encapsulated in function dbo.GenerateUnique16key.

Then you should have something like this:

Create TABLE dbo.AccountIdentifiers (

TwentyTwo...