Gift Peddie (2/24/2009)

---

That code works in all SQL Server from 6.5 the only difference is where the code is executed so you need to run that code in Query Analyzer...

Thanks for the info. Any ideas on my...

This is the first time I have setup DB mail since upgrading to SP2. I will give your solution a try. Thanks for the help!

Is there anyway to get intellisense on SSMS 2005?

How did you get that box to pop up with the table names when you were writing the query to select *? Is that builtin to SQL 2008?

Thanks for everyones help.

Adding the brackets took care of the problem. Kind of surprised that this column name was in the Adventure Works DB from Microsoft. Another lesson learned.

Here is a good article from SSC on MAXDOP

http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/

You could also use the MAXDOP option at the end of your queries. This will set the number of physical processors used for that particular query. MAXDOP is...

Just learned that you can use the LIKE command to select individual months. You have to use the three letter abbreviation and enclose it in percent signs. A...

Thank you! That worked great.

Unfortunately I am stuck with 2005 for now. Can you please provide an example using the UNION ALL statement?

Thanks!

Thanks for the tip. I did some Googling and came across this site.

ggraber (12/3/2008)

---

You did not see any results for the end dates because you specified exactly midnight of that day.

You did not have any records at exactly midnight on 10/4. However,...