You should know that wether you are using cursors or a while loop it is still RBAR (a Modenism for Row By Agonizing Row) processing. In almost all cases, converting...

You should know that wether you are using cursors or a while loop it is still RBAR (a Modenism for Row By Agonizing Row) processing. In almost all cases,...

rons-605185 (11/20/2009)

---

Per your post below, what is the advantage doing the inner joins versus the code I wrote? I have been only doing T-SQL for a short time and appreciate...

Alvin, I think it is time to go home, If not for you, it is for me! Have a good weekend! 😉

Not having any test data or the table structure either, here is a possible set-based solution to your cursor-based solution you are currently using.

DECLARE @tempnotes TABLE (

entrydate datetime

, notetype nvarchar(30)

,...

Irish Flyer (11/20/2009)

---

You want to explain why there are no roles in Windows and there is roles in SQL Server from the time I have been using it which is...

I can see why SQL Server itself will always require Windows Authentication. Whay I think people are actually looking for is SQL Server only authentication from the client to...

Timothy J Hartford (11/20/2009)

---

I would recommend that you create both versions, and do a side by side to see.

I personal do not like to use views unless for very...

GSquared (11/20/2009)

---

Alvin Ramard (11/20/2009)

---

GSquared (11/20/2009)

---

Alvin Ramard (11/20/2009)

---

We're getting off topic again.

We need a good pork chop recipe to...

And Steak Talk takes us to 9400 posts on The Thread!

I just like my steak cooked, pink on...

halford13 (11/20/2009)

---

Hi,

You're right, using the Tally table is faster:

using this parameter:

So I got next execution times (running the same script several times):

- my function: 120 ~...

phegel (11/20/2009)

---

This is the function that I am currently using, is it more efficient than the CTE ?

create FUNCTION [dbo].[func_CreateClientTableOrdered]

(

@item_list as varchar(4000)

)

RETURNS @Items Table(OrderNo int, Item varchar(60))

AS

BEGIN

...

Gianluca Sartori (11/20/2009)

---

Thanks Gus, I would never have thought of milk! I'll try and let you know the results.

My steak recipe is the shortest ever:

* volcano hot grill

* raw...

GSquared (11/20/2009)

---

Gianluca Sartori (11/20/2009)

---

GSquared (11/20/2009)

---

In exchange, I taught him a few tricks with steak that he'd never heard of. (There are reasons that I'm 30 pounds overweight, none of...