PROCEDURE  spGetNeighborsAll

Get the 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 objId. The result of this is then joined with the PhotoTag table, to return the attributes of the photometric objects.
create table #x (id int,objID bigint)
insert into #x EXEC spGetNeighborsAll 2.5

Input and output parameters