thanks.

Ya, we tried putting the data into a new file instead of an existing one. We found no changes!

Yes, the account that runs SQL Server Agent have access!

The file does not have a password!

There are many files existing in this site

Like: http://www.sitename.com/textfile.txt

http://www.sitename.com/htmlfile.html

http://www.sitename.com/filename.xls

So, it is required to specify the filename right.

Basically, i need to download the data in the excel into...

Can you please elaborate any one of the method, as i don't know any one of the above languages 🙁

thanks....

Tempdb size is 9.8 GB. space available is also 9.8 GB (approx)  - from enterprise manager.

But In the c drive where the server is installed tempdb.mdf size is more than 10...

Its MS SQL SERVER 2000

hey ...it took 40 mins to update....i have created clustered index on column a and primary index on column b....and the procedure is just

create procedure my_procedure as

update table1 t1

set c...

creating a clustered index on column a took 14 hrs to update arround 1.5 million rows.

The message appears when created a index on (a,b): (a has more repeating values)

"Warning!...

actually

"But still i am afraid to run the procedure as it took 17 hours to update 2000 matching records. "

i stopped executing the procedure in between!

Thanks !!!!!!!!!

creating the index...

Now that i have created index of type clustered the preformance of my procedure should increase. But still i am afraid to run the procedure as it took 17 hours...

UPDATE table2 SET c = CAST(table1.c AS

thanks!

Oracle merge inserts or updates the rows into the table2 (i.e. merge table) based on the equijoin condition (i.e. (B.f1 = A.f1))

------------------------------------------------------------ 

I have 2 tables (more than 10 million...