Thanks for letting us know what the problem was, Jim... I think you're on the right track.

... and, here's a bit of simple code to play with...

If you cannot create a Tally table, please post back... we have other ways to skin the same cat. 🙂

MichaelC (7/7/2008)

---

the simple function that I was working on would simply parse a comma delimited string and return the requested section. For instance, I would pass a string, the...

Thanks for the feedback...

I avoid the use of cursors even in Oracle. Setbased methods work better there, too. 🙂

It would probably be better if you started a new thread... when you do, you might want to explain what kind of alteration you want to make to each stored...

vipul.ymca (7/7/2008)

---

I see 2 possible options but not sure if they are implementable at your end.

1. insert a temp identity column and then you can issue a delete statement. (let...

Yep... I agree with that... I still avoid them on some processes in 2k5 simply by using concatenation to build "monster" commands and execute those instead of a cursor. ...

I'm sorry to be asking so many questions... I'm just looking for clarification because I believe I have a nasty fast method to do what you want...

Will you ever end up with totals in excess of 24 hours?

emamet (7/7/2008)

---

Yes, the initial data comes as a file and is manipulated by a C# program. It was my idea to do the first bit in one SQL chunk because

-...

rbarryyoung (7/7/2008)

---

Yeah, I was wondering about that, but he also said "sent as one Varchar(max) parameter...", so it's a little contradictory. Anyway, I'm pretty sure that I'm going to...

Here's the thing, though.... Eric said...

emamet (7/4/2008)

---

Dear all,

I am trying to write a stored procedure that splits a [font="Arial Black"]file content [/font](sent as one VARCHAR(MAX) parameter) into as many rows...

GilaMonster (7/7/2008)

---

I don't...

Sorry... I misinterpreted what you said... I thought you said there weren't that many changes. My mistake.

That's what I was afraid of... the Recursive CTE is a quick way out for you. Sure, it works fine, but there has to be something better than constantly...