WayneS (5/1/2009)

---

I guess it's a good thing that I didn't ask you how to get to it :-)...

Jeff Moden (5/1/2009)

---

Florian Reischl (5/1/2009)

---

TheSQLGuru (5/1/2009)

---

Flo, are you getting your reads from SET STATISTICS IO ON? IIRC UDFs don't report IO correctly in this manner. Try getting them...

jcrawf02 (5/1/2009)

---

Lynn Pettis (4/29/2009)

---

Now for something totally the same...

How...

Any additional criteria for the delete would also be helpful.

Can you post the generalized schema of the tables, indexes, RI (if any), some sample data (readily consumable)?

This looks like fun.

Depending on how...

Paul White (5/1/2009)

---

Lynn,

I'm thinking that that TVF might be adapted to accept a string of characters to keep as a parameter.

Returning a set of characters to strip would allow Jeff's...

Ed (5/1/2009)

---

Using the DATEDIFF function works but can be very slow.

I prefer using:

DECLARE

@FromDate DATETIME,

@ThruDate DATETIME

SET @FromDate = CONVERT(VARCHAR, GETDATE(), 101) --mm/dd/yyyy 00:00:00.000

SET @ThruDate = DATEADD(DAY, 1, @FromDate)

SET @ThruDate = DATEADD(MS,...

Don't know if it is worth anything, but here is an In-Line TVF that will return 256 ASCII characters:

alter function dbo.ufnChar256()

returns table

as return(

with Numbers16 (

N

) as...

WayneS (5/1/2009)

---

Hey Steve...

I was (quickly) moving my mouse to go to the link to move to the next page on this thread, and a little popup window came up to...

Also consider that the routine already is complex. If you pass an INT you get an INT in return; if you pass a DECIMAL you get a DECIMAL in...

Heck no! I...

Florian Reischl (4/30/2009)

---

Hi John

I'm quiet sure that English is not her/his first language (due to the "Ja" I think he is German) but this is not the problem. I would...

Paul White (4/30/2009)

---

Lynn Pettis (4/30/2009)

---

I'm glad someone else took the time to read through your unformatted code, as I really didn't have the time. A good...

Having reviewed the article, I highly agree with the comment to print the article and give it to your boss.