I guess I didn't do a good job of explaining what I found. I rewrite the code some, and it is posted below along with the statistics time and...

Here is the link http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/04/05/dealing-with-difficult-forum-users-the-flip-side.aspx#comments.

In my blog, th flip side, I mention that the post should be concise yet detaled. Sort of an oxymoron, but it works.. The code should be well formatted...

Here is my take. When you look at your post, could someone with no knowledge of the problem domain understand the problem you are presenting. If so, then...

Flo,

If you check my code, I created the temporary table (#TestData) with definition defined as nvarchar(4000) and when loading it, I selected records where the length of definition was <=...

Aaron N. Cutshall (4/13/2009)

---

Charles Kincaid (4/13/2009)

---

110 baud? Yep, that IS high speed. 8-level too. My first word processor was a teletype with a reader and punch. ...

Flo,

I understand needing to work with NVARCHAR(MAX). I was trying to find out why the Tally solution may have been slower, and I think the reason is due to...

I think the reason the Tally version is slower has to do with the blob data type, nvarchar(max).

I posted some information in The Thread.

Jeff Moden (4/13/2009)

---

RBarryYoung (4/13/2009)

---

Jeff Moden (4/13/2009)

---

Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out...

Does this help you get started?

declare @Date1 datetime,

@Date2 datetime;

select

@Date1 = '2009-04-13 10:00:00',

@Date2 = '2009-04-13...

Do you still want the results in HH:MM or HH:MM:SS format if the hours exceeds 24 hours? For example 2009-04-12 10:00:00 to 2009-04-13 10:05:00 would be 24:05.

There is, of course, a way around this problem. Simply build a view that returns the value of the function RAND() and use the view in your UDF.

You can...

Well, as of now (8:26 MDT) the answer hasn't been corrected.

Still says Yes is the correct answer.

Unfortunately, I know i won't make it. Work won't pay for it and I can't afford it on my own.

I'd love to come and meet you all.

I haven't used a GOTO in T-SQL in, I don't know, forever?

Last time I used a...