Heh, agreed. It's a shame, too. I would have liked to take a...

Dang... I gotta learn to read all the new posts before I reply...

Richard Fryar's fine solution is a dynamic solution that will work fine in SQL Server 2005.

Heh... if you...

jon.malenfant (10/14/2008)

---

Taking this to the next level, let's look at textual data instead of numeric. Consider two tables with a one to many relationship. We can even remove...

But, "practically" and "is" are two different things... 😉

peter (9/30/2008)

---

As I should, I will do some thorough testing with a recognizable real world problem. It will take me a few days before I can do so and am...

GF (10/14/2008)

---

Jeff, this is a great article.

I do have a question as I am trying to apply your solution to my needs.

I have hundreds of addresses in a single address...

Still, the code is doomed to be comparatively slow because of the loops. If we knew the actual problem this was supposed to solve, perhaps we could find a...

rgillings,

Thanks for the feedback, I appreciate it. If you really want to get a handle on that particular logic, take a gander at the article in the link I...

amit (10/14/2008)

---

There is no transaction logs backup running. Is there any script to complete the same? Because i had scheduled this index defrag. I can complete the transaction log back...

Heh... this has been a lot of fun, but the funny thing about this whole thing is that people keep talking about everything except the original post.

Yes, I agree that...

You need to include the intial value of @j-2 in the @I loop or it just counts down in one iteration of @I and stays there.

You should tell us why you'll need nested While loops... typically, that's a recipe for a huge RBAR performance problem and it can usually be avoided. 😉

:hehe:

You should continue the question because you're still using a loop and a function to do...

You're trying to reinvent the wheel. 🙂 Use BCP or Bulk Insert, instead.