Jeremy Kirkbride
asked on
SQL DATE filter on sales history
I am trying to write a simple SQL query that sums a salesman sales by month, but the date seems to be my trouble.
What I need to see is summed sales by salesman for a particular month/year 11-2013
SELECT HDR.slspsn_no,SUM(LIN.sls_ amt)
FROM oehdrhst_sql HDR
INNER JOIN oelinhst_sql LIN ON
HDR.inv_no=LIN.inv_no
WHERE HDR.inv_dt=(11-2013)
GROUP BY HDR.slspsn_no
As the above is written I get (0 row(s) affected)
Any help would be much appreciated
What I need to see is summed sales by salesman for a particular month/year 11-2013
SELECT HDR.slspsn_no,SUM(LIN.sls_
FROM oehdrhst_sql HDR
INNER JOIN oelinhst_sql LIN ON
HDR.inv_no=LIN.inv_no
WHERE HDR.inv_dt=(11-2013)
GROUP BY HDR.slspsn_no
As the above is written I get (0 row(s) affected)
Any help would be much appreciated
You need to extract only month/ year from the date field before applying the filter. What is your database?
ASKER
SQL
SQL is not a database. I have asked if you are working in SQL Server/Oracle/DB2/MySQL or any other database?
ASKER
SQL Server 2012, but I am writing a query with SQL Server Management Studio. That help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks so much, exactly what I needed. I'm sure simple for you, but I'm new to SQL