It tough to exactly give you the right code, but you could do something like this:

Code to view the results in question:

SELECT MyColumn = REPLACE(MyColumn,',','')

FROM MyTable

WHERE CHARINDEX(',',MyColumn) > 0

The code...

Sometimes you have a case where 90% of the logic is the same, however, you have to do one thing different if it is an INSERT vs UPDATE, etc. ...

You can also use the left function.

Master_Address =

RTRIM(LEFT(Master_Address, Len(Master_Address)-2)

Yep, that works too.

You need to use a case statement in you where clause. This queries assumes that you want the number of days to be the same. You can incorporate...

Then use the code I posted earlier.

CASE

WHEN SUM(v.PurchaseAmount) /15000 <=0 THEN 0

WHEN SUM(v.PurchaseAmount) /15000 > 0 AND SUM(v.PurchaseAmount) /15000 < 1 THEN 0

ELSE SUM(v.PurchaseAmount)/15000

END as 'TotalPersonalSalesCalculatedPoints'

Well I take it as between 0 and 1. Is that what you meant?

Is this not a requirement anymore? 0.0243 would fall into this category.

Exactly. If the Purchase amount is less than a whole number then I want to see a 0....

How about:

CASE

WHEN SUM(v.PurchaseAmount) /15000 <=0 THEN 0

WHEN SUM(v.PurchaseAmount) /15000 > 0 AND SUM(v.PurchaseAmount) /15000 < 1 THEN 0

ELSE SUM(v.PurchaseAmount)/15000

END as 'TotalPersonalSalesCalculatedPoints'

I don't mean to sound condescending but...

Based on your sample data, 0.02343 , that values is NOT less than zero. Values such as -1, -3.1415 are less than zero....

What is suppose to happen is that if the PurchaseAMount is < the 0 then I just want to display a 0 in the column but it keeps giving me...

I am glad everything worked out. As a piece of advice, before doing anything to the master database, back it up. The instance cannot run without this database.

If you're not on the latest service pack then the reports are viewable from the summary tab in ssms. Select the summary tab, select a database and then the...

I am confused by this part

Set @TodayDate = DateName(dw,@EndTime)

Wouldn't you want @TodayDate to equal the day of the week for today's...

SSMS is SQL Server Management Studio

What service pack is your instance on? I think you need to be on service pack 2.