FUNCTION  fGetNearestSpecObjIdAllEq

Returns the specObjID of nearest photo object within @r arcmins of ra, dec

ra, dec are in degrees, r is in arc minutes.
This scalar function is used for matchups of external catalogs.
It calls fGetNearestSpecObjAllEq(@ra,@dec,@r), and selects the specObjID (a bigint).
This can be called by a single SELECT from an uploaded (ra,dec) table.
An example:

SELECT id, ra,dec, dbo.fGetNearestSpecObjIdAllEq(ra,dec,3.0) as specObjID
FROM #upload
WHERE dbo.fGetNearestSpecObjIdAllEq(ra,dec,3.0) IS NOT NULL

Input and output parameters