Must declare the scalar variable "@BId".

Question

Dear Sir I create procedure but its not run give exception 'Must Declare the sclar value "@Bid"' Plese solve my problem Thanks In Advance

Code Alone · Answer

Kindly use below where BranchMaster= '' + CAST (@BId AS NVARCHAR(50)) + '' ) x This will not ask to declare @Bid

Laxmidhar Sahoo · Answer

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'

Sunil Sudhansu · Answer

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.

Must declare the scalar variable "@BId".

Answers (3)