[BlogAnswerByQuestionId] @QuestionId intAS SELECT [HRM_BlogAnswer].[Id] as Id ,(SELECT COUNT(*) FROM HRM_BlogVote WHERE HRM_BlogVote.AnswerId =[HRM_BlogAnswer[Id]) AS NoOfComments
[ApprovedOn]) AS [Month], Count(*) AS [LeaveTaken]
[HRM].[tbl_EmployeeInfo] [EI]
FULL JOIN [HRM].[tbl_AdditionType] [AdditionType] ON [AdditionType].[AdditionTypeCode]
FULL JOIN [HRM<