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

Looking at BULK INSERT in BOL (Books Online, the SQL Server Help System), it appears that to accomplish what you are trying to do you will need to use dynamic...

Agree, I must. Need DDL for the table, sample data, and expected results based on sample data.

Follow the instructions in the article that Bru provided (also happens to be...

rparakalla (11/20/2009)

---

Lynn Pettis (11/20/2009)

---

aaz (11/20/2009)

---

>>Will all these statements (...) return an equivalent date, hour, minute and second <<

Actually it did, if you take into account the time zones, and adjust...

aaz (11/20/2009)

---

>>Will all these statements (...) return an equivalent date, hour, minute and second <<

Question was about "date, hour, minute and second" returned by the statements, not about "moment in...