I have written a script to search for a gather information on every PC in active directory. I used bcp to put this information to an SQL database in sql server 7.0.
What I need is a query that will take that data from one table and insert it or update it depending if it exist on the second table. I would like to create a stored procedure or a trigger that will do this. It sounds easy enough, but for some reason I just can't get it to work. Any help or example you can give would be appreciated.