Your SQL command was:
CREATE TABLE #upload ( up_id int,  up_ra  Float, up_dec  Float, up_sep  Float) 
INSERT INTO #upload values ( 1,256.443154,58.0255,1.0 ),( 2,29.94136,0.0893,1.0 )  
CREATE TABLE #x (up_id int,SpecobjID numeric(20))  
INSERT INTO #x 
SELECT up_id,  dbo.fGetNearestSpecObjIdEq( up_ra,up_dec,up_sep ) as SpecobjId  
FROM #upload 
WHERE  dbo.fGetNearestSpecObjIdEq( up_ra,up_dec,up_sep ) IS NOT NULL 
SELECT TOP 50 
 s.ra,s.dec,s.plate,s.mjd,s.fiberid,p.run,p.rerun,p.camCol,p.field,p.obj 
FROM ..SpecObj as s 
JOIN ..PhotoObj AS p ON s.bestObjID = p.objID 
JOIN #x AS x ON x.SpecobjID=s.SpecobjID 
JOIN #upload AS u ON u.up_id = x.up_id    
ORDER BY x.up_id 

Your query output (max 500,000 rows):

radecplatemjdfiberidrunreruncamColfieldobj
256.4431558.02525335551788322133930115653
29.9413590.0893005894035187155642633014315171

Use the button(s) below to upload the results of the above query to the SAS and retrieve the corresponding FITS files:

Upload list of fields to SAS

Use the button(s) below to upload the results of the above query to the SAS and from there click Search to download or view the spectra:

Upload list of spectra to SAS