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

Thought I'd post something folks can play with... could easily be turned into a proc... can be easily modified for an Insert/Values instead of an Insert/Select. With a little forethought,...

Nigel Rutter (10/4/2007)

---

Doesn't need to use a cursor, it can be replaced by:

SELECT @InsertQuery = @InsertQuery + column_name + ',' from ##Temp_Generate

Hope Jeff M doesn't see...

dobrzak (4/6/2006)

---

I don't think that it is possible with sp_MSforeachtable, but why don't use systems table, eg.:

SELECT object_name(id), rows

FROM sysindexes

WHERE indid...

SELECT @@VERSION

Then, check the Microsoft site for the build number...