Hi friend

I have a question of 2 parts
I have to insert new entries from a file in a table once every month
Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of the fiields an not all the fields for instans I have the following file struktue

name;age;adress;compnay

But I want only to insert name and compnay in the table.

Thanks a lot for your help.

Re: shceduling a sql query 80 80

You can create job.
Job can be scheduled as per your need.
Which MS SQL version are you using?

Re: shceduling a sql query 80 80

Hi again

It is 2005 version.

Thanks

Re: shceduling a sql query 80 80

Thanks, I have created the job .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.