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

steve dassin (4/10/2009)

---

Jeff Moden (4/10/2009)

---

Yep......

steve dassin (4/10/2009)

---

Lynn Pettis (4/10/2009)

---

Steve,

You just don't get it, do you? You really need to drop the cutesy talk and try being more professional in your communications. I...

Steve,

You just don't get it, do you? You really need to drop the cutesy talk and try being more professional in your communications. I really enjoy "playing" with...

steve dassin (4/10/2009)

---

Lynn Pettis (4/10/2009)

---

steve dassin (4/10/2009)

---

Jeff Moden (4/10/2009)

---

steve dassin (4/10/2009)

---

Just a note to say I'll be addressing some interesting responses from the discontinued thread:

T-Sql rant

http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx

Some of the responses were...

Jeff Moden (4/10/2009)

---

Lynn Pettis (4/9/2009)

---

Any help on that thread would be welcome. Based on further information from the OP, I'm thinking something written using SMO may be a better...