Importing more data

27/09/16

Permalink 02:40:52 pm, by Greg, 54 words, 51 views   English (CA)
Categories: Tasks; Mins. worked: 0

Importing more data

Importing the CGWP records that have matching CVWM rows produces about 10,600 results.
Of those, 173 seem to be duplicates.
We need someone to go through them and weed out dupes.
This is the sql to get those records:

select * from transfer ou
where (select count(*) from transfer inr
where inr.cwgc_id = ou.cwgc_id) > 1

Pingbacks:

No Pingbacks for this post yet...

CGWP

Reports

XML Feeds