I'm saying that the query you already have will almost tell you everything you need to know;
SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:s.ID:SliceId@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.PRJ_OBJECT_ID:ResorceID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.FIRST_NAME:FirstName@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.Last_NAME:LastName@,
[color=#ff0000],@SELECT:DIM:USER_DEF:IMPLIED:SDATE:s.SLICE_DATE:SliceDate@[color]
FROM
(
select s.ID,s.PRJ_OBJECT_ID, R.FIRST_NAME, R.LAST_NAME, s.SLICE_DATE from prj_blb_slices s
JOIN SRM_RESOURCES R on R.ID = S.PRJ_OBJECT_ID
[color=#ff0000]/* where slice = 0 remove this line */[color]
[color=#ff0000]WHERE SLICE_REQUEST_ID = 1 /* this is the DAILYRESOURCEAVAILCURVE slice */[color]
) s
Where slice_date BETWEEN @where:param:user_def:date:paramstartdate@ AND @where:param:user_def:date:paramenddate@
AND @FILTER@
This will give you a grid of data;
1/1 2/1 3/1 4/1 5/1
DAVE 7.5 7.5 7.5 7.5 7.5
Kaushal 8 0 0 0 8
You could use DECODE or CASE to convert '0' to 'Holiday' and non-zero to 'Working' if you liked, but you don't
need another query to get what you need.
--
(Note though that your solution will only report data where your availability slice (DAILYRESOURCEAVAILCURVE) is defined)