FUNCTION  fSDSSfromObjID

Returns a table pf the 6-part SDSS numbers from the long objID.

The returned columns in the output table are: skyversion, rerun, run, camcol, firstField, field, obj
select * from dbo.fSDSSfromObjID(objid)

Input and output parameters

nametypelengthinoutpnum
@objidbigint8input1
skyVersiontinyint1output1
camcoltinyint1output4
firstFieldtinyint1output5
runint4output2
rerunint4output3
fieldint4output6
objint4output7