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’m a bit lost on this if someone can give me a hand.<BR><BR>I have a table that has:<BR><BR>PK<BR>EmployeeID<BR>ReviewDate<BR>ReviewRating<BR><BR><BR>I want to pull out the MOST RECENT review date ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results