For more information, see Specifies one or more table hints that are allowed for a target table. If 'N' is not specified, SQL Server converts the string to the code page that corresponds to the default collation of the database or column.
The OUTPUT clause is not supported in any DML statements that target remote tables or views. If the object being updated is the same as the object in the FROM clause and there is only one reference to the object in the FROM clause, an object alias may or may not be specified. Table2 (d1 int PRIMARY KEY NOT NULL, d2 int NOT NULL); GO INSERT INTO dbo. Table2 VALUES (1, 20), (2, 30); GO DECLARE abc CURSOR LOCAL FOR SELECT c1, c2 FROM dbo. Table1; GO Support for use of the READUNCOMMITTED and NOLOCK hints in the FROM clause that apply to the target table of an UPDATE or DELETE statement will be removed in a future version of SQL Server.
The subquery must return exactly one row that includes all the columns listed.
The column values returned by the subquery are assigned to the columns in the column list in order. WHERE search_condition Chooses which rows to update in the database table.
Aaron, there appears to be nothing in the data to indicate which region the dates belong to, and I think I used the word possibly, so I would expect that Krondorian would take a more informed view on that.
There are also problems with low numbered days and months which would be valid either way...