select 'fs' as type, convert( varchar, batchId ) + ':' + convert( varchar, dependentBatchId ) as id, convert( varchar, dependentBatchId ) as predecessorId, convert( varchar, batchId ) as successorId from tbl_EAI_inboundBatches with (nolock) where batchTime >= '#_startDay#' and batchTime < '#_endDay#' and ownerId > 0 and fileFormat not in ( '$ProductFocusFlag', '$prdDataIntegrityScan', '$TPM_ARCHIVECLAIMS', '$TestStudioPerformanceLogProcessor' ) and processedTime is not null and dependentBatchId > 0 for json auto, include_null_values