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...

Still not giving enough info. Perhaps reading this will help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

You really have missed part of what I asked for earlier. The definition for your tables, some sample data for the tables, the expected output based on the sample...

And this helps us know what you've done so far how? Please reread my post and Jeff's post. Based on the information you have provided us so far,...

We'd love to help you with your school project, but it would be better if you showed us what you have already done to try and solve the problem and...