exec scaler-value function sql server 2005
Posted on 2007-03-28
Hi, I am trying to exec a scaler-function from a stored proc but every time I test the stored proc it says,
Msg 208, Level 16, State 3, Procedure getPostCodes, Line 19
Invalid object name 'DistanceBetween'.
This is my function top....
ALTER FUNCTION [dbo].[DistanceBetween] (@Lat1 as real,
@Long1 as real, @Lat2 as real, @Long2 as real)
in my proc I just say select * from DistanceBetween and pass in the four values
This is sql server 2005
Grateful for any help