David,

I was looking at your code you posted, and I have a couple of suggestions for you.

First, create the function as an in-line table-valued function (TVF). Not only is much...

Jeff Moden (9/3/2010)

---

Thank you for the reference and for helping others, as...

Hugo Kornelis (9/5/2010)

---

I am sorry, Wayne. I never knew this is configurable. Thanks for teaching me something new. I believe that Paul has already helped you find the posts I...

Here’s a very simplistic case:

You have a field to enter a user name and password.

The underlying web screen...

vijay-367524 (9/5/2010)

---

Yes,You are...

Thanks Paul.

Hugo Kornelis (9/3/2010)

---

Please go back to page 4 of this topic. One of my posts on that page includes a very fast algorithm that completely avoids undocumented features. And further...

Alvin Ramard (9/3/2010)

---

CirquedeSQLeil (9/3/2010)

---

Steve Jones - Editor (9/3/2010)

---

Alvin Ramard (9/3/2010)

---

Looks like the posting is slowing down. People must be be getting ready for the long weekend.

The next 90 minutes...

Nevyn (9/3/2010)

---

How good is the performance on the split function?

As Lutz pointed out, we only need to grab one thing from the list (always the second item) so I wonder...

Thanks Jeff. You're a good teacher!

As requested: Delimited Split Function

Usage:

DECLARE @test-2 TABLE (Col1 varchar(100));

INSERT INTO @test-2

SELECT 'change street, 44319' UNION ALL

SELECT 'someother street, 44444';

WITH CTE AS

(

SELECT *

FROM @test-2

...

This does a compare against birthday of this year, OR next year, being between date range of today thru next 7 days.

I threw in a sample case of someone being...

Just to make sure I understand:

1. You have a file (file 1) that contains a list of other files.

2. All of the files listed in file 1 need to be...

LutzM (9/3/2010)

---

WayneS (9/2/2010)

---

...

Based on this, where the work order ID is the 2nd "field" in this string, I would suggest :

declare @test-2 varchar(100);

set @test-2 = 'W~W51247~0~1~0';

select Item

from dbo.DelimitedSplit8K(@test,...

francesco_uk (9/3/2010)

---

Hi,

I have some doubts on the 32-bit/64-bit compatibility between SQL Server, SAP and the underlying OS. Can somebody explain me in a general manner how does this all work?

Q1:...