select reasonId, reasonName, sortRank from tbl_TPM_ClaimStatusReasons with (nolock) where ownerId = and ownerType = order by sortRank, reasonName for json auto, include_null_values