<div>
ha aram you was faster but its admirable that we posted exacly same looking code :) (no, i didnt copy-paste or something)
</div>


ha aram you was faster but its admirable that we posted exacly same looking code :) (no, i didnt copy-paste or something)

<div>
sorry guys, this is actually wanted, sorry for the confusion,<br />
<br />
&nbsp;update msm_svccalltable<br />
set &nbsp;localstartdate = localclosedate<br />
where localstartdate = '1900-01-01 00:00:00.000'<br />
<br />
i used your scripts to make this. i split the points<br />
<br />

</div>


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



<div>
<div class="content wysiwyg-content">
hello,<br />
<br />
i have a table,.<br />
<br />
msm_svccalltable<br />
<br />
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<br />
<br />
can someone write the SQL 2000 code for me please?<br />
<br />
thanks<br />

</div>
</div>


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


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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.