Insert Return Value into Column.

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 2000 Forums

Transact-SQL (2000)

Insert Return Value into Column.

Author

Topic

davidshq
Posting Yak Master

119 Posts

Posted - 2005-12-03 : 12:18:50

If I do a:
select mID from table WHERE gID=5
How do I then insert the resulting set into a table to be saved?
David.

- http://www.gamesecretary.com/
- http://www.thehungersite.com/
- http://www.grid.org/

davidshq
Posting Yak Master

119 Posts

Posted - 2005-12-03 : 12:33:17

I figured it out:
update game set Popularity =
(select avg(Popularity) from GamePopularity Where gID=2)
Where ID=2

- http://www.gamesecretary.com/
- http://www.thehungersite.com/
- http://www.grid.org/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-05 : 00:45:09

http://sqlteam.com/forums/topic.asp?TOPIC_ID=58545

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources