Thanks Paul. I really do have to get on the CLR train, don't I? I will get to it right after I rewrite all...

Jeff:

The code I posted was tested before I posted it. It works for the data shown. SQL has no problem doing an implicit conversion from...

Thanks, Jason.

The reports of my death were greatly exaggerrated.

Thanks to you as well, Emperor Paulpatine.

I'm not surprised that the ITVFs are faster than the scalar functions, but I am surprised by the percentage difference for functions that don't...

Congratulations, Jack!!

... and belated congratulations Saint Lynn!

Thanks, Dave. Exactly the kind of information I was looking for.

Curiousity question. Have you seen any documentation about the performance of scalar functions which do NOT do data access compared to inline table valued functions which produce...

I hope Willem gets the job. 😉

You might also be able to solve your problem using a Common Table Expression (cte) something like this

;with cte as

(

select purchid, vctmovementmonth, dataareaid, -- and any other columns...

Paul,

I assume you are talking about data access within scalar functions, not inline table-valued functions. Data access through ITVF's can be ruthlessly efficient (best I...

Do you even need the temporary table?

You can CAST the text column as VARCHAR(MAX) and do the REPLACE in one UPDATE statement

create table sample (data...

Paul White (1/26/2010)

---

BrainDonor (1/26/2010)

---

Steve, could you give this call a nudge - it appears to be stuck....

http://www.sqlservercentral.com/Forums/FindPost853470.aspx

The same message three times in a row - he's determined someone will write...

Thanks, Jon. 😀

A new way to confuse Steve? BRILLIANT!!

Hello...

Hello...

Is this thing on?