On Friday evening...

Wow, that was easy! Thank you!

Sorry folks. I wasn't very clear. You are correct, I'm talking about DB mail. Sorry for the confusion. Going to clean up my original post a...

Thank you for your suggestion. I tried that this morning and it did not work with the brackets either.

But SUCCESS!! I can hardly believe how simple it was....

Column1 is a date field in my example. But it doesn't work no matter the data type. Once you add a where clause, it errors.

Server1 has detail transactions....

Yes, that is perfect. Thank you!

Dave Ballantyne (6/25/2010)

---

Well i would of said that way back but you stated ...

Which would rule out parameter...

No, I gave up and simplified the sp, which is not what I wanted to do but had to move on. I...

Good stuff. This has gotten the wheels turning. Thank you all.

That works perfectly. So easy, that the question now seems even more silly. LOL

Thank you, Jack!

Thank you for your replies.  I had a feeling this was elementary.  Thanks for taking it easy on me. LOL

Okay, I was able to move it...  http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3136121122120121120120

But I would still like to know why it is so big?  And how it got this way?

Thanks.

"SP4, as in the beta?"........I'm sorry.  That must be the o/s.  When I run select @@version, the following is returned:

Microsoft SQL Server ...

Thanks for the quick reply.

I have a sql 2k table with 23 million rows.  Call it BigTable.  I have an empty table that has the same structure as BigTable, with...