To populate all dates in a month in SQL and SSRS

Discussion in 'General MSSQL Discussion' started by annavincent, Apr 7, 2021.

  1. annavincent

    annavincent

    Joined:
    Apr 7, 2021
    Messages:
    1
    Likes Received:
    0
    Hi All,

    Request your help very urgently

    I got requirement like we need to create a report based on employee, say Kumar, logged 3 hours.
    For example,
    if a person is logged Hours in system for 1-1-2021. But he didn't logged for 2-1-2021.

    So the report should be like

    Date Employee Hours
    1-1-2021 Kumar 3
    2-1-2021 Kumar 0
    1-1-2021 Sai 0
    2-1-2021 Sai 3


    We have a join query to get the date and worked hours for each employee.
    But here we need a query to get all dates in a month in the report whether the employee logged hours or not.() for not logged days)

    How can i do that ?
     
    annavincent, Apr 7, 2021
    #1

    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. How to line up first month, second month, third month etc.

  2. group by month and show month with zero even when no data for it

  3. Comparing SQL Server dates and Dates from Classic ASP

  4. Quickest way to figure out last month's start and end dates

  5. Count of Sales Order by Day, Week, Month and month

  6. How To: Retrieve all the dates that occures between two dates

  7. reporting between dates 26th of a month to 25th of the next month

  8. All dates between two dates

Loading...