Update multiple rows

[jgurgen]

i wanna update rows with numbers greater than 5 to have the same closingdate as their openingdate

would it be

update table set closingdate=openingdate where num>5

now these records all have different openingdates so will they all be updated with the correct closingdate?

 

[SQLDenis]

yes
si
da
ja
natuurlijk
oui
hai
Dau zue

should I go on?


Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[ca8msm]

Yes, but if your not sure about it create a temporary table, insert some temp data and try it there first.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[AlexCuse]

Do you mean numbers in a column greater than 5 or some kind of count greater than 5?

Make sure to try this on a temp table.

Ignorance of certain subjects is a great part of wisdom