This should work:

SELECT     IPaddress, Username, MAC, LastSeen, DiscoveryDate, ComputerName

FROM         dbo.IPsweep_Historical ih

INNER JOIN

                          (SELECT     ComputerName, MAX(lastseen) as MaxLast

                            FROM          IPsweep_Historical

                            GROUP BY ComputerName) ml

ON ih.ComputerName = ml.ComputerName

AND ih.LastSeen = ml.MaxLast

ORDER BY...

Look at how the null values are represented in the flat file. 

You'll probably have to make the data pump a VB script which checks the value of that particular...

Played around a bit more and realized that the above will cause rounding.

Here's another way that eliminates the CASE statement and doesn't round:

select  LEFT(

            cast(DecVal as varchar(30)),

            CHARINDEX('.',cast(DecVal as...

This isn't great, but it works:

create table #tmp

(DecVal Decimal(10,6),

DecLen int)

insert into #tmp values (99.5555, 2)

insert into #tmp values (99.5555, 1)

insert into #tmp values (99.5555, 3)

select

 case DecLen

    when 1...

Excellent health care (including vision, dental and "alternative")benefits

Access to education / training (including fees paid and paid time)

Flexible schedule

And definitely, more time off.

I doubt it.

What happens if you re-run the left outer join query?  It could be a statistics / query optimization issue.  What do the two query plans look like?

Look at the where clause.  Is there a clause for the left-joined table?

like this...

select blah

from table1 t1, table2 t2

where

t1.pk *= t2.fk

and

t2.val1 = @value

If so, try this:

select blah

from table1 t1

Left outer...

Yes, this is a non-ANSI version of a left outer join.

=* would be right outer join.

Does anyone else see the irony in Steve posting this editorial within just a few days of the "Wages on the Rise" article?

That just struck me this morning.

It's not necessarily a matter of time, satz.  For me, it's a matter of picking and choosing my jobs, taking short-term contracts, taking on new tasks at my job and...

Without seeing the actual query and DDL, we can't be of much help.  A query plan would be really helpful as well.

alzdba - That re-working of the query could potentially produce different results.  Also, for the OP, it might be faster.  See this article for a discussion of this:

http://www.sqlservercentral.com/columnists/sjones/outerjointrouble.asp

Julie, that...

This is what I could find on that:

http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx

Best guess from where I'm sitting is to make sure the source file exists and that the destination directory(FileSystemObject.FolderExists&nbsp

What is the error?

Do those directories exist?

As far as including the date, you'd need the ActiveX equivalent of getdate() (which I believe is Now()), cast to a string and add...

FileSystemObject is what you want to look at.

Have a look at this:

http://www.sqldts.com/default.aspx?292