Hi,
I have a sql 2005 function who return a distance from 2 zipcodes. This function is called from a Stored procedure like this :
SELECT *, dbo.fn_GetDistance (...) AS Distance
In this function, i have a Latitude and i want this Latitude to be also returned.
It is possible or a function can return only one variable?
If it is possible, what's the syntax of it?
Thanks in advance
You can return a table, something like this:
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATEFUNCTION LongLatDistance
(-- Add the parameters for the function here
@.ZipCode1varchar(10),@.ZipCode2varchar(10))
RETURNS @.ResultTableTABLE(LongitudeDecimal(18,6),Latitudedecimal(18,6),Distancedecimal(18,6))
AS
BEGIN
INSERTINTO @.ResultTable (Longitude,Latitude,Distance) SELECT FieldsFROM TableName
RETURN
END
GO
|||And i call it how from the stored procedure?
|||SELECT Longitude,Latitude,Distance FROM dbo.LongLatDistance('90210',92630')
I wasnt clear on what exactly else you wanted to return. The sample is only returning the coords of one zip code, you would modify it obviously for your situation.
