Luke L (2/17/2009)

---

I'll toss another on the pile recommending a set based solution. This seems like a perfect teaching/mentoring moment. At the very least she should be commended...

Matt Miller (2/17/2009)

---

I would just turn around and ask her to tell you why it HAS to be one row at a time. If it seems to come across...

Yeah... I went through such hell with a 3rd party POS myself. In my case, it had no archiving and, worse, it used a Sequence Table instead of IDENTITY...

Nothing free... just beginner stuff.

If you really want to "take it to the next level", I know a pretty good forum that you could start answering questions for. ;)...

Bruce W Cassidy (2/17/2009)

---

Jeff Moden (2/17/2009)

---

I agree... especially when the someone who writes the document is really a frustrated novelist and includes no code samples. Or worse... incorrect code...

Bob Hovious (2/17/2009)

---

P.S.

I send IMs to the guys in the next cube all the time... you can cut and paste code, or whatever, and not bother all the other folks...

Bob Hovious (2/17/2009)

---

Correlated sub-query?

CorrELATed sub-query?

No wonder I haven't been able to find anything !!!!!

I've been trying to search for CORRUGATED subqueries !!!! :w00t:

---------------------------------------------------------------------------------------------

Seriously, even reading...

Lynn Pettis (2/17/2009)

---

Back to the topic at hand (at least for the moment). Both products have their place or else they both would not exist. Where I may...

Mohit (11/12/2008)

---

Toni Thank-you for the suggestion :).

I started working on the part-2 of this article, I will talk about all the suggestions in that article. If there are any...

Oh, my bad and...

Jeff Moden (2/13/2009)

---

DURGESH (2/13/2009)

---

hi all,

i have a string as 'a;b;cde;f;ghi;d' or 'a;b;cde;f;ghi;defg'

now i want to split the given string as 'a;b;cde;f;ghi;' or 'a;b;cde;f;ghi;'

i tried using substring,left,charindex functions but i...

Gopi Nath Muluka (2/17/2009)

---

Another version, assumes that data should be removed after last delimiter

CREATE TABLE TTT

(

ID INT IDENTITY (1,1) NOT NULL,

...

AFCC Inc. Com (2/17/2009)

---

What I am doing is creating a table that has one row, and this row contains the WidthTo columns

Then I create a HeightTable and this table contains...

GilaMonster (2/17/2009)

---

MSDB can be repaired, I believe (haven't tried it). Master I would...

Bruce W Cassidy (2/17/2009)

---

[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there are...