Jeff Moden (4/25/2008)

---

GSquared (4/25/2008)

---

That's going to work better than spaces around the "like" statement. Of course, if you want it to include "pros" (plural), or "professional"/"professionals", you can add...

Gail (4/25/2008)

---

hey matt 2 things

one when executing the original query you posted i get

The multi-part identifier "Ufn_GetLocationsInRadius.distance" could not be bound.

for the line in the select statement...

Well as with many situations - the answer to "the best way to parse" will be - it depends. T-SQL has some fairly decent built-in functions, but they fall short...

SQLServerLifer (4/24/2008)

---

You missed the fact that the function returns all zips within a specified radius. It needs to be TBV'd.

Try this...

SELECT

mytable1.dbo.app_TelephoneDetails.FirstName,

mytable1.dbo.app_TelephoneDetails.LastName,

mytable1.dbo.app_TelephoneDetails.City,

mytable1.dbo.app_TelephoneDetails.State,

mytable1.dbo.app_TelephoneDetails.ZIPCode,

Ufn_GetLocationsInRadius.distance,

...

Sergei Zarembo (4/24/2008)

---

GSquared,

please tell me which Matt's regex...

Since you're in 2005 - you might care to sprinkle a few "with recompile" statements in there, especially if you use conditionals in the WHERE clause like Grant is talking...

Erik (4/24/2008)

---

Matt,

Are you sure this is the case? I just created a proc which creates a temp table called "#temp" and ran the proc through SQL Management Studio. After the...

I guess I'm making assumptions...

Grant Fritchey (4/24/2008)

---

I'm not sure if means anything in relation to LINQ and the other ORM products, but I've seen systems where the developers used ADO to automagically access the...

WILLIAM MITCHELL (4/23/2008)

---

Maintenance problem:

In Access, when you create a link to an ODBC data source, Access will memorize the schema of the underlying table. If you make a change to...

Replace your WHERE's with ON's...

I've already come across the right...

karthikeyan (4/24/2008)

---

I would like to add some more things.

if i execute the below one, it is giving 3 as the output.

Declare @Nm varchar(25),@Null int

--select @Nm = 'Age'

select @Null = count(*)...

Timothy (4/24/2008)

---

Jack Corbett (4/24/2008)

---

I actually am not against Linq To SQL either, I just wish MS had made it easier to use sp's in Linq and/or did something like iBATIS.NET...

Steve Jones - Editor (4/23/2008)

---

Don't forget that while you might have the panels to power your house, the power is only there part of the day. You need a storage...