You can try below like this as you don't want to use any other Parameter
alter PROCEDURE usp_sel_DailyReport
@Id int = null,
@WithdrawalAmount int,
@Balance int,
@BankName varchar(30),
@WorkerLabour varchar(50) = Null,
@PurchaseMatrialAmount int,
@PurchaseAgainst varchar(50),
@Comments varchar(max)
as begin
IF @WorkerLabour = NULL OR ISNULL(@WorkerLabour.'') = ''
BEGIN
select Id,WithdrawalAmount,Balance,BankName,WorkerLabour,PurchaseMatrialAmount,PurchaseAgainst,Comments from tbldailyreport where IsActive=1
END
ELSE
BEGIN
if(@ID is null)
insert into tbldailyreport (WithdrawalAmount,Balance,BankName,WorkerLabour,PurchaseMatrialAmount,PurchaseAgainst,Comments,IsActive,Date ,CreatedBy ,LastUpdatedBy)
values (@WithdrawalAmount,@Balance,@BankName,@WorkerLabour,@PurchaseMatrialAmount,@PurchaseAgainst,@Comments,1,Getdate(),'Admin','Admin')
else
update tbldailyreport set WithdrawalAmount=@WithdrawalAmount,Balance=@Balance,BankName=@BankName,WorkerLabour=@WorkerLabour,PurchaseMatrialAmount=@PurchaseMatrialAmount,PurchaseAgainst=@PurchaseAgainst,Comments=@Comments,Date = GetDate()
where ID=@ID
end
END