Friday, January 25, 2013 8:53 PM
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
Friday, January 25, 2013 9:01 PM
Are you asking how to make all records have col-2 = 597619?
Chuck Pedretti | Magenic – North Region | magenic.com
Friday, January 25, 2013 9:09 PM
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
Friday, January 25, 2013 9:29 PMModerator
>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