Hi Niki,

Did as suggested.  Now I am getting a little further on the import only to run into the problem listed below:

Error at Source for Row number 37632. Errors encountered...

Hi,

Thx for the help again. But, my boss wants a sql solution.  And in the previous case, since there are multiple start and end dates and we can't exactly predict...

Hi Remi,

Finally got it.  I re-wrote to use sub-queries.  Here's a sample :

select distinct prod_id

from prod_cities a

where a.city_id in (207,208)

and exists (select city_id from prod_cities

            where city_id = 207

           ...

Hi,

Ran into a glitch. When I included the start_date, had to include the city_id too and then then count() part is no longer valid.  So, I am still searching for...

never mind, I think if I put a max(start_date) to it, it should do the trick.  Thx anyway.  U guys are great.

Vis.

Hi,

Thx for the tip.  Just to complicate it a little further, if each product can have multiple start and end dates in each city and I keyed in the start...

Hi All,

Thx a lot for the feedback.  Just one more question for Jim.  From what I have seen, mostly, all our applications use SHA-1 and this was just one of...

Thx to all of you for the varied but extremely informative responses.  I just have one question to Jonespm on replication.  When the data db came back up, what was...