Extension for the above question.
How to get a single record fro
I think this might work for you:
select l.leaid as dstid ,max(case when agsh.statisticname='LEPCUR' then agsfh.value else null end) as lepcur ,max(case when agsh.statisticname='LEPFS' then agsfh.value else null end) as lepfs ,agsh.schoolyear as sy from sif.objaggregatestatistic as agsh inner join sif.objaggregatestatisticfact as agsfh on agsfh.statisticrefid=agsh.refid and agsfh.collectionid=agsh.collectionid inner join edfusionods.sif.lea as l on l.refid=agsh.learefid where agsh.statisticname in ('LEPCUR','LEPFS') group by l.leaid ,agsh.schoolyear ;
Thanks for the Update ,
It is working as expected.