Hi,
I have a AMOUNT column which is varchar like 666.89
567.09
890.67
I converted this colum to CONVERT(money,amount) $666.89
$567.09..
Then I grouped by name
which are as CLOSED
OPEn
CONSIDERATION..
When I did the summation of AMOUNT field GROUP BY NAME field
CLOSED ######
OPEN $4578.09
CONSIDERATION $568.97
NEGOTIATION ######
WHY I'm getting ###### as SUM for CLOSED & NEGOTIATIOn
I have a AMOUNT column which is varchar like 666.89
567.09
890.67
I converted this colum to CONVERT(money,amount) $666.89
$567.09..
Then I grouped by name
which are as CLOSED
OPEn
CONSIDERATION..
When I did the summation of AMOUNT field GROUP BY NAME field
CLOSED ######
OPEN $4578.09
CONSIDERATION $568.97
NEGOTIATION ######
WHY I'm getting ###### as SUM for CLOSED & NEGOTIATIOn