B b.ashish.b Sep 4, 2006 #1 How can we get the maximum value from multiple fields within the same record in SQL-Server 2000.
G Guest Sep 4, 2006 #2 How can we get the maximum value from multiple fields within the same record in SQL-Server 2000. Click to expand... You may get a better answer in one of the SQL Server newsgroups, but... Can you not just use: SELECT MAX(field1), MAX(field2) FROM tablename ?
How can we get the maximum value from multiple fields within the same record in SQL-Server 2000. Click to expand... You may get a better answer in one of the SQL Server newsgroups, but... Can you not just use: SELECT MAX(field1), MAX(field2) FROM tablename ?