Awk, Perl, Ruby are probably better than sed, as could some VBScript programming (hint: open the file as a stream, and replace LF with CRLF, or whatever...). sed has some...

Not if it's written as:

SELECT a.name, b.name

FROM tablea As a

LEFT JOIN tableb As b

ON a.name = b.name

WHERE b.name IS NULL

-- Joe the new hire who doesn't...

or, simply:

select a.*, b.id

from a left outer join b on a.id = b.id

where (b.id 8 or b.id is null)

It's more a matter of knowing how to deal with NULLs...

For SS2000, there are a couple of TSQL scripts to run (I think I found them on SQLDTS.com, or possibly msdn) that set things up to call COM/OLE objects from...

OpenACS has a US zipcode file from about 1999 in it, sourced from the US Census' "TIGER" data. This is probably the most recent free dataset out there. If you...

Well, check out these urls: http://www.sqldts.com/default.aspx?246 and http://www.sqldts.com/default.aspx?218.

What I would do is set up a VBScript task, that opens up the file to look...

a)

select ownerid, count(ownerid) from

(select distinct ownerid, ownerfname, ownerlname

from house)

group by ownerid

having count(ownerid) > 1

b)

##I think this is close:

## the intent...

Even better, have Excel get the data.

If you didn't install MS Query with Excel, then install it.

Then, do Data->Get External Data. You can get the data from an ODBC...

at this url, http://www.sqldts.com/default.aspx?246, is the basics for making a DTS script where the task execution order is manipulated programmatically.

I would use an ActiveX step, and do it...

More DTS fun stuff...

You could easily use a VBScript action to create your ODBC connections, store them in a DTS Global Variable, and then assign them as needed to whichever...

The DTS Package Designer runs from the context of the computer it's running on. If running DTS designer on Server A, you can deploy it to Server B, but if...

One way to do it is before doing the datapump task to load data to the workbook, set up an ActiveScript task.

Then, do some VBScript to

open Excel

open the workbook

select...

Actually, with doing string manipulations on the NAME field and comparing, you're gonna be doing table scans anyways for most operations.

It all depends on what you're most comfortable with. I...

Hmm... but that does assume that OrderID is continuous. I know that one of Joe Celko's books ("SQL for Smarties", etc. - awesome books) does talk about this very thing.

The...

Look into using an ActiveScript step/task to do some of the evaluation that your VB program is instead doing. Then you want to set the step's evaluation from "Success" to...