Well, doing it on a table (5 columns) and around 100000 rows is next to instant.

CP

I would imagine Select SUM(Col1 + Col2 + etc) will be the fastest.

Much less work than nested loops.

You can normally do away with cursors with temp tables. Populate a temp table (Either variable or normal) and loop through it. I have used this many times with large...

This might help...

http://www.sqlservercentral.com/scripts/contributions/711.asp

Cheers,

Crispin

ERROR AT KEYBOARD, I like that.

In all honesty, I do belive that it's a user error. PEBCAK (Problem exists Between Chair And Keyboard) error.

The problem is they want to know...

The easiest and fastest I would think (not knowing if the tables are related) is to have an IF statement around the two selects.

If @CurrentID > -1 OR IS NOT...

Is there any relation between the to tables?

Greetings,

There should be 3 msxml dll's in your sys32 dir. If you have msxml3.dll, you have version 3. Last SP I downloaded from MS (About 2/3 months ago) set the...

ya, this all makes sense now. This is why people say that UDFs are slow. I am sure in their tests, they use it as part of a select.

In all...

Well0549,

If you call a function as part of a select, does the function not get called once for each record? ie: You called the function 20000 times?

This would...

ahhhhhh, Found the Problem. (This only affected the last post!)

The UDF had an unfare advantage. The proc was doing a between in the last query where the UDF was doing...

O well, there's that theroy down the drain.....

Still faster. Not as fast as a simple query though but still twice as fast.

All the tables are large(ish)

When running the proc and...

I was having a look at another thread Use of functions Do or Don't http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=9683.

Well0549, you said there that you found UDFs slow. Antares, you I thing, also added some...

Sorry, to answer your second question, No, I have not tried views yet. Will get to that later on today.

Crispin

hmmm, I see what you mean. Yes, that could be a problem.

But, I think I could life with it considering the increase (Apparent) that I am getting.

What I am busy...