Definately agree with you Matt, I need a nap now too.

😎

How about post the DDL for the tables, some sample data for each table (in the form of an insert statement with union all select statements), and what the output...

Another solution is this:

create table dbo.patient (

pt_id int,

pt_name varchar(20),

pt_dob datetime

)

go

create table dbo.charge (

ch_id int,

...

The DDL for the tables, some sample data, and the expected output based on the sample data would be helpful.

😎

I would say having a degree is worthwhile, but I would not persue it just to "filling a check box". I struggled to earn my BS degree while working...

I have gone out to confirm the issue. Thanks for the link.

😎

Jack,

Keep us posted on what you find. I have determined that this issue does exist on my two PeopleSoft database servers and I have asked our sys admins to...

Decided to try DB Mail from my desktop install of SQL Server 2005, and I ran into the same problem you are having with your server. Here is version...

Todd Engen (3/28/2008)

---

Jack,

This might be a .NET Framework 2.0 service pack 1 issue.

Based on three servers, the only one that appeared to work was the one without SP1. Here's...

Your welcome. I've been there with the brain freeze issue.

😎

Todd Biggins (3/27/2008)

---

Brain freeze! Using the following example:

Lastname FirstName DateModified

Smith Jim ...

If you would please provide the DDL for your tables, sample data in the form of inserts with unioned selects, this would help greatly. You have already provided the...

Our Exchange guru (I mean administrrator) is out this week. When he gets back I'll ask him if there is anything different on the Exchange side. If I...

Here is how our accounts and profiles are setup.

You'd be amazed at what some of the ref's I work with do in the real world. Take this one for instance: Professor at UCCS in the Computer Science...