try below query to get Availability for Resource each week start
select res.unique_name [Resource Id], res.first_name+' '+res.last_name [Resource Name], slice_date [Week Start Date], slice [Availability] from prj_blb_slices wk
join prj_blb_slicerequests req on wk.slice_request_id=req.id and req.request_name = 'WEEKLYRESOURCEAVAILCURVE'
join srm_resources res on res.id=wk.prj_object_id