for each/move next - SQL Server Forums

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)

for each/move next

Author

Topic

getfar
Starting Member

15 Posts

Posted - 2005-11-24 : 09:46:36

How can i read (and update) row by row in a table.
Can i use
declare @v rows
declare @t table
for each @v in @t
................

?
Thanks a lot

Antonio
Posting Yak Master

168 Posts

Posted - 2005-11-24 : 09:47:55

Use the UPDATE statment?!!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-24 : 09:49:06

Cant you use Update statement?
If not give more details

Madhivanan

Failing to plan is Planning to fail

getfar
Starting Member

15 Posts

Posted - 2005-11-24 : 10:02:11

I must trasform a table

from
name surname stip
Mark green 10
Mark green 15
to
name surname stip1 stip2
mark green 10 15

How can i make this operation?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-11-24 : 20:31:06

refer to [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210[/url] on Combine values from rows into a column

-----------------
[KH]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-25 : 00:11:47

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources