You can always add an identity column and use that as uniqueidentifier to delete the tuples, then drop the column.

Create perm table (exact match)

insert ValidData into newtable

drop old table

rename new table

rebuild...

Also there are easier ways to clean out data.

If you want, we can check for another solution, but we need the table definition (with keys) and what determines the row...

That's certainly one reason.

I've never actually tried this but I think it can work.  Thanks for letting me know.

You can do this to correct the problem :

(

dbo.flightinfo.end_date = b.end_date

OR

dbo.flightinfo.end_date IS...

A body excavation specialist?

Here's a suggestion : start the profiler, then start doing your thing with EM.

Once you're done. go back to profiler and see how it's done with scripts.

In the mean time you can check out this fact

where null = null doesn't work

you need something like where Col1 IS NULL AND Col2 IS NULL

I need some sample data and the required output to be sure to understand what you want.

Just a matter of logic.

Of course, if you get many correct answers on questions like this one, you might want to go see a specialist

The only use I could see for that is to keep some sort of history.  This order went out before that order, then that order...

But that would be usefull only...

I've started my business.  I'll be needing help in the coming months.  I'll drop you a line when that happens .

I can get this one right too :

She kills her sister because she expects that man to be at her funeral too!

One other thing to consider about the index scan...

I'd much rather have the server scan 1M rows of 50 Bytes each VS scanning 1M row or 2 K each.  Scan...

My opinion : XML = Bloatware.  Why parse 200 MB when I can parse 2 MB for the same data?  I understand the point when working with heterogenous systems, or...

Cool, we do we start working together (in our own business, much more enjoyable than working for someone!!).

Ya, thanks for pointing that function out... I don't use it often enough!