I am having a real bad time trying to install SQL Server 2008 Express R2. It starts the install fine but when it gets to copying the files it reports...

I removed the classes and keys like thae article said but still get the same error. Could it be I am trying to put it on Windows 7 Pro?

It did not find it...

Solved my own problem....

Must be getting tired.

SELECT Count(qlkpApplicantWaitingListMain.ApplicationID) AS TotalCount, Year(qlkpApplicantWaitingListMain.[Approval Date])

FROM qlkpApplicantWaitingListMain

GROUP BY qlkpApplicantWaitingListMain.Status, Year(qlkpApplicantWaitingListMain.[Approval Date])

Thank you that worked great!

I suppose this is where I say duhhhhH! Thank you that worked perfectly!

That was perfect thanks.

Hey look at that, I solved my own issue. Thanks for your help.

SELECT ApplicantID, ([LastName] + ', ' + ISNULL([Suffix],'') + ', ' + [FirstName] + ' ' + ISNULL([MiddleName],'')...

I see the issue. It's returning a null for every name that does not have a Suffix. Is there a way around that?

I kinda see how its going... But the FullName is returning NULLS.

I had to re-install my SSMS for another reason and when I setup the database mail in accordance with your advice, it started working!!!!! THANKS!

Reinstalling the SSMS worked but I ended up having to uninstall Visual Studios 2008 first. Thanks.

Tried both the links but noting worked. Still looking into it.

Will there be any issues if I have SQL Server 2005 Express installed already. I am downloading the 2008 Developer evaluation and it about 3GB does that sound right?

OK I will unistall and try the developers editions.