Hmmm, remember I think some pondered about the Son of the Thread...

Just curious if you took a close look at the code I provided. It would actually allow you to emilinate the dynamic sql you are using in your stored...

Sure is.

Try the following and see if that works for you:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[DelimitedSplit] (

@pString varchar(max),

@pDelimiter char(1)

)

returns table

as

return

with

a1 as (select...

GSquared (3/16/2009)

---

Jeff Moden (3/14/2009)

---

RBarryYoung (3/14/2009)

---

OK, foxjazz, now I have a question for you:

foxjazz (3/14/2009)

---

Ok, yes I did it that way before. Except you have to do it in 4 distinct...

george sibbald (3/15/2009)

---

Go ahead, put up some more of your cursor-based code, we'll keep doing it and then you can brag to your boss how you improved the performace of...

:blush::blush::blush::blush::blush::blush::blush::blush::blush::blush:

Do they give out MVP for Jack of all Trades, Master of None?

:blush::blush::blush::blush::blush::blush::blush::blush::blush::blush:

Finally got to it by cutting and pasting the url while writing the above post.

Could your chill come from the mention of our favorite interloper??

I'd read it but I can't seem to get to...

foxjazz (3/14/2009)

---

I guess I just don't get why everyone here is so walled up and can't think outside the box.

Stored procedures in sql result only in one language type, not...

foxjazz (3/14/2009)

---

Lynn Pettis (3/14/2009)

---

You know foxjazz, I find the following comment of yours insulting and ignorant on your part:

You all that use t-sql and don't code probably never know any...

You know foxjazz, I find the following comment of yours insulting and ignorant on your part:

You are basically...

Okay, foxjazz, you can rant incoherently that is obvious. How good are you at following directions? As Jeff requested, read THIS[/url]. Follow the steps in that article...

GilaMonster (3/14/2009)

---

Sorry, no. I've 'engaged' that one before and the threads never end without insults getting thrown around. He takes criticism and...

Troll he may be from the dark side he is. Plotting his next move maybe, devising a trap perhaps? Looking for something SQL can not do?

After his last...