Excellent points brought up by the author of 40 Years of Programming !  I don't think he or she was wanting paper documentation to come back -- all they wanted...

Sounds good, however, you could comment out the following line and everything will still work:

IF ((@lat1 = @lat2) AND (@lon1 = @lon2)) RETURN 0

Also, see the wiki article regarding...

I had the same problem years ago. You have to do an interim check to the value you send to ACOS; see function below ...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/*

*...

Ha! - store *every* column as VARBINARY(max) and never worry about data types again!

Nice article Gail...

Which brings up MY question regarding data types...

Using MS SQL Server -- I'll be working on a project in the near future where we need to store latitude...

Andrew G,

Brilliant -- Thanks!

I also found the following, which could be useful once you have a list of all the procedure names:

/*

* Returns the source text for the stored procedure...

Wesley Norton ...

Yes! -- the database I was checking was inherited (from SQL 2000) and I did not know the compatibility mode was still at 80 !!!

Thanks!!

Ok -- here is the script I tried -- (basically, I just removed ALL comments):

;with PerformanceMetrics

as

(

select

substring

(

dest.text,

statement_start_offset/2,

case when statement_end_offset = -1 then LEN(dest.text)

else statement_end_offset

end /2

) as 'Text of the SQL' ,

deqs.plan_generation_num...

Hello,

Still no luck; I copied and pasted the script you posted here. SQL 2008 R2 displays the following:

Msg 102, Level 15, State 1, Line 51

Incorrect syntax near '.'.

Tried to...

I must be missing something, when I cut-and-paste the query into SQL, I get the following:

Msg 102, Level 15, State 1, Line 53

Incorrect syntax near '.'.

tried on Microsoft SQL Server...

Ok -- thanks,

With regard to "making things faster" -- what do people normally do -- rename every stored procedure and then go through all the code and rename as well?...

The formula given is the "law of cosines" -- the constant 3963.0 is the earths mean radius (in miles).

To change the formula to km, replace 3963.0 with 6371.0

Altenatively, and I...

Hi Jeff,

Yes -- as a programmer, it was natural to think of a solution using bitmasks; and it actually works fairly well on SQL server -- however, I am open...