Hi,

If you want to look for information about any file extension, please visit

http://filext.com/

I saw your answer there.

If you have any concern, please email me at lamd@vmcmail.com

VMC-WD-MIS-LAMD

You can automate this process by setting up a job with two steps:

Step1: Run a stored procedure to execute the query and save the result in a table, said tbl_Results

Step2:...

Hi,

You can use the script below, I already tested and it certainly worked :

SELECT J.Job_ID, J.J_Open_Date, P.VendName  FROM Job_Tracking_Table J,

          OPENDATASOURCE('SQLOLEDB', 'Data Source=SQL2_server;User ID=UserName ;Password=UserPassword').HFC.dbo.PM200 P

WHERE J.J_Vendor_ID=P.VendorID

You should run...

Hi,

I am sorry to post my answer accidentally before I am done:

(Continued)

     . delete the temporary table

All of the 4 steps above can be in one stored procedure.

If you want,...

Hi,

You can solve the problem as:

-Write a stored procedure to :

      .copy the table you want to export to another table

      .look thru each field of the table and...

Hi,

You can solve the problem as:

-Write a stored procedure to :

      .copy the table you want to export to another table

      .look thru each field of the table and...