Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-03 : 07:52:28
|
| Sultan writes "I have a table with two rows in it. Row1 has default values. Row2 has calculated values. I want to create a single row out of these two rows using the criteria that if the value in the first row is greater than the second, I want the value in the single row to be the larger value. ROW1 {3, 6, 8, 1}ROW2 {4, 5, 8, 4}SINGLEROW {4, 6, 8, 4}How do I go about doing this." |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-08-03 : 07:56:00
|
| USE MAX.SELECT Max(col1) as Col1, MAX(Col2) as Col2, MAX(Col3) as Col3, Max(Col4) as Col4FROM MyTableDuane. |
 |
|
|
|
|
|
Creating a single row out of two (urgent help needed)