It seems you can : End Function

However you need to speel it right 100% of the thyme .

Thanks for sharing the solution.

Is it possible that a restore appended the data to the original database (asking anyone alive for this one)?

Ran any big index maintenance lately?

Changed a clustered index or PK on a big table?

, you never know when this will help someone else .

Shouldn't be missing.  There should be one row per block of 4000 characters.

No workaround to suggest except a select + concatenate (or print).

Not really.  I don't have any teeth left .

Check out mrpolecat's version.  It will do what you want,  Now you see why the required output is necessary to better answer...

I see the confusion.  That is also why I usually don't answer without having the required results first .

Thanks again for helping in the...

For security all drop tables commands have been commented.  Use at your own risk :

USE SSC

GO

--Numbers table script

IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType...

You still didn't answer my question.  What happens if you have more than 0.6?

From the sample data using your query :

2007-03-13 09:03:55.000 2007-03-13 09:03:55.000 MACHINE1 DOWNTIME 0.30

2007-03-13 09:03:55.000 2007-03-13 09:03:55.000 MACHINE1 DOWNTIME 1.03

Instead of 0.30, 0.30, 0.30,...

What if the duration is longer than 1 hour?

I forgot one step.  You need to select from parts left join that query and use isnull(currentprice, 0) so that all products have a price.  Post back if you need...

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...