Updating reference tables
For more information, see WITH common_table_expression (Transact-SQL). For information about table hints, see Table Hints (Transact-SQL).TOP ( ) Specifies one or more table hints that are allowed for a target table. @ Note When referencing the Unicode character data types nchar, nvarchar, and ntext, 'expression' should be prefixed with the capital letter 'N'.
In mine case I had similar problem that formula broke each time when I opend Excel.As soon as you open Data Saved then will realize that the data does not exist anymore and lose it.The work around for this is to make sure that you update the links in the formula. Trust Center Settings-Trusted Locations and adding the folder containing I was able to make the problem stop happening.For more information about predicates and search conditions, see Search Condition (Transact-SQL). For more information, see SET ANSI_PADDING (Transact-SQL).
CURRENT OF Specifies that the update is performed at the current position of the specified cursor. Modifying a text, ntext, or image column with UPDATE initializes the column, assigns a valid text pointer to it, and allocates at least one data page, unless the column is being updated with NULL.Compound assignment operator: = Add and assign -= Subtract and assign *= Multiply and assign /= Divide and assign %= Modulo and assign &= Bitwise AND and assign ^= Bitwise XOR and assign |= Bitwise OR and assign Returns updated data or expressions based on it as part of the UPDATE operation.