FUNCTION fObjidFromSDSS

Computes the long objID from the 5-part SDSS numbers.

The bit-fields and their lengths are skyversion[5] + rerun[8] + Run[16] + Camcol[3] + mu[8]+ field[11] + obj[13]
select dbo.fObjidFromSDSS(752,8,3,300,12) as fObjid

Input and output parameters

name type length inout pnum

@skyversion int 4 input 1

@run int 4 input 2

@rerun int 4 input 3

@camcol int 4 input 4

@field int 4 input 5

@obj int 4 input 6

bigint 8 input 0

name	type	length	inout	pnum
@skyversion	int	4	input	1
@run	int	4	input	2
@rerun	int	4	input	3
@camcol	int	4	input	4
@field	int	4	input	5
@obj	int	4	input	6
	bigint	8	input	0