Hi Sean,

I'd be happy to. Send it along.

Thanks

I got it to work by doing this:

declare @sql nvarchar (max)

declare @server varchar(64)

declare @db varchar(64)

declare @table varchar(64)

select @server = quotename(parsename('[server].j3688802s.dbo.sample_web', 4))

select @db = parsename('[server].j3688802s.dbo.sample_web', 3)

select @table...

I just used this yesterday, if you're ever in the market for a quick select:

sp_MSForEachDB @command1='USE ?;

SELECT

Table_Catalog

,Table_Schema

,Table_Name

...

jimbobmcgee (7/8/2013)

---

Not that I advocate this approach, at all, but the following should allow you to get a column list for any server/database/schema/table combo...

DECLARE @liststr NVARCHAR(MAX) =...

Steven Willis (7/7/2013)

---

erikd (7/7/2013)

---

I'm just not sure how to do it.

When I run:

select @liststr = coalesce(@liststr+',' ,'') + quotename(column_name)

from [server].j3688802s.information_schema.columns where table_name = 'sample'

print (@liststr)

I get a list of column...

Almost:

declare...

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

dwain.c (7/2/2013)

---

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

dwain.c (7/2/2013)

---

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

dwain.c (7/2/2013)

---

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

I was looking at this script a month or so ago. Maybe you can make it work for your purposes? It sounds pretty close already.

http://www.sqlservercentral.com/scripts/T-SQL/95877/

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

HanShi (7/1/2013)

---

The code you posted in the first post does NOT contain a cursor. It...

The reason that doesn't work in my case is that the staging tables have certain columns (like statusflag) that are used to determine good vs. bad data, and then only...

Totally fine with me. Link is sent.

Thanks