If the entire record being displayed is duplicated then use SELECT DISTINCT. The distinct keyword will elimnate duplicates. If the entire row is not duplicated you will have to find...

Let me make sure here but the table owner is eservices or is it the name of the database. It is always considered an unwise idea to have any object...

Sorry can't remember what I was smoking in the last thread but after studying this again I believe this should do it.

SELECT DISTINCT

a.call_id,

a.call_status_value,

dateadd(second, a.status_time_stamp,'1/1/1970 12:00:00 pm') as...

I forget which one but I believe one of the sort orders in SQL (binary I believe but not 100% sure) will cause SQL to behave in the ordering respect...

Sorry you define the distributor for the publisher from the publisher not the distributor. When you setup publications it asks you to define a distributor or use the publisher as...

sp_helpindex [ @objname = ] 'name'

for local tables, and the following for remote linked server tables is helpfull

sp_indexes [ @table_server = ] 'table_server'

[ , [@table_name...

Oracle I believe is also case sensative by default which I believe plays a part in why nulls are last, but I forget and don't have a server in front...

1) DTS does allow you to set the table, even if it does not exist you can type in your own name.

2) Cannot remember offhand but there is an option...

I do agree with Andy that should be just fine. However be carefull as this may have some extended message (usually doesn't) taht returns in addition to this error. If...

When you say procedures do you mean like stored procedures or do you mean taking proccesses developed in Oracle and creating a DTS package to encompass as a whole?

"Don't roll...

Here you go, all you ever wanted to know about the whole process for both 7 and 2K http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071.

"Don't roll your eyes at me. I will tape them in place."...

You say you mapped the old name to the new instance in the registry. Exactly how was this done. The old name to the TCP/IP address or based DNS address...

It shouldn't but I always test just to be sure of the unexpected.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not sure of anything with this kind of background. Pretty much all I have seen is theories behind the theories on the web. What are you trying to find exactly...

Maybe I fell asleep somewhere but what is ETL?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)