Here's a slightly different take...

Anything that has a StartTime with no matching StopTime is not reported.

Anything that is still stopped, has a stopped duration up to the current time.

It's about...

Gabor,

I know you only have read access but can you convince the DBA to install a function for you because that's the best way to lick this problem...

Cimbom,

The other posters and you are correct... pure crap on the part of the designers of the system.    Unfortunately, you sometimes have to...

Wasn't an attack on your post Julian (I shouldn't have made things so bold, "sounds" like I'm yelling ).  Nope... I was just...

Dinakar,

Kenneth's suggestion is an excellent one but, if the Comments column is VARCHAR or NVARCHAR, you don't need to create the UDF... just create the view with a small modification.... should...

No need to enter the dark and slow realm of coversions to characters...

DECLARE @vChar VARCHAR(20)

    SET @vChar = '1458.00'

 SELECT CAST(CAST(@vChar AS MONEY) AS INT)

Yep... but won't work here... the original poster said the date formats where in a mmddyy format... here's what BOL says about the "Unseparated String Format".... I've highlighted the important...

Tammy, 

Peter's solution, as usual, is spot on. His ingenious crosstabs return the sequence of numbers of 0 through 15 in less than a heartbeat and then he applies 0-11...

I just can't bring myself to use a correlated subquery...

No need for a function if you want to permanently correct the data...

 UPDATE yourtable

    SET phonenumbercol = REPLACE(

                         REPLACE(

                         REPLACE(

                         REPLACE(

                         REPLACE(

                         phonenumbercol

                         ,',','')

                         ,'-','')

                         ,'.','')

                         ,'(','')

                         ,')','')

Are you suggesting that RAC is better than Reporting Services (which is free, by the way)?

Don't ya just love Microsoft?  Fixes for their fixes!!  Thanks for the tip, Daniel and welcome to SQLServerCentral.com.

My DBA is the one who set it up so I'm not sure... but I'll find out...

Yep... you can do that... like you said though, the automagic century-cutoff should do the trick but even that can be wrong if these dates are DOB's.

The slashes were an...

Oh yeah... almost forgot... if you want to see the code the script above generates, just change the "EXEC" to a "PRINT".