Or he is just sitting back in his local pub drinking a pint 'o ale, laughing at us as we continue to "rant" against his "rant". He hasn't logged...

jjames (3/16/2009)

---

I have an SSIS plan written to extract data from a source database and input the data into a destination database. The destination table has 1 unique clustered index,...

I just did!

Anyone notice that we have another Saint amoungst us? Hail St Michael of Earl!

From the T-SQL Rant

Gaby Abed (3/16/2009)

---

Bob Hovious (3/16/2009)

---

All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.

Let us make great sacrifice of cursors...

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...