Dear experts,
Please,help me.
Here is my code
Create procedure [dbo].[NewCase]
@User varchar(50)
AS
Begin
select count(*) from tblCASdetails as a
inner join tblMaping as b on a.BranchId=b.BranchID
full outer join tblCASClosed as d on a.CAS_No=d.CAS_No
inner join tblUploadFile as c on a.CAS_No=c.CAS_No where d.CAS_Status=''and d.Closed_By='' and b.Res_Person=@User
End