Recent content by boopers

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...

You are GREAT!!!!! Thank you sooooo much. You saved me from my headache. I couldn't even think how to add the extra fields anymore. thanks again!

swampboogie- the employeenum is not housed in the badges table, it is in the employees table. the only thing they have in common is that ID field, which is meaningless, except for creating the join. basically, the dups are in employees, but it contains no useful information. badges has the...

I am sorry, I am not trying to be a pain, but I still can't get the right result set. I need the results to have both the employeenum that is duplicated, and any names associated with it in the badges table. everytime I try to add that value to the select statement, it doesn't like it. Any ideas?

Your close...here is an example employees table ID! EmployeeNum 1 ! 2 2 ! 2 badges table ID! LastName! FirstName! 1 ! Smith ! John! 2 ! Jones ! Karen! The results I want would show that I have two EmployeeNum's that are duplicate (2) and what names in the badges table are...

Neither of these methods work. Maybe I should back up a little and give more detail. I have one table which contains just the employee number and a separate ID that can be used to link to the other table. Employees table ID EmployeeNum Badges table ID Lastname firstname The duplicates are in...

this isn't working. Here is what I wrote: select lastname, firstname from badges inner join employees on badges.id = employees.id group by employees.employeenum having count(*)>1 I get an error message that the lastname and firstname field are invalid in the select statement as they are not a...

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...

This may not be unusual depending on how your application was designed. I also have an app whose logs grow to several gigs over a week's time, and the dbase isn't nearly as large. I make sure I restart everything at least once a week to keep the size down. Also, make sure on your maintenance...

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?

SQLSister-Thank you!!! That worked perfectly. I wasn't sure if I could use multiple joins if I was also crossing databases. Not something I usually have to do. Thanks everyone! I just joined this forum, it's great!!

toper0303- when you say the first one is the new method, are you talking about the syntax on my join? I wrote the second one in the suggested format when combining data from two databases that are on the same server. Meangreen-the UNION operator doesn't work, unless you have the same type of...

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...