?
Solved

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

Posted on 2004-09-23
5
Medium Priority
?
284 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
ram2098 earned 1200 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 800 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

800 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