You may like to keep the new tables in a completely separate database to allay management concerns relating to upgrades of the JDE databases. This would seem to be...

First thing: do you really need

select * ...

or can you just select the fields you need?

Next thing to do is replace the subquery with a join and replace the...

I've got an idea that I've read somewhere that EM returns the results of such a query in 'batch' mode - allowing you to see subsets of results as they...

So why not create a table in Oracle that contains UPC codes from SQL Server? This should do away with all that text file business.

Part 1: ensure that the...

Ken, I'm not sure that I can picture the sequence of events you are considering. Are you saying that you would analyse the existing SQL Server data and then...

Hmmm - tough one. Is there some way that you can start maintaining a "Transfer to SQL Server?" flag against the Oracle data. You will know from the...

Rather than using straight DTS, have you thought about adding the Oracle server as a 'linked server' and using straight T-SQL to accomplish the data transfer?

What is the relationship between tables a and b - is it on event?

So, in English terms, table a is an 'Account Events' table and table b is an 'Event...

"Also you may want to consider an extra field on the row to say completed."

Expanding on Eric's idea, why not create an extra calculated field on the table = number...

Try unregistering the DLL, type:

regsvr32 '[enter full dll file path and name]' /u

from a DOS prompt and then reboot and try deleting it again.

Phil

I use a Cisco VPN connection over the internet fairly frequently and have no problems with EM/QA over that (except that it trashes my local network connections).

Phil

Yuk. I'm assuming that you have tried (or perhaps you do not want to try!) performing a SELECT of all the fields into local variables and then checking them...

This sounds a bit suspect to me. Can you provide a bit more detail about what you are going to do with the number? If I was filling...

If you are able to reproduce this error in Query Analyser, the message text will be more helpful (the meaningless variable placeholders will be replaced by the actual constraint and...

The alternative to

where field like '%word' is

where RIGHT(field,4) = 'word'

LEFT(field,4) gets the first four characters of field, not the final four.

Regards

Phil