I'd have to agree with Piers,

This looks like it could be useful under certain circumstances and for that reason the article is worthwhile.

In most cases though, I would not...

I'm not recommending it to anyone - as it appears to do more work than either of the other...

The except and intercept clauses are great if you want to compare 2 data sets but for whatever reason cannot use the primary keys. Or you need to compare 2...

If you wanted to use several unions like that then I think it would be wise to wrap sets together.

if you had 3 tables, each with identicle columns (just different...

Except and Intersect - Fantastic, something I didn't know had been added for 2005

I've used (to great effect i might add) the extended UNION (INTERSECT and MINUS) features which have...

Seems to be happening on other articles...

Nice article, looks very similar to getting a list of values from a table and looping through them.

This is one of the things which I don't like about SSIS, sometimes...

magarity kerns (8/13/2008)

---

I love the way the technical spec was written and finished first and then they came to the DBA to ask how/if it can be done. Who...

David,

If you're using reporting services and users have web access to run reports then reports can easily be integrated into Excel (not sure about Excel 2000) using a web query.

This...

I think this calls for Monty Pythons The Four Yorkshiremen skit:

http://www.phespirit.info/montypython/four_yorkshiremen.htm

Sorin Petcu (2/1/2008)

---

I 've used the Migration Wizard for my DTS packages and it was worked well. But, my new server and database server have different names from the old...

What tempted you...

not part...

This little snippet might help

select * into #temp1

from [add your source objects here]

where 1=2

select * from tempdb.dbo.syscolumns

where id = (select id from tempdb.dbo.sysobjects where name like '#temp1%')

drop...

declare @HasAnyRows int

DECLARE @COL VARCHAR(50)

DECLARE @Section int

SELECT @Section = 1

SELECT @HasAnyRows = 0

IF @HasAnyRows <= 0 and @section = 1

SELECT @COL =...