Never mind I figured it out... here is the completed sql:

declare @emplid char(11)

declare emplid_cursor cursor read_only for

select distinct(ps_al_chk_hrs_ern.emplid)

from ps_al_chk_hrs_ern where check_dt='date'

open emplid_cursor

fetch next from emplid_cursor

into @emplid

while @@fetch_status=0

begin

select ps_job.empl_status as...