This will allow us to see how much benefit if any we get from having indexes on a column. We've got lots of great SQL Server experts to answer whatever question you can come up with. In this case the SQL Server 2005 understands that when talking just about Column1, it should be refered to the table variable we are updating.
Reset(); // Iterate through rows while not Project. If you refere to the T-SQL reference of SQL Server 2005, you will see that you can't alias the name of the table you are updating.I was thinking quite a bit on that and it will be nice if you can do that.Also I couldn't think of any conflict that it can have with the rest of the T-SQL syntax.Anyway, if you know any solution to do update like this in one query, I will be thankful if you shear it.
Unlike the majority of the other data types in SQL Server, you cannot use a table variable as an input or an output parameter.