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)

It will be something to do with the structure of the tables and the way that you have joined them - there will probably be a many-to-many relationship somewhere that...

This grim-looking piece of code should get you heading in the right direction!

select id, col1, col2, col3, rtrim(left(col4, charindex('Departure',Col4)-1))  [Desc]

from table

union

select id, '', '', '', ltrim(right(col4, len(col4) - charindex('Departure',Col4)+2))

from table

order...

I can think of a query that will give you this, but it would depend on the display of the primary key in the table (for sorting - to keep the...