Link to home
Start Free TrialLog in
Avatar of Jeremy Kirkbride
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
Avatar of Sharath S
Sharath S
Flag of United States of America image

You need to extract only month/ year from the date field before applying the filter. What is your database?
Avatar of Jeremy Kirkbride
Jeremy Kirkbride

ASKER

SQL
SQL is not a database. I have asked if you are working in SQL Server/Oracle/DB2/MySQL or any other database?
SQL Server 2012, but I am writing a query with SQL Server Management Studio. That help?
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks so much, exactly what I needed. I'm sure simple for you, but I'm new to SQL