Could HTTP Soap / T-SQL endpoint be replaced by Reporting Services XML Reports?
I have been working on a POC using SQL Server 2008 and Google Maps. The POC was to use Geo Spatial technology to illustrate our Geo Spatial data easily. I will talk about this in more detail in another blog post as I would like talk about a problem I faced while creating this POC. The problem I faced was how could I get my Geo Spatial data, which was stored within SQL Server 2008 using the new geography data type, into "static" HTML? So I thought that SQL Server HTTP Endpoints for SQL would be great thing to use to solve this problem. As all I was after was xml document to stream over HTTP. There was no business logic needed so all the .Net would be is just another layer acting as go between. Also I didn’t what to waste time on what code which wouldn’t have added any value. So I created my stored procedure to produce an XML document that I found usable by using the For XML Path. Then I started to look at h...