Use single quotes around literals in SQL Server. To debug, try running your statement in Query Analyser and see what happens.

By the way, this looks like a horrendously complex routine for...

Stored procedures should perform better, in general. Network traffic is optimised and SQL Server should be able to reuse execution plans when running SPs multiple times.

When the system finds a 'duplicate', what logic should be used to determine which of them to delete?

Are you using Access to delete the data?

If you are using linked tables within Access, you must ensure that Access knows the primary key of the table when you link...

OK - this is turning into a weird one. If you take the

and PickupDate > '3/2/2006' --*****

line out of the query, what is the latest entry displayed?

You could also...

What is the datatype of the PickupDate field - is it datetime or varchar()?

Expanding on PW's post, I suggest you use this format:

'YYYY-MM-DD HH:MM:SS.mmm'

So your query becomes:

...

and PickupDate > '2006-02-03 00:00:00.000'

order by PickupDate

(if you're using English date format.)

A strange request!

update table set age = 32 where id = [PK for row containing John's data]

update table set age = 26 where id = [PK for row...

Please do not cross post. Follow this thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=268690

Are you exporting the field as text?

So what's wrong with my solution?

Your solution, I'm afraid, is logically flawed. Eg if this is sample data

T1 (CustNo, OrderNo)

1,1

1,2

2,1

T2 (CustNo, OrderNo)

1,1

Your query...

So are you thinking of adding a new column to the 'old' table corresponding with 'software_no' in the new table?

Once you have the 'next' identity number, what are you going to do with it?

Maybe @@IDENTITY, or Scope_Identity() (check BOL for details) will give you what you need?

Your idea is probably the way I would do it.

The tricky bit is the creation of the mapping table. Perhaps you can partially automate this, by matching on 'test description'...

select t1.*

from t1 left join t2 on t1.Custno = t2.CustNo and t1.OrderNo = t2.OrderNo

where t2.CustNo is null and t2.OrderNo is null