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 ...
I have a stored procedure that needs to select some data into a table variable, but I am having trouble because I need a dynamic where clause and SQL Server 2000 does not seem to like using an EXEC() ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback