You haven't said what you want to update and what value, so I have left these for you to complete.

update no

set [field] = [whatever]

from n_order no join n_inv ni on...

Sure - right click on the Transform Data Task, select properties and then click on the Options tab.  You will see Max Error Count about halfway down the dialog box.

Don't be offended if this is blindingly obvious to you, but does the PHCR_Record table have an IDENTITY column defined?

Trial and error, walking around like a blind man in a dark room, is the way I did it.  Not recommended though

select item, max(StatusDate)

from table

Group By Item

These examples do not cope with > 2 transactions, which I believe (from the other thread which you posted) is the requirement?

This cannot be done in a single SQL statement.  If you definitely need it in this format, you'll need a chunk of code (examples of which appear elsewhere on this...

16 duplicates - on insert and on delete?

Is it a coincidence that you are inserting exactly 16 fields?  (I hope so!)

Have you got other triggers that may be causing some...

Are there always two transaction IDs for each StockID, or is the number variable (in which case, you want a variable number of columns)?

I haven't analysed your code, but my suggestion is to that you run Profiler and check out what SQL is being sent from the ASP.NET app. and troubleshoot from there.

Have you tried this?  If you import a text file using DTS there is a field called 'Text Qualifier' - set this to be " (the default) and DTS will...

First of all - if you have a long message, I suggest that you type it in Notepad or Word first, to avoid the time-out that you experienced (we've all...

Getting weirder.  Have you tried backing up the db and restoring it as another db, then running the query on that?  If that fails, try restoring onto a different SQL...

So the sad face wasn't part of the plan then?

When things like this start happening, you start suspecting the integrity and consistency of...

"How would I get the next to last date from the Dates Table? (Would the Top Function work?) "

select max(date) from dates where date < (select max(d1.date) from dates d1)