December 10, 2004 at 6:02 am
I have 2 rows
machine location
test1 null
test1 125
test2 null
test2 12345
How can I update test1 (null) with test1 125 test2 (null) with test2 12345 etc
Thanks
December 10, 2004 at 8:00 am
If you only have one location per machine that is not null, this will work.
update T1
set location = T2.location
from yourtableowner.yourtable T1
inner join yourtableowner.yourtable T2
on T1.machine = T2.machine
and T1.location is null
and T2.location is not null
have a nice weekend
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 10, 2004 at 8:07 am
Thanks, hope you have a good weekend too
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply