I have a project in which I would like to display data from SQL Server 2005 onto a website. I am trying to start off small with simply displaying tables or views. My end goal is to learn how to display data based on variables. I am trying to come up with a way to display Loyalty Point information from a Loyalty Program. I have just started this project and have little knowledge of the matter. I am assuming it will run off of an .ASP page.
Can anyone point me in the direction of the basic steps I will need to take? Can I do this all in SQL Server 2005?
Any information is well appreciated,