Hugo,

I stand corrected. I was shooting from the hip without doing enough research...

Reverse the values of 0 and 1 for the condition and else in the case statement and #3 is correct...

I'm sure I wasn't the first to notice this but I...

Did you try dropping and re-creating the pk index you are selecting on?

Just a thought...

Robert

Sorry I'm so late on this thread....

I get around the rights issue by creating a batch file on a local drive on that executes an FTP script.  The batch file is...

If you are using IIF to fill an empty value in a select statement:

select

   newField =

   case

      when isnull( origField, space(0) ) = space(0)  -- this field...

Don't even ask how I did that...  I'll try again...

If I'm following you correctly... why not try this?

select

     t1.*

from

     table1 t1, table2...

SELECT * FROM Table1 where Val IN ( Select v FROM Table2 )

-or-

SELECT * FROM Table1 where ( SELECT COUNT(1) FROM Table2 WHERE v = Table1.Val ) != 0

If I'm following you...

SELECT * FROM Table1 where Val IN ( Select v FROM Table2 )

-or-

SELECT * FROM Table1 where ( SELECT COUNT(1) FROM Table2 WHERE v = Table1.Val ) != 0

If I'm following you...

SELECT * FROM Table1 where Val IN ( Select v FROM Table2 )

-or-

SELECT * FROM Table1 where ( SELECT COUNT(1) FROM Table2 WHERE v = Table1.Val ) != 0

If I'm following you...

You might try dropping your index, run the insert, and re-create the index.

Robert

RE:

... You may want some way to verify that the file is complete before you try to load it. Thing is, that if you dir it or similar, a file...

sorry about that last aborted post...

continues...

begin

     select *

     FROM

          northwind.dbo.employees

     WHERE   

          employeeID = @id

end

You might try the following... I believe the error you are getting occurs when the query is parsed...

DECLARE @Name varchar(30), @Firstname varchar(30), @ID int

SET @Name = 'y' -- 'y' =...

Depending on your bandwidth needs, this option might work. 

Install a single fiber gigabit nic in your server and connect it to a gigabit switch with 10/100 ports.  Connect the...