Search results for query: *

I am having a problem using DTS to import data from an oracle database to sql. It does work when you import to MSAccess, then to sql but not directly. I am getting the following error (I can preview the first 100 records and it works, however after it deletes the table and goes to reload it...

I need help in how to only show the last record that meets criteria. I have a transactional table that houses all activity that occurs for our I/S work orders. I am pulling the w.o#, sequence, date/time and person assigned from one table. I only want to see the last record (either by sequence...

I need help adding a join statement to a query I wrote to find duplicate values in one table. here is what I have thus far: select employeenum, count(*) from employees group by employeenum having count(*)>1 Now I need to add a second table which will give me the employee names associated with...

we are having numerous problems installing sp4 on sql7 we are now getting a ums.dll error. several errors also occurred when it was trying to read the sqlserver.exe also. has anyone else experienced these problems and were able to resolve them?

I need help in combining two sql queries I have written. One combines data from two tables in one database, one combines data from two databases on the same server. select * from visit join visitapptlist on visit.visit_id = visitapptlist.visit_id Select * from psmprod.dbo.casemain...