• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

is not equalk to, then set field to equal another field

hello,

i have a table,.

msm_svccalltable

i want to populate all fields that are not equal to '1900-01-01 00:00:00.000' in field localclosedate with the data from field localstartdate

can someone write the SQL 2000 code for me please?

thanks
0
acetate
Asked:
acetate
  • 2
  • 2
2 Solutions
 
ram2098Commented:
update msm_svccalltable
set  localclosedate = localstartdate
where localclosedate <> '1900-01-01 00:00:00.000'
0
 
eclipse2kCommented:
update msm_svccalltable
set localclosedate = localstartdate
where localclosedate <> '1900-01-01 00:00:00.000'

i guess?
0
 
eclipse2kCommented:
ha aram you was faster but its admirable that we posted exacly same looking code :) (no, i didnt copy-paste or something)
0
 
ram2098Commented:
I know ..But funny :)
0
 
acetateAuthor Commented:
sorry guys, this is actually wanted, sorry for the confusion,

 update msm_svccalltable
set  localstartdate = localclosedate
where localstartdate = '1900-01-01 00:00:00.000'

i used your scripts to make this. i split the points

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now