Help writing update query and timed execution

Part 1
I have table 1: dbo.OpportunityBase
I have table 2: dbo.CompanyPipeline - this is an exact copy of table 1

I want a query that updates table 2 with all the data in table 1,
overwriting everything in it (table 2).

Part 2
I'd like to be able to get this query to run automatically at a specific
time every day.

The reason for this is I need to show how the values in the table have
changed each day, therefore I will write a report querying the data from both
tables, hopefully giving me the difference between the two.

Anyone have any ideas on this?

Thanks in advance!

"stacko111" wrote in message

> Part 1
> I have table 1: dbo.OpportunityBase
> I have table 2: dbo.CompanyPipeline - this is an exact copy of table 1
>
> I want a query that updates table 2 with all the data in table 1,

Well, first of all, if dbo.CompanyPipeline is an *exact copy* of
dbo.OpportunityBase, there's nothing to update!

So, shall we start over with practical premises?

> Part 2
> I'd like to be able to get this query to run automatically at a specific
> time every day.

That's what the SQL Agent is for.




--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas