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 - 2001-09-18 : 22:11:12
|
| Rajesh writes "I have one table temp1 having fields date, value.Table temp1(date) is having data from 1/09/01 - 30/09/01.It means temp1 is having unique data of each date of month.Their is another table temp2 ahving fields date, value. temp2 is having detail data of each date. It means temp2 is having mutiple records for same date.My question is : I want to update table temp1(value) from temp2.Means group the data from temp2 by date and update table temp1(value) with the group result from temp2 according to date. I want all this with single query without using cursor.Rajesh" |
|
|
|
|
|
Update the table