declare @ownerId int = ; declare @ownertype varchar(3) = ; declare @formId int = ; with data as ( select r.ownerId, r.ownerType, r.formId, r.recipientType, r.recipientUserId, m.fspro_userId, m.lastName + ', ' + m.firstName as lastNameFirstName, m.firstName, m.lastName, m.firstName + ' ' + m.lastName as fullName, m.ownerId recipientUserOwnerId, m.fsl_tablecode recipientUserOwnerType, m.email, m.staffMember, f.fieldId sourceFieldId, rtrim( f.category ) + '_' + rtrim( f.name ) as sourceFieldName, r.sourceFieldOp, r.sourceFieldValue, l.selectionValue, l.selectionLabel from tbl_WRK_FormRecipients r with (nolock) inner join tbl_FSPro_members m with (nolock) on m.fspro_userid = r.recipientUserId and m.ownerId > 0 and m.loginEnabled = 1 left outer join tbl_WRK_Fields f with (nolock) on f.ownerId = r.ownerId and f.ownerType = r.ownerType and f.fieldId = r.sourceFieldId left outer join tbl_WRK_FieldLookups l with (nolock) on l.ownerId = f.ownerId and l.ownerType = f.ownerType and l.fieldName = f.name and l.selectionValue = r.sourceFieldValue where r.ownerId = @ownerId and r.ownerType = @ownerType and r.formId = @formId ) #forJSON( 'data', attributes.datastore, 'fullName' )#