Store Procedures

[Tarzan613]

Hi All,

I need to create two table with records(it's not a problem)
, but i would like to set up a stored procedure in order to take weekly iformation from on table and insert (or update) in another..
Stored Procedure has to work automaticaly (without me running it..)
Thank you very much in advance..

 

[harmmeijer]

Considering you have the sql statements you have no propblem creating the sproc.
in management ==> sql server agent ==> jobs
You can add a job and run a sql statement like:
use myDatabaseWhereTheSprocIs
exec mySproc