Hugo Kornelis (9/5/2010)

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)

Alvin Ramard (9/3/2010)

CirquedeSQLeil (9/3/2010)

Steve Jones - Editor (9/3/2010)

Alvin Ramard (9/3/2010)

The next 90 minutes...

Nevyn (9/3/2010)

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)

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

So, are the only valid characters to be the characters on the keyboard? These will have an ASCII code between 32 and 126. So:

declare @test-2 table (Col1 nvarchar(500));

declare @testdata nvarchar(500);

set...

The...