SQL - How to add Thousands Separator on numbers within SQL

select replace(convert(varchar,convert(Money, @MyValue),1),'.00','')


original post here
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/49e7d563-5056-478a-921d-ec56ae3162c8