title: sql server how to display data which is in the month of august?
body: <p>hello guys i have a small problem with my sql code
  i have to only display data in the database which is in the month of august 2008.</p>
  
  <p>my code so far is this </p>
  
  <p>i am supposed to show the sales of each sales person in the month of august 2008</p>
  
  <p>SELECT   p.BusinessEntityID,p.FirstName,p.LastName, ROUND(SUM(soh.TotalDue),2) AS 'Total Attributed Sales'
      FROM Person.Person p , Sales.SalesPerson s,Sales.SalesOrderHeader soh
      WHERE  p.BusinessEntityID = s.BusinessEntityID
      AND p.BusinessEntityID = soh.SalesPersonID
      AND soh.OrderDate >= '2008' AND soh.OrderDate &lt; '2009'
      GROUP BY p.BusinessEntityID,P.FirstName,P.LastName
      ORDER BY p.LastName</p>
  
  <p>i have the image of my database<br>
  <a href="http://www.2shared.com/photo/h2-jMQyP/AdventureWorks2008.html" rel="nofollow">http://www.2shared.com/photo/h2-jMQyP/AdventureWorks2008.html</a> </p>