The only actual duplicates I see are:

insert into SC values ('k','22222','N/A')

insert into SC values ('k','22222','N/A')

RBarry's method will handle those two. The rest aren't strict duplicates. If you want...

You'll have to have single-quotes around it.

The problem is the Inner Join to Profiles.

Try this:

;WITH CTE (RequestMonth, HoursRequested, HoursWorked) as

(SELECT datepart(month, TimeOffRequests.FromDate),

TimeOffRequests.Hours, Profiles.HoursWorkedInDay

FROM dbo.TimeOffRequests

INNER JOIN dbo.Profiles

ON TimeOffRequests.UserID = Profiles.UserID

WHERE Profiles.ReportsTo = @managerUserid

AND TimeOffRequests.Status = @status

AND...

If a table has less than 200 rows, SQL Server won't even use non-clustered indexes.

sp_recompile doesn't actually affect views directly. Per Books Online, "Is the qualified or unqualified name of a stored procedure, trigger, table, or view in the current database. object is...

You might also want to change:

set @LatCalc=(@Radius/69)

set @LngCalc=(@Radius/69)

to:

set @LatCalc=abs(@Radius/69)

set @LngCalc=abs(@Radius/69)

That way, if someone accidentally enters a negative value for the radius, it will still work. Kind of paranoid, but...

Change:

declare @LatCalc int

declare @LngCalc int

to:

declare @LatCalc float

declare @LngCalc float

See if that fixes it for you.

Should have Okeana, OH for that Zip code. There are approx 300 Zip codes within approx 50 miles of that Zip.

(Edit: Took less than 1 ms of CPU time,...

Jeff Moden recently posted an article on the front page of this site about calculating running totals. That should give you what you need.

That looks like it should work.

Matt Minnis (4/29/2008)

---

What about matrix type calculations?

How can they be accelerated?

What I mean is you have a bunch (about a dozen) of tables with charts of tax rates,freight rates, etc.

Each...

d_sysuk (4/29/2008)

---

There is a more subtle point, Im making in the query plan optimisation that is saved.

A greater man, than I has quite nicely explained this , have a quick...

A check constraint will work. There are also ways to solve this with a trigger.

You might want to test a few options on both of those concepts and see...

Per Books Online, synonyms can be created for:

Assembly (CLR) Stored Procedure

Assembly (CLR) Table-valued Function

Assembly (CLR) Scalar Function

Assembly Aggregate (CLR) Aggregate Functions

Replication-filter-procedure

Extended Stored Procedure

SQL Scalar Function

SQL Table-valued Function

SQL Inline-table-valued Function

SQL Stored...

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.