Viewing 2 posts - 1 through 2 (of 2 total)
Good call. Running SQL Server 2005 but the database is in 2000 compatibility mode.
Ideas?
February 25, 2010 at 11:51 am
#1125152
Thanks for the response.
2 issues. First, I get the error: 'ROW_NUMBER' is not a recognized function name
second, I want to update the DeptSeq column to the incremented value. ...
February 25, 2010 at 11:14 am
#1125126