Gentlemen,

We are all gentlemen here right? Is it too late to join the party, or skirmish as the case may be?

How's this one stack up in your test harness...

erikd (7/2/2013)

---

dwain.c (7/2/2013)

---

Oh and BTW, I was getting times of around 65000 ms (for PatternSplitCM) on my clocked down laptop against the 1,000,000 rows of random phone numbers I was...

Jeff Moden (7/2/2013)

---

Wait a minute, please. There's something I don't understand. It would appear that you're capturing data from one table at a time. Are you telling...

Good idea there to...

Oh and BTW, I was getting times of around 65000 ms (for PatternSplitCM) on my clocked down laptop against the 1,000,000 rows of random phone numbers I was generating in...

You're going to have a bit of a problem if you're using SQL 2005.

You don't need to worry about PatternSplitLoop as it is not the fastest of the methods. ...

Erik - Just because your Prod system doesn't have a million rows to test against, doesn't mean you can't test against a million rows!

The test harness in the article demonstrates...

Please don't get me wrong when I say this. That is today. Once...

Learner44 (7/2/2013)

---

Hello friends,

I am executing bunch of Insert satements as follows:

use Testing

go

INSERT INTO Table_Update(TableName,StartlastWritten) SELECT 'Students'As Tbl, MAX(LASTWRITTEN) AS StartLastWritten FROM [10.198.68.39]..dbo.Students;

.

.

.

.

.

INSERT INTO Table_Update(TableName,StartlastWritten) SELECT 'teachers'As Tbl, ...

Eliot's answer is basically correct but you could use the OUTPUT statement instead of a trigger.

Something like:

CREATE TABLE #StatusChanges (Status1 VARCHAR(20), Status2 VARCHAR(20));

UPDATE YourTable

SET Status = 'Approved'

OUTPUT DELETED.Status, INSERTED.Status

INTO #StatusChanges

WHERE...

erikd (7/2/2013)

---

I use the following SVF to extract integers only from phone number columns. So, you would run the following and it would return only the numbers from your patid...

Lynn Pettis (7/1/2013)

---

Just dropping by to let you know where I am.

I made it to Bagram last night but looks like I get to hang out here another day (at...

Sean Lange (6/27/2013)

---

DataAnalyst011 (6/27/2013)

---

From time to time I need to check if a column is completely numeric (or usually, check for the row contain something other than numeric). I've read...

Perhaps using an AFTER INSERT TRIGGER?

dwain.c (6/5/2013)

---

Wolf Kill - If you're still listening I need some further advice.

I was able to get the thing to work by changing this line in the SP:

,@useself='TRUE', @locallogin='myaccount';

To something...