how can one solve this

Question

Hi,

I have some data as follows:

col-1                 col-2        col-3

000000012 NULL 487851
000000012 597619 679716

I have millons of such rows with many ID's in col-1 and with different account, Here the second col must have 597619

how do i solve this without update, i need to do the same for many rows

Help!

Thanks,

Ankitha

Answer 1

Are you asking how to make all records have col-2 = 597619?

---

Chuck Pedretti | Magenic – North Region | magenic.com

Answer 2

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Learn how to follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats. Code should be in Standard SQL as much as possible and not local dialect.

This is minimal polite behavior on SQL forums. ousdid not even tell us the naem of the table!!

---

--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL

Answer 3

>how do i solve this without update, i need to do the same for many rows

Is this a spam?

---

Kalman Toth SQL 2008 GRAND SLAM
Paperback: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012