Bruce W Cassidy (4/13/2009)

---

[font="Verdana"]Agreed...

RBarryYoung (4/13/2009)

---

Paul White (4/13/2009)

---

RBarryYoung (4/13/2009)

---

1) For splitting the lines in stored procedure definitions, there is a subtle bug that exists in almost every line-splitting routine, including the ones so far...

Lynn Pettis (4/13/2009)

---

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

Hi again

I just tested with...

Hi Lynn

Thanks for your feedback!...

Hi

I'm not sure if i got you. This?:

ORDER BY sort, Central, Northeast, Middlewest, Northwest, Southeast, Southwest

Greets

Flo

I thought about the CTE while typing the sub-query. I just determined that, in this case, the sub-query is simple enough that it stays readable.

Greets

Flo

RBarryYoung (4/13/2009)

---

And finally, here is the inclusion code to inlcude it with the other tests:

--- ==========================================================

--- -> Tally/fUNCTION solution

PRINT 'Start Tally-function 3 solution (correct line-splitting)'

SELECT @now = GETDATE()

--- Split...

Good morning Paul! (every time I see your first posts I know it's time for bed 🙂 )

Paul White (4/13/2009)

---

I'm still wondering why the CLR TVF is so much slower...

Hi John

The database is relational but not of integrity 😉

2. Is there any performance gain...

Hi foxjazz

A temp table is a valid solution. You can also use a sub-select to avoid the overhead with the temp table.

Try this sample:

DECLARE @t TABLE

(

ProductId INT,

...

sreddy (4/13/2009)

---

sreddy (4/13/2009)

--------------------------------------------------------------------------------

select

user.userid,

user.name,

count(news.userid)

from user

inner join news on user.userid = news.userid

group by user.userid,

user.name

Why count(userid)?

j1a4l0: What do you want returned for a user that has no news items?

--------------------------------------------------------------------------------

Gail Shaw

thats...

Hi

You can use a CTE. Include a UNION ALL for your data and their SUM values. In addition add a sort column to ensure that the Totals are always on...

Hi Bruce

Bruce W Cassidy (4/13/2009)

---

[font="Verdana"]Flo, I'll add my kudos as well: it's good to see some numbers showing how CLR rates in comparison with T-SQL. And I'll look forward...

Jeff Moden (4/13/2009)

---

Florian Reischl (4/13/2009)

---

Don't say that. There might be actually two business...