Viewing 6 posts - 1 through 6 (of 6 total)
Hi,
If you want to look for information about any file extension, please visit
I saw your answer there.
If you have any concern, please email me at lamd@vmcmail.com
VMC-WD-MIS-LAMD
October 26, 2004 at 12:21 pm
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...
October 26, 2004 at 11:42 am
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,...
October 15, 2004 at 11:33 am
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...
October 15, 2004 at 11:20 am
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...
October 15, 2004 at 11:20 am
Viewing 6 posts - 1 through 6 (of 6 total)