sushila
SSC-Dedicated
Points: 35293
More actions
July 29, 2005 at 9:08 am
#578211
You can do this:
select cast(c.Payrate * 100000 as int)
select cast(SUM(s.Hrs * c.Payrate) as money)
**ASCII stupid question, get a stupid ANSI !!!**
Michael Graves
Old Hand
Points: 305
July 29, 2005 at 9:12 am
#578212
Thanks, that works fine, Still learning SQL
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply