Richard

You're right - TOP 1.  And, on seeing it again, I don't think you need the parentheses round TOP 1 ... cTime.

I don't understand what you mean about the top...

Then how about this?

declare @trackingCode char(4)

select @trackingcode = (top1 trackingCode

            FROM  tblSerial ( READPAST, ROWLOCK) ORDER BY cTime)

This won't work for system databases or if your database is published for replication.

For replicated databases the easiest workaround is to back it up and restore to the new location...

Debbie

I'm assuming that the combination of UPN, FROM_DATE and TO_DATE is unique.. if not then you'll have to add extra logic.

This is untested, since you didn't provide any DDL or...

Graham

Glad it worked.  I'm sure you have thought about what happens if a pair of siblings don't share the same surname, or live at different addresses, or live at the...

Jay

From preliminary inspection, it seems to be failing because you've commented out the INNER JOIN clauses but not the predicates (the ON parts).

You should alias your tables - this would...

Ankit

No need to post the same question more than once, please.  Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=340005

John

Graham

My first advice to you would be to alias your tables and get rid of those unnecessary parentheses.  That will make your queries much easier to read.

Now, will this work?

John

I didn't get this one right, but it made me laugh!

John

John

Best just to insert the new records.  Is your data date-stamped?  If so, you can write your insert query based on the date.  If not, you will indeed need some...

You should have an icon in Control Panel called SQL Server 2000 Licensing Setup.

John

John

Set up your AS/400 server as a linked server and then create a job to copy data to your table weekly.  Or create a DTS package to do the same...

USE master

GO

SELECT DB_ID(MyDB)

John

Your queries don't make sense.  They don't specify what update to perform.  For example, the second query should read something like this:

update T set myCol = 40

where id = 32...

You will have to mess with dynamic SQL and fiddly datepart functions.  It can be done, but if you want to keep it simple, probably best to use a database...