I'm not sure if there is much more that could be done to improve your query. As I was trying to reformat it into a more readable form I...

And, if memory serves, this same topic has come up in other threads about "bad questions" and the reply I vaguely remember from Steve Jones was that there used to...

A) The author has admitted the mistake and that option 2 is the only correct option.

B) I think enough people have hammered this point on this thread, and it would...

HyperBac (from HyperBac) is $699 USD per server.

😎

Your solution works, based on what we have from the OP, but why all the extra work setting up and using temporary tables?

😎

bhovious (6/17/2008)

---

You see this a lot when working with data that has been stored as integers in tables. You can use CAST or CONVERT in your...

David Webb (6/17/2008)

---

Can you just use Access to link to the SQL Server tables you need and run the compare in Access? It would probably be a pretty slow...

Just a thought. When I was working with SQL Server 2000 at my last emploer, I had SQL Server 2000 Personal Edition loaded on my desktop system. It...

It could also be parameter sniffing. One thing I have done that seemed to help some of my stored procedures is to declare local variables inside the stored procedure...

Just to expand on Jeff's post a little. Buying the Developers Edition of SQL Server not only gives you access to all the features of the Enterprise Edition, you...

Jeff,

You should not get upset anyway. Just do what you have done, mentor those who come ask for help. You have helped me learn better ways to do...

Jeff Moden (6/16/2008)

---

Triangular joins are still triangular... correlated sub-queries are still hidden RBAR... cursors and While loops are still RBAR... crap code is still crap code even though Cadillac hardware...

Here is another solution:

/*objects and test data*/

create table dbo.table1(name varchar(10), code int, last_code int);

insert into dbo.table1 values ('MC1',100,NULL);

insert into dbo.table1 values ('MC2',200,NULL);

insert into dbo.table1 values ('MC3',250,NULL);

insert into dbo.table1 values ('MC4',300,NULL);

insert...

I am a...

Here's part of the problem with "right". What to me was well written performant code, still could have been written better today because of the things I have learned...