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!

It's always bullet proof when you query the system tables to find information (unless an object is named : ";--drop table dbo.Users").

Anyhow, I'd strongly suggest you read articles on sql injection. ...

Never seen or heard of that problem.  I don't see how I cna help you at the moment.

Use only as a last resort.  This is a dangerous tool when used inappropriately.

Search for sql injection for more details.