Thanks for this post - it helped me solve a similar problem.

But, wouldn't it be more clear to use:

update table set price = cast(price as numeric(10,4)) * 1.1

Thank you - all great answers. I really appreciate the time you put into helping me.

My bad. It works right when you run it right:

Print Convert(Varchar(14), Cast(@StudentCount as money), 1)

or

Print Replace(Convert(Varchar(14), Cast(@StudentCount as money), 1), '.00', '')

Actually, the Convert(money, Value, 1) does not insert commas either. I was going by sql 2000 docs.

Thanks Lynn,

That answers the main part of my question nicely.

I'd still like to see an answer to part 2 - a simpler way to format an integer with...

Jeff,

I was reading your article on calculating a number of workdays between dates. Your code was "SELECT @StartDate = DATEADD(dd,DATEDIFF(dd,0,@StartDate),0)".

I've seen plenty of suggestions on how to strip off the...

Try this:

Step 1 - Create a temp table that holds your data fields plus an identity key. Then load the temp table with the records for the time span in question...