with preData as ( select distinct businessOwnerUserId, businessOwnerFirstName, businessOwnerLastName, businessOwnerEmail, businessOwnerFirstName + ' ' + businessOwnerLastName as businessOwnerFullName from tbl_DW_OperatorAgreements#_tableSuffix# with (nolock) where ownerId = and ownerType = and businessOwnerUserId > 0 and businessOwnerUserId in ( ) select cast( null as integer ) businessOwnerUserId, cast( null as varchar ) businessOwnerFirstName, cast( null as varchar ) businessOwnerLastName, cast( null as varchar ) businessOwnerEmail, cast( null as varchar ) as businessOwnerFullName ), data as ( select * from preData where businessOwnerUserId > 0 ) #forJSON( 'data', attributes.datastore, 'businessOwnerFullName' )#