Dear All,

My Team has been asked to build a application which helps in routing of transport in the best possible route for customers.

i.e to say i have a truck which should deliver goods for four customers at various places this application should determine the best possible route to take.

I understand in SQL Server 2008 we can use spatial features. Can anyone point me to any information based on which i can build this and algorithms for the same.

SQLServerCentral.com just posted part 2 of "Investigating the new Spatial Types in SQL Server 2008".  I haven't read it, but this series may be of use to you.