declare @ownerId int = ; declare @ownerType varchar(3) = ; with projects as ( select p.projectId, p.projectName, p.startDate, p.endDate, nullif( p.projectOwnerUserId, 0 ) projectOwnerUserId, m.firstName + ' ' + m.lastName as projectOwnerFullName from tbl_WRK_Projects p with (nolock) left outer join tbl_FSPRO_Members m with (nolock) on m.ownerId = p.ownerId and m.fsl_tablecode = p.ownerType and m.fspro_userId = p.projectOwnerUserId where p.ownerId = @ownerId and p.ownerType = @ownerType and p.projectId in ( ) ) #forJSON( 'projects', attributes.datastore, 'projectName' )#