declare @ownerId int = ; declare @ownerType varchar(3) = ; with purposes as ( select purposeId, purposeName, partnerType, crmActive, purposeDescription, sortRank, requireComment, allowFinalizeWithoutProducts from tbl_CRM_InteractionPurposes with (nolock) where ownerId = @ownerId and ownerType = @ownerType ) #forJSON( 'purposes', attributes.datastore, 'sortRank' )#