Solved

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

Posted on 2004-09-23
5
269 Views
Last Modified: 2012-06-21
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
Comment
Question by:acetate
  • 2
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
ram2098 earned 300 total points
ID: 12131329
update msm_svccalltable
set  localclosedate = localstartdate
where localclosedate <> '1900-01-01 00:00:00.000'
0
 
LVL 4

Assisted Solution

by:eclipse2k
eclipse2k earned 200 total points
ID: 12131335
update msm_svccalltable
set localclosedate = localstartdate
where localclosedate <> '1900-01-01 00:00:00.000'

i guess?
0
 
LVL 4

Expert Comment

by:eclipse2k
ID: 12131340
ha aram you was faster but its admirable that we posted exacly same looking code :) (no, i didnt copy-paste or something)
0
 
LVL 11

Expert Comment

by:ram2098
ID: 12131370
I know ..But funny :)
0
 

Author Comment

by:acetate
ID: 12131387
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

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Server connect issues 4 37
Linked Server - SP with Param to VIew 7 19
SQL works but want to get the XML node data separately 11 25
SQL Distinct Question 3 11
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question