Hello,

One of the gurus on this site wrote this function for Delimiting strings. It works on strings up to 8000 chars in length.

IF OBJECT_ID('dbo.DelimitedSplit8K') IS NOT NULL DROP FUNCTION...

Jeff Moden (4/26/2010)

---

chandrashekarthota (4/26/2010)

---

As a site administrator I request you to kindly ignore my Core member comments. I am

closing down my site for few weeks just because of plagiarism and...

Paul - very nice article. Looking forward to the next ones...

Check out sp_AddServer in BOL.

You'll probably need to run it as:

execute sp_AddServer 'MyServerName', 'LOCAL'

There might be a better way of doing this, but this does get you your desired results:

with cteGroupData AS

(

SELECT Row1 = row_number () over (order by diary_id, row_begin_date,diary_status_text desc),

...

Jeff Moden (4/24/2010)

---

Lynn Pettis (4/23/2010)

---

Jeff Moden (4/23/2010)

---

[font="Arial Black"]The Oath and Pledges of the ______________[/font] (insert the correct name of the certification. For example, if the name of the certification...

Adam Machanic (4/23/2010)

---

... and things get even more interesting. I just got an e-mail from a guy at an organization called the "Network Professional Organization". Apparently they caught wind of...

Thomw (4/23/2010)

---

I've modified mister.magoo's code to take into account your test table name, and to restrict prior lookups to starting with 'US'.

Does this do what you want?

select [Datetime] = Manpower_Record_Time,

...

Steve Jones - Editor (4/23/2010)

---

What gets me is would anyone, Indian or not, talk to you at some event like a TechEd or UG meeting and say "Hey, I wrote...

Tough decision....

Thomw (4/23/2010)

---

WayneS

Thank you for the review of you forum's practices. I apologize for not lurking longer before posting. I had gone back and forth on whether to post in...

Adam Machanic (4/23/2010)

---

Yup: I escalated last night with the INETA board of directors, and the e-mail thread eventually wound up in the hands of one of the INETA India people...

Roy, I agree. Nothing to do about you, but I do understand how you...

Looks to me like they've pretty much taken the entire site down!:w00t:

Taking Ken's fine code, changing the source to...