I've been carefully building the web-site using VS.NET & SQL-Server 8.0.  I down-loaded the
database, and loaded it to SQL-Server.  The first web page I built that hits the database is New User registration page described at
the bottom of page 177.

The Page_Load event populates a drop-down combo box of state codes, from the Accounts_StateCodes table.  The table has 18 rows.  The
stored procedure returns 18 rows, but I get 9 states twice (Alaska twise, etc.).

I ran the proc within SQL Enterprise and got the same results, and the same results when I run the raw SQL within SQL Analyzer. 
Everything points to SQL-Server.

I can get 18 different states if I remove the Order By clause, but I really want them sorted.  I don't have this problem with other
databases I've built, just the ThePhile database.

Has anyone else encountered the same?  Is there a solution?  Thanks

I see now where I'm getting exactly what's in the table.  I should have 
looked more carefully to see there are 9 state rows, listed twice.  I just 
assumed the table was normalized.  Sorry to waste everybody's time.