I'm trying to assign rows in a table to a random variable entirely in Transact SQL (This is MS SQL Server 2000, sp3). I've got it working perfectly except I can't use a variable inside my subquery ...
operand is one of the following: constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals. Constants are described ...