Compare Row Count of Lines to Batch Header Count

HeaderAndLinesCountCompare.sql

/*
  Quick query to compare a count total at header level to line count of successful rows i.e. 1 -> Many integrity check
  to ensure the correct row count of lines matches header
*/

select 
	sph.Id,
	sph.Filename,
	sph.Status,
	sph.CreatedAt,
	case when sph.BatchRowCount = (
		select 
			count(Id) 
		from 
			MyLines spl 
		where 
			spl.Status = 'Imported'
		and
			spl.HeaderId = sph.Id
	) then 1 else 0 end as BatchCountMatched
from
	MyHeader sph
where
	sph.status = 'Imported'