Here's the basic idea of the select you need :

SELECT dtLastSales.PartNum, dtLastSales.mxShipDate, inv.UnitPrice FROM invcdtl inv INNER JOIN

(Select PartNum, MAX(ShipDate) AS mxShipDate FROM dbo.Invcdtl GROUP BY PartNum) dtLastSales

on inv.PartNum =...

Oops, I meant

1.333 means =

1 hour 20 minutes

Also what do you want us to do?

Straight select?

Insert the data into a new table?

Insert in the main table +...

We still need the required results from that sample data.

>> Does 1.33 mean 1 minutes 33 seconds or 1 min 19.9999 seconds?

Just to confirm what you said :

0.37 should be...

Can you give us a starting point?

Can you show us some sample data and the required results after the insert statement has run?

Glad to hear that.

Ya that makes more sens.  Thanx for the hint .

I strongly suggest you use Sriram's version as it outperforms mine by a mile.  I would also strongly suggest that you change...

What results did those 2 queries sent out?

Not sure.  I'd check the database properties or the books online alter database.  But I don't have any 2005 installed here so I can't check for you.

Check if the server and database collation settings are case sensitive.  If they are you can change them back to case insensitive to completely solve the problem.

You forgot the 6th field in the sample data, but this will give you the right path to go down on :

USE SSC

GO

DECLARE @demo TABLE (id INT, f1 INT,...

Let's just say that this opens up a whole new whelm of possibilities :

SELECT * FROM dbo.SysColumns C1 WHERE Colid IN (SELECT MIN(C2.Colid) FROM dbo.SysColumns C2 where C1.id =...

That's the way correlated subqueries work.  This doesn't fail because this query has to be valid :

Select * from dbo.SysColumns C where exists (SELECT * from dbo.SysObjects O where...

I'm sure it could .

Simple problem Jeff.  Nobody is in your car and no one is using the remote starter so it will remain off untill any of those conditions change