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 |
Steve2106
Posting Yak Master
183 Posts |
Posted - 2015-03-06 : 07:01:48
|
Hi There,I have a record that I update but after updating this record I need to set all the records that are related to the same groupid field the same record details. I have managed to do this with an update statement.I am now struggling with the next part.For all the updated records with the same groupid I need to add a record to another table. I am not sure how I do this as I have just used Update and set, not a for loop to get the individual unique Id and then use that in the insert statement.Can anyone point me in the right direction?I hope that all makes sense.Thanks for any help.Best Regards,Always Learning. |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2015-03-06 : 07:16:36
|
[CODE]-- create table variable to hold the updated recordsdeclare @UpdatedTeams table (TeamID int, TeamName varchar(100), CaptainID int)--Do your UPDATE hereUPDATE TeamSET TEAM_NAME = REPLACE( TEAM_NAME , ' New', '')OUTPUT inserted.* INTO @UpdatedTeamsWHERE TeamID=1--Now the table variable @UpdatedTeams holds the updated records--Then use that table variable to insert into another table as per your requirementINSERT INTO AnotherTableSELECT * FROM @UpdatedTeams[/CODE]--Chandu |
|
|
Steve2106
Posting Yak Master
183 Posts |
Posted - 2015-03-07 : 18:32:33
|
Hi Chandu,Thanks for the reply.I cannot get it to work though and I think I should give you my table structure.Tbl_WorkSheet TaskId int SetNum int GroupNum int DateCompleted datetime Approver nvarchar(50)My update statement is:UPDATE Tbl_WorkSheet SET GroupNum = 7, DateCompleted = '07-03-2015', Approver = 'Dave Newey' WHERE Tbl_WorkSheet.SetNum = 1Taking this into account how do I create a table variable and fill that table with all the records that were updated including the taskid of each record updated.Thanks for your help.Best Regards,Always Learning. |
|
|
|
|
|