jmcnemar (1/11/2010)

---

Thank you so much for the quick and plentiful responses. Chris, I tried your suggested code and it works pretty good except that I also need to exclude from...

Lynn Pettis (1/10/2010)

---

Do you think you could edit your post and put the [ url ] [ /url ] (no spaces inside the brackets) around the url's? This would...

See also http://www.sqlservercentral.com/Forums/FindPost844653.aspx

See also http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/50ebe46e-2ef5-41d9-b915-b4405ed4a15f

See also http://forums.asp.net/t/1447537.aspx :w00t:

See also http://sjc.ironspeed.com/post?id=3575239&goto=nextnewest

The earliest of these posts is six months ago.

Surely it's worth spending fifteen minutes setting up a little...

hansontd (1/10/2010)

---

I had tried utilzing REVERSE() with stuff but for whatever reason I guess I wasn't utilizing it correctly as I never got teh results I was after...but thank for...

bitbucket-25253 (1/9/2010)

---

Take a look at this one

http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx

It is one of the worst I have seen on SSC in a long long time.

Lynn - I must compliment you on your restraint...

SQL Learner-684602 (1/9/2010)

---

[font="Comic Sans MS"]Hi all.

I have question in a query that is returning me a set of data....with following columns:

account_no / emply_no / dept_no / address / Balance /...

Sheesh...check this one out.

Ten foot pole hey? A newspaper contributor recently described Roman Polanski as "The five foot Pole you wouldn't want to touch with a ten foot pole" 😀

When...

How about some sample data, Ifila? You've visited here 399 times, you must know the drill by now 😛

hansontd (1/9/2010)

---

I've used the STUFF function numerous times in the past but just couldn't wrap my mind around how to work it in this case....I've always dealth with strings and...

is250sp (1/8/2010)

---

I have a script that finds the 2nd period and returns the first and second nodes in a string. It works fine as long as there is a...

Hi Mitch

Looks like your problem could be solved by using a recursive CTE.

If you set up sample table scripts and data insertion scripts as Gail suggests, you will have...

Robert Lassiter (1/8/2010)

---

I have created tables named for each month. January, February etc. Once per month I will delete all records in the current months table because...

LOL! Happy New Year Jeff!

Luke L (12/31/2009)

---

Bru Medishetty (12/31/2009)

---

Wishing you all a Very Happy, Prosperous and Safe New Year 2010.

I had few horrific moments :w00t: today morning driving to work. So all those...

lmu92 (12/31/2009)

---

Yep, I live in Germany. Right now...