Here are a couple of links that should help:

http://www.sqlservercentral.com/articles/SQLMail/sqlmailusingpop3andsmtp/1577/

http://www.sqlservercentral.com/articles/Administration/sqlmailresources/605/

If you have any specific questions after using these resources please post here and I'll try to get back to you.

What does the data in the month column represent? Does 109 mean January 2009? If it does then I would write something like this:

Select

Car,

...

Just a guess, but I think if you found a way to eliminate this correlated sub-query

(SELECT

COUNT(*)

FROM

...

Jeffrey Williams (5/4/2009)

---

I generally use SET myself - mostly because it prevents issues where you can get the wrong value returned from a SELECT. When using SELECT - if...

You may want to look into using VBA in Excel and letting the users do the updates directly from Excel. As far as multiple users updating, it is like...

WIth SQL Server 2005 you need to have IIS installed in order to install reporting Services. Install IIS and then re-run your SQL Server setup and you should be...

While I don't think a degree in C.S. or Information Technology is necessary I certainly think it helps. I do not have a computer related degree. I do...

Well, first of all the code you have posted will NOT run successfully in SQL Server 2005 because it is using MySQL syntax and data types.

Next you should not...

Jeff Moden (5/4/2009)

---

Not a bad recommendation... I just do it all from T-SQL. I hope to...

Yeah, take it easy on Gail, she can't help it if she is...

The code you posted looks like it is targeted to MySQL not MS SQL Server. As Lutz said "Type=INNODB" is not valid in SQL Server and prior to SQL...

Duplicate post, please reply here

Can you post some sample data and what the desired result is?

Wouldn't something like this work:

CREATE TABLE #customers

(

customer_Id INT IDENTITY(1,1),

...

No workarounds that I can think of.

I have no idea, but I have passed it along to others who may. It looks like it is the first event when a trace is started, it is...