[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] SQR Help


Hi Melissa,

For this kind of application (volume repetitive comparisons) I like to
use arrays.  To do this in your case I would load the values of the
column you want to compare and the key column(s) (from the smaller table
if there is a significant difference in size) into an array.  Then get a
column value from the other table and rip through the array looking for
a match.  If you find one before you get to the end, do the delete.  If
not, go to the next record's value.

Richard Knapp
AITS - Data Warehouse Group
University of Missouri
615 Locust Street #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu
 
-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Melissa Teator
Sent: Wednesday, January 10, 2007 12:16 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR Help

I am new to SQR and am trying to write a program that looks at tables 
on 2 different schemas.  Then using a column name determines if any 
rows are duplicates.  If it is a duplicate then deletes the row in one 
of the schemas.  Any idea on the best way to approach this?  I will be 
reading in table names and column names from a file.  Any help is 
appreciated!  Thanks! -M 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users