PROCEDURE  spGetSpecNeighborsAll

Get the spectro neighbors to a list of @ra,@dec pairs in #upload

The procedure is used in conjunction with a list upload service, where the (ra,dec) coordinates of an object list are put into a temporary table #upload by the web interface. This table name is hardcoded in the procedure. It then returns a matchup table, containing the up_id and the SDSS specObjId. The result of this is then joined with the SpecObjAll table, to return the attributes of the photometric objects.
create table #x (id int,specObjID bigint)
insert into #x EXEC spGetSpecNeighborsAll 2.5

Input and output parameters