I think someone needs to look at the data in the tables.  How many times is a ZipCode listed in the neigborhood Profiles table?  You could be spawning dozens or...

Scott's method will certainly work!  I'd still like to know why "net" wants to do this...

You may be able to get a bit more performance out of it by changing this...

WHERE     neighborhoodinfo.dbo.Profiles.ZIP IS NOT NULL

...to this...

WHERE     neighborhoodinfo.dbo.Profiles.ZIP > '00000'

... which will also exclude "bad" zip...

Other than adding a primary key (defaults to clustered), there's not much you can do to increase the performance of a SELECT * other than pinning the table (as someone...

Won't work @@Identiy is a scalar function the returns the last identity value created in ANY table by anything in the current scope chain including triggers.

John Mitchel is correct... you'll...

I'm not sure why you need the performance hit of the split function...

For example, here's an example that splits a whole table at once (this one splits on periods which you...

That's because all the good guys are on this forum

You can get rid of the trailing...

If you can read it (dang, that's small print ), Tim's WHILE loop works just fine on the straight output... so I'll concentrate...

Yep... not enough coffee there... you can do it with a table but not a proc.

I didn't read the column name... Serqiy is correct.  I don't allow folks at work to store XML in any database at anytime.  I make the rip it apart and...

Or...

IF OBJECT_ID('dbname.dbo.objectname') IS NOT NULL

DROP objecttype dbname.dbo.objectname

Get External Data cannot see sprocs or results of sprocs.  You will need to make a "pass through" query.  See the Excel documentation for help on that.

CHAR adds trailing spaces until the column is full.  When you convert to VARCHAR, those spaces are retained and that's probably what is making the join fail.

Lookup the following in Books Online (Transact-SQL Help from Query Analyzer)...

sp_addlogin

sp_grantdbaccess

Two tables with a common key will be much much easier than a Text column... put the VARCHAR(8000) column in the second table along with the primary key of the...