dcwhitson (1/12/2012)
They were added to the new table in the new database after it was scripted. That's where I said I re-built the database manually two times, no scripting, but actually going through and creating each column (including the city and state columns), type etc.
But the table that you scripted for me (which I assume is the actual, latest, real table that you are using) doesn't have them. Was that the new table in the new database? If so, the columns aren't there. If it wasn't, please post the CREATE TABLE statement for the actual, real shops table that you are running that query against
I am in the process of starting a new project in web developer and see how far I can get so I can figure out where the hitch is.
No, don't. There's a logical explanation here, trashing and restarting could just waste time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability