UFN_SALESORDER_RESERVATIONSTAFFASSIGNMENT_FLAT

        create function dbo.UFN_SALESORDER_RESERVATIONSTAFFASSIGNMENT_FLAT (@SALESORDERID uniqueidentifier)
        returns table
        as
        return (
            select max(case RowNum when 1 then V1.VOLUNTEERTYPE else null end) as STFTYPE1,
                max(case RowNum when 1 then V1.ASSIGNEDTO else null end) as STFNAME1,
                max(case RowNum when 1 then V1.STARTTIME else null end) as STFST1,
                max(case RowNum when 1 then V1.ENDTIME else null end) as STFET1,
                max(case RowNum when 1 then V1.INITERARYNAME else null end) as STFIN1,
                max(case RowNum when 1 then V1.ITINERARYITEMNAME else null end) as STFII1,
                max(case RowNum when 1 then V1.QUANTITYOPEN else null end) as STFOPEN1,
                max(case RowNum when 1 then V1.PRICE else null end) as STFPRICE1,
                max(case RowNum when 2 then V1.VOLUNTEERTYPE else null end) as STFTYPE2,
                max(case RowNum when 2 then V1.ASSIGNEDTO else null end) as STFNAME2,
                max(case RowNum when 2 then V1.STARTTIME else null end) as STFST2,
                max(case RowNum when 2 then V1.ENDTIME else null end) as STFET2,
                max(case RowNum when 2 then V1.INITERARYNAME else null end) as STFIN2,
                max(case RowNum when 2 then V1.ITINERARYITEMNAME else null end) as STFII2,
                max(case RowNum when 2 then V1.QUANTITYOPEN else null end) as STFOPEN2,
                max(case RowNum when 2 then V1.PRICE else null end) as STFPRICE2,
                max(case RowNum when 3 then V1.VOLUNTEERTYPE else null end) as STFTYPE3,
                max(case RowNum when 3 then V1.ASSIGNEDTO else null end) as STFNAME3,
                max(case RowNum when 3 then V1.STARTTIME else null end) as STFST3,
                max(case RowNum when 3 then V1.ENDTIME else null end) as STFET3,
                max(case RowNum when 3 then V1.INITERARYNAME else null end) as STFIN3,
                max(case RowNum when 3 then V1.ITINERARYITEMNAME else null end) as STFII3,
                max(case RowNum when 3 then V1.QUANTITYOPEN else null end) as STFOPEN3,
                max(case RowNum when 3 then V1.PRICE else null end) as STFPRICE3,
                max(case RowNum when 4 then V1.VOLUNTEERTYPE else null end) as STFTYPE4,
                max(case RowNum when 4 then V1.ASSIGNEDTO else null end) as STFNAME4,
                max(case RowNum when 4 then V1.STARTTIME else null end) as STFST4,
                max(case RowNum when 4 then V1.ENDTIME else null end) as STFET4,
                max(case RowNum when 4 then V1.INITERARYNAME else null end) as STFIN4,
                max(case RowNum when 4 then V1.ITINERARYITEMNAME else null end) as STFII4,
                max(case RowNum when 4 then V1.QUANTITYOPEN else null end) as STFOPEN4,
                max(case RowNum when 4 then V1.PRICE else null end) as STFPRICE4,
                max(case when RowNum > 4 then 'More staff resources...' else null end) as STFTYPEREST
            from 
                (select f1.VOLUNTEERTYPE, f1.ASSIGNEDTO, substring(convert(varchar,convert(datetime,stuff(f1.STARTTIME,3,0,':')),100),12,8) as STARTTIME, 
                    substring(convert(varchar,convert(datetime,stuff(f1.ENDTIME,3,0,':')),100),12,8) as ENDTIME, f1.INITERARYNAME, f1.ITINERARYITEMNAME, f1.QUANTITYOPEN, 
                    ITINERARYSTAFFRESOURCE.PRICE, row_number() over (order by ITINERARYSTAFFRESOURCE.PRICE desc) as RowNum
                from dbo.UFN_SALESORDER_RESERVATIONSTAFFASSIGNMENT(@SALESORDERID) as f1 left join dbo.ITINERARYSTAFFRESOURCE on f1.ID = ITINERARYSTAFFRESOURCE.ID) V1
            )