I was recently trying to do the same thing in SQL Server 2k & came up with something like the following as an XML template file but saved with a kml extension:

SELECTCONVERT(char(8),PP_Arrival_Date,14)AS 'name',

PP_Diag_DescAS 'description',

Point.LongLatAS 'coordinates'

FROMTodayByPostcode Placemark

INNER JOIN Postcodes.dbo.[All Scotland Postcodes with LatLong] Point ON Placemark.PP_Postcode = Point.Postcode

ORDER BY PP_Arrival_Date

FOR XML auto, elements

where Point.LongLat contains the Longitude Latitude pair of the centroid of each postcode & looks like: -3.0894, 58.2487

and then I just open the URL to the KML file (e.g. http://myserver/inetpub/template/Test2.kml) in Google Earth from anywhere within my intranet to view an up to date set of points.

I hope to develop this properly eventually, but I'm really still a beginner at all this so there may be much better ways of doing this !