You know you either have or do not have comma's. 

I would suggest you make a table with the text, (i.e., 25 = "Twenty Five", 250 = "Two hundred and fifty", or...

Oh man!  You're #1 on the site now, aren't you?!?!?!?   

Cripes!  I already don't get enough sleep....

You may need to give us more information, but based upon what your post states, this should work...

CREATE TABLE #Parent( IdentityField integer,...

976.23 Knucklehead [ #4 ].  You got some competition now Sushila...   

CREATE TABLE #Test( PrimaryKey integer IDENTITY,

                                   CharacterField varchar(10))

INSERT INTO #Test

SELECT 'First' UNION ALL

SELECT 'Second' UNION ALL

SELECT 'Third'

SELECT * FROM #Test

DROP TABLE #Test

CREATE...

Not sure what is happening with your query, other than the issue that "Time" is a reserved word.  Try this: 

DECLARE @RaceResults TABLE( Sex char(1),

                                           Distance numeric(5,3),

                                           [Time]...

That was my point.  In other words, all the tables contain the same columns, just different names? 

First off, why is this Dynamic SQL?  You seem to know which table you are using as you are specifying each column independently.  I would suggest you alter this to...

Yeah, yeah,... I know.  Do as I say, not as I do...   

Calendar and numbers tables are the best approach!  Do a search on these - RGR'us has a number of postings with those approaches...

Good thinking!  Done that myself during testing.  Forgot to comment out or remove some return code...  

Probably - but I figured a bulldozer approach was just what it needed...  

(It probably could be done with a CASE statement...)

phillcart, your choice of date was perfect!  The last day of that month is Sunday, hence you need a bit of flow control to prevent going back a full week...

Have you recompiled the stored procedure?  It may have become corrupt...

Thanks.  That was the path I was using, but somehow I had it in my head there was simpler way to handle this...

Oil...