Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcb267
Constraint Violating Yak Guru
291 Posts |
 Posted - 2010-11-05 : 08:38:32
|
| Hi - I want to set the format of T_Rev to currency, I can't figure out how to do it though.sum ( ((HVMASubscribersINDV + NonHVMASubscribersINDV) * INDV_RATE)+ ((HVMASubscribersINDV_SPOUSE + NonHVMASubscribersINDV_SPOUSE) * INDV_SPOUSE_RATE) + ((HVMASubscribersINDV_1 + NonHVMASubscribersINDV_1) * INDV_1_RATE) + ((HVMASubscribersINDV_CHILDREN + NonHVMASubscribersINDV_CHILDREN) * INDV_CHILDREN_RATE) + ((HVMASubscribersINDV_FAMILY + NonHVMASubscribersINDV_FAMILY) * INDV_FAMILY_RATE) ) as T_RevCan you please help me?Thank you. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Query Variable Format