Thank you Lowell for the sample data.

I'm constantly requesting the OP to provide the data to verify that

a) the OP is willing to be actively involved in the solution finding...

Lynn Pettis (12/15/2010)

---

I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

Now I may be wrong, but...

What is the primary key of that table?

Why do you have a SUM column in there when the values is supected to change based on user input?

Also, it seems like...

select REPLACE(phone,'-','') as phone_formatted

from affiliate

Regarding the money data type:

Here's an interesting example I just found here

-- code removed (too much technical stuff in THE THREAD)

Another interesting article can be found here at SSC

I think you can use UNPIVOT to get your table in a normalized form (using integer values for the former column names). Based on that you'd simply use a SUM()...

Did you alter the nonclustered index like I recommended earlier?

bkuhnke (12/15/2010)

---

Wow, thanks for your efforts in helping me out with this. Greatly appreciated!

Was there a huge time difference in fetching the rows either with the local static or...

So you have a database in full recovery mode but no backups?

What is the backup strategy you use? If you never performed any backup (including transaction log) you must have...

I just tested two versions on my SQL2008R2 EXPRESS version:

DECLARE @CustNum AS INT

DECLARE myCrsr CURSOR LOCAL STATIC

FOR

SELECT number

FROM master..spt_values

WHERE TYPE='P' AND number <20

OPEN myCrsr

FETCH NEXT FROM myCrsr INTO @CustNum

WHILE...

billj-705548 (12/15/2010)

---

Thank you for that method as well Mark. If I'm understanding correctly, this method counts the number of ordinals before the current one -- though I've got to...

So I'll stop asking to replace the RBAR then 😉

Did you try to declare the cursors as STATIC or FAST_FORWARD like I mentionend earlier?

Paul White NZ (12/15/2010)

---

The last thing Craig needs right...

Here's a "slightly" different approach:

Instead of Openxml I use XQuery together with CROSS APPLY for referencing outer node attributes.

To catch the ID values from the insert statements I make use...

What would it...