Take a look at the "Except" operator in Books Online. It's a pretty slick way to compare the contents of two tables.

jcrawf02 (4/17/2009)

---

GSquared (4/16/2009)

---

Nah. One...

Currently, I don't see a need for it with what I'm doing.

On the other hand, I'm almost always interested in trying these kinds of things out. Given the chance...

It'll need to look something like this:

-- Build and populate test tables

create table #Objects (

ID int identity primary key);

insert into #Objects

default values;

insert into #Objects

default values;

create table #Components (

ID int identity...

Steve Jones - Editor (4/16/2009)

---

Gus has a great point. You can't expect anyone else to challenge a legal issue for you.

However if you want to challenge it, what's the likelihood...

When you run the BAT file from the command prompt, does it work?

Also, why would you want an SQL script to raise an alert window? Wouldn't the alert window...

That sounds like a bug to me. I'd definitely contact Microsoft about it.

Not really. Foreign keys references one other table.

You won't have to iterate through them. Run the test case I gave you a few posts back, you'll see how it works.

What this kind of script function does...

Finally got a chance to speed test these things on a different computer.

Concat8kTest version took 1982 milliseconds total, 1328 CPU.

XML cross-apply took 1793 total, 1594 CPU.

Subsequent runs cut 8k down...

My wife gave me "Shawn of the Dead" and "Hot Fuzz" on DVD for Christmas. Very, very funny movies!

Personally, I'd do that kind of pivoting in the application, not the database. You could do that in Reporting Services, or Crystal Reports, or Excel, very easily. In...

The database design sounds okay for that kind of thing. If the components and objects tables are similar enough, it might be better to merge them, but it's not...

John Bradford (4/15/2009)

---

All of the reliability concerns are valid; however my main concern is with the way the legal system views data ownership.

It is my understanding that you...

It's not as much a collation thing as it is a design issue. You'll need to make sure the appropriate tables hold nvarchar instead of varchar, data types, and...