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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 update

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-01-11 : 06:51:17
amareswari writes "how can we inner join the temp table and aggregat table ?
and update the aggregate table taking the temp data where column present then that column have to change in the aggregate table"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-11 : 06:57:05
Please post some sample data and your expected outout based on the provided sample data.

A hint is to use UPDATE command with INNER JOIN.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -