Simple SQL Server 2008 Spatial Search - Part 1

A scenario familiar to many web developers is the requirement to provide a location search to your client's users. The user enters their address and/or zip code, and is shown the 5 closest locations that they can visit. Add information from your Inventory system, and you can tell the user which locations have the item they are looking for in stock.