Need SQL script to get the 6 months data month wise

You can try this:

SELECT
    DATEPART(yyyy, dtAttendDateTime)as Year, 
    DATEPART(mm, dtAttendDateTime) as Month,
    COUNT(*) AS [Total]
FROM Payroll_tblAttendance
WHERE dtAttendDateTime > dateadd (MONTH, -6, GETDATE())
GROUP BY
    DATEPART(yyyy, dtAttendDateTime), 
    DATEPART(mm, dtAttendDateTime)
ORDER BY
    DATEPART(yyyy, dtAttendDateTime), DATEPART(mm, dtAttendDateTime)

---

Regards atik sarker