I must have been focusing on these two statements:

Ideally, I wanted to find a way to have the caller that needed to run the dynamic SQL be able to catch...

Thanks, folks. I'll try to get it done and in the queue by tonight. I'll be sure to post a link to it from here then.

Experience: I have programmed in C# as long as it has existed (about 8 years,...

Hmmm, ... for some reason I'm not scanning it. But I'll take your...

Yeah, I knew that, but I wanted @Days because it makes...

I'll need some convincing on that one....

Prolly not...

Jeff Moden (6/29/2008)

---

Nicely done, Barry... but I get numbers just a bit...

One of the easier ways that you can do this is to write your own "wrapper" Proc for EXEC(string) (or for sp_ExecuteSQL), and then always have your Dynamic SQL call...

Kimberly.Hahn (6/29/2008)

---

I have read that. It is a bit different then what I am after. My focus is on being able to query to retrieve the text of...

On 2005, it's always been 11,000+ wherever I've looked.

Ack! Yeah, that does make sense...

OK, then this one runs in under a second:

Create table Dates(D datetime primary key clustered)

GO

Declare @FirstDate datetime

Declare @LastDate datetime

Declare @Days int

Set @FirstDate = Cast('1970-01-01'...

Hey, did you get a chance to look at that draft yet?

Any of this cow left for me? 🙂

Here is my entry (really just a tweak of Jeff's):

PRINT REPLICATE('=',100) ---------------------------------------------------------

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

declare @root int

select @root = sqrt(@testsize)+1

PRINT '===== RBarryYoung''s Method'

SET...

I just registered! I will definitely be there...