Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using a Dll function in a Stored procedure

Author  Topic 

jweizman
Starting Member

27 Posts

Posted - 2001-03-04 : 08:12:32
Hi,
I would like to use in an SQL Select a function of mine that computes the distance between 2 points on earth.
This function is written in C and is compiled into a DLL.
So how can i have something like
SELECT * from Positions where distance(@lat1,@lon1,48.888,-2.234)<500

Thanks


   

- Advertisement -