Viewing 15 posts - 31 through 45 (of 60 total)
made both changes you suggested still am only getting one resuls
April 29, 2008 at 12:10 pm
GSquared (4/29/2008)
(Edit: Took less than 1 ms of CPU...
April 29, 2008 at 11:46 am
i swear my function was working fine before now it is not returning the results i would expect. I haven't changed anything
Gsquared solution works like you suggested
I get several results
select...
April 29, 2008 at 11:45 am
it is supposed to give me that back zips within 50 miles but it does not give me any rows back
April 29, 2008 at 10:07 am
GSquared (4/29/2008)
Gail, the query you had joins on the Zip code columns. That's what's causing the problem. That, all by itself, eliminates all other Zip codes.
right i thought...
April 29, 2008 at 9:33 am
matt the appoximation query from gsquared worked, the other one you gave me that calls the function still gives me no results with cross apply and only one zip code...
April 29, 2008 at 9:33 am
GSquared (4/28/2008)
Have you tried using my approximate solution? Should give you results in under a second.
I have and I still get same type of results that i got with...
April 29, 2008 at 7:53 am
you mean this one
SELECT
mytable1.dbo.app_TelephoneDetails.FirstName,
mytable1.dbo.app_TelephoneDetails.LastName,
...
April 25, 2008 at 8:16 pm
you are right on the t2.distance i misread what you had wrote before.
as far as not filtering on distance my function does that
Ufn_GetLocationsInRadius(ZIPUSA.LAT,ZIPUSA.LNG,25) that is the last parameter...
April 25, 2008 at 1:14 pm
Matt Miller (4/25/2008)
that's because the Ufn_GetLocationsInRadius is aliased as T2, so put T2.distance in your SELECT, and you should be okay....
As to not getting results - try changing the CROSS...
April 25, 2008 at 9:56 am
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 not...
April 25, 2008 at 7:54 am
bledu (4/24/2008)
forgot to say and can you also post the schema formytable1.dbo.app_TelephoneDetails
I did not create this table as i would had done it a little differently...
CREATE TABLE [dbo].[app_TelephoneDetails](
[TelephoneID] [int]...
April 25, 2008 at 7:14 am
GSquared (4/24/2008)
Let's say you're starting with latitude 47.61, longitude -122.34 (which happens to be in Seattle, WA), and you want to find all...
April 25, 2008 at 7:10 am
ok i got rid of the error for the ufn by using the t2 i still get the other ones relating to zipusa
here is schema
CREATE TABLE [dbo].[ZIPUSA](
[ZIPID] [int] IDENTITY(1,1) NOT...
April 24, 2008 at 1:06 pm
i tried dougs solution but i get
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "ZIPUSA.LAT" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part...
April 24, 2008 at 12:29 pm
Viewing 15 posts - 31 through 45 (of 60 total)