Sure. Just know that this will cause more transactions in the log file, and since you were concerned about the size of that...

Since you're continually updating the tables until they...

I don't see anything wrong with it.

Another way would be:

declare @rowcount int

set @rowcount = 1

while (@rowcount > 0) begin

begin transaction

update top (10000) ...

set @rowcount...

In this case, all you need to do is reindex the clustered index - this will force the nonclustered indexes to be reindexed, since they depend on that.

Just remember that using a function on a field in the left-hand side of an expression will mean that you can't utilize an index to do a seek....

ColdCoffee (8/3/2010)

---

Ah no Wayne, pls dont be sorry.. u are one of my heros in SQL.. i would consider any interactions with you as a real treat for myself. Thanks...

ColdCoffee (8/3/2010)

---

WayneS (8/3/2010)

---

ColdCoffee (8/2/2010)

---

Wayne, awesome job in that explanation , mate! Thanks.. Hope the OP now and the other poster got what the code exactly does.

Also i remember a thread...

Matthew,

Realize that a function like this is going to be called for every record in the result set. It would probably be better to add a column to the output...

Do the multiple updates without the cursor.

I think you're close. You might want to consider this...

Create a small table of the month # and starting/ending dates:

IF OBJECT_ID('tempdb..#TestTable') IS NOT NULL DROP TABLE #TestTable;

CREATE TABLE #TestTable (MonthNbr...

bt, this looks promising. I don't really care about the speed - it's a one-off thing.

I just need to identify all the code with dynamic sql.

I'll try it out tomorrow,...

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid point? Are the people screaming about it...

Grant Fritchey (8/3/2010)

---

Ditto. We'll be out at a Scout...

Stefan Krzywicki (8/3/2010)

---

WayneS (8/3/2010)

---

There's a quote in this article that sums up my feelings:

"On the one hand, stopping...

There's a quote in this article that sums up my feelings:

"On the one hand, stopping a mosque from...

It's could be data loaded in from an excel spreadsheet. Tabs in excel need to be referenced with a trailing $.