I suggest you begin/commit another transaction for CM_Error_LogWrite or use a second connection altogether. Using OSQL will cause you more problems and introduce more points of failure.

Based upon your example you are using Linked Server to access Excel. When doing this sql does not know it is Excel (this is handled by the driver) and will...

Ooops!

Just noticed this is in the DTS section and therefore assume you want to DTS to Excel.

You can either DTS direct to Excel but there are...

Can you be more specific.

Do you want Excel to update the worksheet or for sql to create the worksheet?

Alternative to using cursor using temp table but depends on volume.

create table #temp (rowid int IDENTITY(1,1),file_no varchar(6), ref_no varchar(6), container_no varchar(7)) 



insert into #temp (file_no,ref_no,container_no)...

A bit late but if you want a solution without CASE then

AND (@id = 0 or @id = UserID) 

Edited by - davidburrows on 09/24/2003...

The file will contain output from the job as a result of PRINT or SELECT FROM. A SELECT...INTO will not output to the file. Therefore the output from the snippet...

jollyguy4all,

quote:

---

select * from labels_19_jul_2003 where id not in (select id from labels_19_jun_2003)

---

I...

Sorry about that, I realized that a few minutes ago. I haven't got SQL2K so I don't know. I suggest you look on the server to locate where sql was...

The error is due to wrong or out of date include files. Replace srv.h, srvapi.h, srvconst.h, srvdbtyp.h, srvmisc.h, srvstruc.h, srvtok.h, srvtypes.h in your C++ include folder (making a copy first)...

I prefer joins but don't know if performance is better though.

SELECT t1.field1,t1.field2,t1.field3 

FROM Table1 t1 

LEFT OUTER JOIN Table2 t2 

ON t2.field1 = t1.field1 

AND...

Agree with Phillip. In cases like this I put time calculation displays in the page to see what is taking the longest. If you have tuned the query then it...

Access Memo field equates to SQL text field and allows for text greater than 255 for Access and 8000 for SQL. If you try to DTS a memo column that...

or

SELECT o.EmployeeId,f.Freight,l.Freight 

FROM (SELECT EmployeeId, 

MIN(OrderID) AS 'FirstOrderID', 

MAX(OrderID) AS 'LastOrderID' 

FROM Orders 

GROUP BY EmployeeId) o 

INNER JOIN Orders f 

ON f.EmployeeId = o.EmployeeId...

IIS 5.0 comes with Windows 2000 and .NET Framework is downloadable from Microsoft (see http://msdn.microsoft.com/netframework/downloads/howtoget.aspx )

Edited by - davidburrows on 09/22/2003 07:07:00 AM