Could be any of a dozen different problems... you need to post the code you're using and the CREATE statement for the table you are importing to.

Grant, I'm with you... I see no compelling reason for CLR's. My opinion, for the most part, for them being there is the same as DTS and Cursors... they...

The easiest way to split limited (up to 4 parts) period-delimited text of this nature is to use PARSENAME. Look it up in Books Online for a full explanation.

Here's...

This is very nearly a duplicate post...

http://www.sqlservercentral.com/Forums/Topic410280-65-1.aspx

The only thing that means anything about performance for all the timers you have here is this...

Number of TDS packets received 28569 28569

Number of...

That information is available in Books Online ("Transact-SQL Help" under Help button in Query Analyzer). Lookup "Execution Plan pane" in the index...

If you're asking how long we think it should take for you to process the 1.7 million rows that your are... we have no clue because we don't know what...

SELECT *

FROM yourtable

WHERE Address1 LIKE '[0-9]%'

You could have also used TRUNCATE table which resets the ID column back to 1.

But, even that doesn't "Fix" it... why are you using a cursor? Perhaps if you...

NEWID() won't guarantee it... it's only guaranteed at the full 32 characters.

What's wrong with this?

SELECT CAST(CAST(0x0013020061675035 AS BIGINT)+1 AS VARBINARY)

If you find the largest item in the column, just add...

I only see the column names being returned... no data types...

Notice, the answer above was almost as short and useful as the question... if you want a real answer, could you provide just a wee bit more info about what...

Absolutely... 😉

If you want something slick to split addresses and validate them at the same time, look into a product called "ZP4".

Christopher Klein (10/12/2007)

---

Just a pre-coffee question but are tables defined as #temp unique to a particular instance of being called?

Say I have a stored procedure that builds up a #temp...

What datatype is the column, really? Is it TEXT, VARCHAR, NVARCHAR, or ???