Urgent

[Anne]

Hello,

I am connecting to an oracle database and I am storing that information in a sql server database. What I need to do is parse the data that is in the sql server table into three other tables. This is what needs to happen if a request is not found then two tables need to be populated. If the record is a duplicate then a third table only needs to be populated. Is there an easy way to do this and how ?

Thanks in advance
Anne

[rich]

Should be pretty straight forward:

If Exists(sql to check request)
insert table1...
insert table2...
else if exists(select item,count(*) from table
group by item having count(*) > 1)
insert table3....

end

-- Hope this helps


------------
Anne at 10/9/01 4:36:19 PM

Hello,

I am connecting to an oracle database and I am storing that information in a sql server database. What I need to do is parse the data that is in the sql server table into three other tables. This is what needs to happen if a request is not found then two tables need to be populated. If the record is a duplicate then a third table only needs to be populated. Is there an easy way to do this and how ?

Thanks in advance
Anne