Steve,

I was being sarcastic with the person who made the suggestion of a copy editor... that's why I quoted "obvious"... You did great, as usual...  in the spirit of this...

I'll add to Serqiy's suggestion... there's a group of views called "INFORMATION_SCHEMA" that you might want to lookup in "Books OnLINE" (BOL).  They don't always contain all the info you...

p.s.  Just in case anyone asks...

A function, like this one, should never be used to populate a permanent table because of Normalization Rules.  It can, however be used to populate a...

Like this... (self supporting test includes function creation, test data creation, and demo of how to use the function).

--=========================================================

--      Create the function to do the concatenization

--=========================================================

--===== If the...

Actually, this is the 4th identical post  If you're not happy with an answer, please say so within the same thread instead of posting...

Please, please, please buy a book if you want good copy.  Poor grammar and typos missed by the spellchecker have nothing to do with reducing the utility of useful articles. ...

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