Must declare the scalar variable "@BId".

Msg 245, Level 16, State 1, Procedure Proc_GetMonthlyLeaveByBranchIDLedger, Line 15

Conversion failed when converting the nvarchar value 'SELECT DepartmentName,DesignationName,EmployeeCode,EmployeeName , [2018-08-01],[2018-08-02],[2018-08-03],[2018-08-04],[2018-08-05],[2018-08-06],[2018-08-07],[2018-08-08],[2018-08-09],[2018-08-10],[2018-08-11],[2018-08-12],[2018-08-13],[2018-08-14],[2018-08-15],[2018-08-16],[2018-08-17],[2018-08-18],[2018-08-19],[2018-08-20],[2018-08-21],[2018-08-22],[2018-08-23],[2018-08-24],[2018-08-25],[2018-08-26],[2018-08-27],[2018-08-28],[2018-08-29],[2018-08-30],[2018-08-31],[2018-09-28],[2018-10-01],[2018-10-04] from

(

select

BranchMasterID

,DepartmentName

,DesignationName

,EmployeeName

,PunchInOutDate

,EmployeeCode

,PunchInStatus

from VW_EmployeeMonthWiseRegister where BranchMasterID= ' to data type int.

Kindly use below 

 This will not ask to declare @Bid

hi

that is taken as string because within single queted you take it.

 

so  change the code from where like 

 

where BranchMaster=' + @BId 

+ ') x

------

-----

)P'