Heh... thanks Lowell... but I...

Yeah, huh? Using loops comes highly unnatural to me. 😀 Goes against my data-troll grain.

The other place I saw it was with a splitter function that used a...

Bill,

I guess I don't understand why you are calling these procs as passthrough queries from Access... can't you schedule this as a job or run it through OSQL? That...

Heh... and folks think Serqiy is a smartass??? :laugh:

Anyway, point well taken and I guess I have to eat a little crow on...

No... not true...

1. Editing a post still triple spaces the entire post.

2. Trying to post with [Code] still results in a triple spaced mess that doesn't obey leading...

Perfect... Nice "kick in" Peter... I'm gonna go back to sucking my thumb now... 😛

Heh... I'm old... I've got no "recall" left until I've had about 20 coffees (if I recall correctly) 😀

Tomm Carr (10/2/2007)

---

I answered that already. I defined my test table with a nullable datetime field. However, the OP seemed to be using a integer with zero meaning null so...

I missed what you're talking about... which movie, Remi?

Bingo, Scott... took the words right out of my mouth... don't need the EXE to gen decent XML... it can all be done in T-SQL...

Ummm... what undocumented behaviour?

Bob Fazio (10/2/2007)

---

I was able to update 11M+ rows 3x and Update every 20th row (months) 1x

in 210 seconds. I am going to see if I can get this...

Thank you much!

p.s. If you think a Group By would be better, all I can say is "try it"... I think you'll be surprised at how bad it is...

. How many internal rows will be generated by the following query (assuming the original 830 rows provided by Microsoft)? (Easy to do... run it with Execution Plan turned on...