I use appraoch #2 and that working fine for me...

SQL Server 2012 does not support Linked Server to SQL Server 2000, workaround[/URL]

Solution for your problem may be something like that:

SELECT

PeopleID

,Name

,COALESCE([1],0) AS Score1

,COALESCE([2],0) AS Score2

,COALESCE([3],0) AS Score3

...