i am not familiar with ASP or PHP writing, i am database admin only capable to do simple code changes.
Trying to find any usable/workable copy/paste sample of graph/chart for visulazation of simple two column MSSQL table.
Free ones: Open flash chart, php-gnuplot, pchart, xml/swf charts, Visualize, igrapher, awesomeJS
Semi commercial: rgraph, amcharts, Google charts, jpgraph,
and many, many more...
For graphing, the easiest way is to use the Google Chart Tools. A good introduction is here: Quick-Start Guide for Google Charts API
For accesses the data in the database, it depends on how your server is set up as to what is easiest. I would use PHP and install it from Microsoft's PHP on Windows page. Make sure you use the PHP SqlSrv driver for PHP. Brian Swann's Accessing SQL Server Databases with PHP looks like a good place to start.
Alternatively, use ASP.NET, but I can't help you. Intro to SQL Server with ASP.NET looks like a reasonable place to start though.
If it's a one-off graph you are creating, then you could always export the data to CSV via the SQL Server admin tools and then graph in Excel.