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