Home Forums SQL Server 2008 SQL Server Newbies convert integer datatype as date format and group them by month RE: convert integer datatype as date format and group them by month

  • Post some code, DDL + the query you've tried.

    I would start by just querying the date field and getting the results you need there, converted to the month and year. Once you have something like

    2015 8

    2015 7

    2015 6

    ....

    Then you can worry about summing sales by customer and grouping by the customer and your date fields.