Must have gone out of range of the datetime datatype... or a date setting has changed (but I'd go with the datetime limit).

And just to make sure we are on...

I don't think so.  I recently noticed that top 100 percent is automatically added to the view definition when using the order by, but it is not automatically removed when...

@@dbts is not a datetime.  It is only a unique number generated by sql server.

Check out GetDate() for the current_timestamp

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