To populate all dates in a month in SQL and SSRS

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

  1. annavincent


    Apr 7, 2021
    Likes Received:
    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. 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.