Then a lot more detail will be required to help.

Please post as per the link in my sig

Scalar udf's yes, inline tables udf are fine....

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/10/15/udf-overhead-a-simple-example.aspx

Sound like an out of data statistics and /or parameter sniffing.

Use update statistics first off.

Then Google for parameter sniffing.

If that doesent sort it , please post as per the links...

Left join would be better...

SELECT origin_latitude, origin_longitude, COUNT(*) AS Structures

FROM towergrid_reference_natowers

left join towergrid_reference_clli

...

you need "datepart(dw,"

Check BOL for more details

http://msdn.microsoft.com/en-us/library/ms174420.aspx

A View should be

Create View JobPostingView

as

SELECT Job_Posting.Transaction_Date,

...

Just on this subject.....

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/16/bad-habits-to-kick-mishandling-date-range-queries.aspx

Im going to duck out of this thread , what you are describing is a set of circumstances that are alien to me.

You may as well want a different value...

Personally , i think its pretty shoddy design that you are trying to execute...

janine.rawnsley (10/20/2009)

---

I'm already capturing the error in the outer SP (even though I don't want to), so checking @@Error after the EXEC will be pretty much the same won't it?

The...

See BOL Here

http://msdn.microsoft.com/en-us/library/ms175976.aspx

The following types of errors are not handled by a CATCH block when they occur at the same level of execution as the TRY…CATCH construct:

...

You've posted into 'Sql Server 7,2000' forum are you not on a later release ?

In guessing so as you have used row_number().

See this article (and the following discussion for advice...

Much faster..

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/10/15/udf-overhead-a-simple-example.aspx

You still seem to be missing the main performance point , you need to set a limit on the long / lat.

Looking at your query plan in one of...

matt6749 (10/19/2009)

--> @radius is in miles - I didn't think you could use it with Lat/Longitude calculations??? e.g. ( t1.Latitude between t2.Latitude - @radius and t2.Latitude +...