I'd change that "LIKE" statement to something a little more REGEX-ish.

CREATE TABLE #T (

DT CHAR(10))

INSERT INTO #T (DT)

VALUES ('1/1/11'),('01/01/2011'),('1.1.11'),('1-1-11'),('Bob');

SELECT *

FROM #T

WHERE DT LIKE '%[/.[-]]%[/.[-]]%';

The brackets in the Like statement allow...

The Dixie Flatline (6/2/2011)

---

Gus:

The reason I said use CASE is that you might have cases where the join to T2 succeeds but some other T2.column value is NULL anyway. ...

mister.magoo (6/2/2011)

---

Stephen Ward (6/2/2011)

---

I see what you mean about Atomic transations and agree.

I suppose this update statement isn't an 'all or nothing' situation but if I'm to break it...

brownghost (6/2/2011)

---

thanks ill re enable shared memory..

what about this, i did not see answer for that question?

1. Why are there both 32 and one one called anything = i thing...

mister.magoo (6/2/2011)

---

For anyone who thinks that an infinitely recurring number can simply be redefined as another number, I ask this question:

Does PI (3.14159 etc ) which never repeats = 3.141.......

mister.magoo (6/2/2011)

---

0.999.... = 1 ? No. There I said it.

One is a series of 9s preceeded by a ".", the other is a 1.

You can decide to treat them as...

mtillman-921105 (6/2/2011)

---

....

Regarding epistemology GSquared, what if we're all wrong? I like Nietzsche's take on it better:

The falseness of an opinion is not, for us, any objection to it....

Thomas Considine (6/2/2011)

---

I understood the requirement differently.

If the routine would return, say, name and datatype for all columns, then that would be enough to pass

to generic table editors, simple display...

opc.three (6/2/2011)

---

LutzM (6/2/2011)

---

To quote from a thread I've been involved:

Also, I will start to participate on the site more often. It has always been useful and seems to be very...

I'm not sure how I'd do it in SSIS, but in T-SQL, it would look something like:

DECLARE @XML XML = '<INPUT>

<tag name="DUEDATE">1/25/2011</tag>

<tag name="FORMTYPE">Single Family URAR, FNMA 2005 Form 1004</tag>...

The first thing I'd do is get a copy of SQL Server Express Edition, and walk through converting the database to SQL Server. Azure is similar enough that it...

How accurate do you need it to be, and how big is the total space you are mapping?

If, for example, all of your stores are in one city, then just...

Actually, Coalesce or IsNull would probably handle the Case statement logic in this scenario.

Well, you can look into Isolation Levels and all that for data on locks and how to deal with them.

But really, since transactions are supposed to be Atomic (ACID), you...

toddasd (6/2/2011)

---

GSquared, I think it would be a wonderful thing to sit at a bar and have some beers with you. We would probably spend the whole night debating when...