Posted by Grey on 01/04/07 13:50

> Assuming no operation will exceed 24 hours it might look something like
> this:
>
> SELECT dateid,
> date as startdate,
> starttime,
> CASE
> WHEN endtime > starttime
> THEN convert(datetime,date)
> ELSE convert(datetime,date)+ 1
> END AS EndDate,
> endtime
> FROM Table1

Thats too easy. Table contains values from serveral hundreds of days. each
day has an id dateid like 458, 459, etc.
I have to go trough all table finding times past midninght for given group
and change the date to correct one.

Grey


>
>
>
>>
>> Any solution?
>> Grey
>>
>>
>
>

[Back to original message]