select first.MaskedOldCardNo,first.OldCardNo,first.OldAccountNo,first.ODUtilizedAmount,first.ODLimit,first.ODBalance from (SELECT top 1 [dbo].[fnMaskCardNo](E.CardNo)as MaskedOldCardNo,E.CardNo as OldCardNo, E.AccountNo as OldAccountNo,select ODUtilizedAmount from (select top 1 SASR.OdUtilizationAmount as ODUtilizedAmount from SalaryAdvanceSnapShotSpecificationReport SASR inner join Employee E on SASR.CardNo=E.CardNo where CorporateId=@CorporateId and EmpId=@EmpId AND IsDeleted=1 order by SASR.CreatedDate desc),SA.SA_Limit as ODLimit,dbo.fnGetODBalance(E.EmpId,E.CorporateId,E.CardNo) as ODBalance FROM EMPLOYEE E inner join SalaryAdvanceMaster SA on SA.C3EmpRegId=E.C3EmpRegId inner join dbo.SalaryAdvanceSnapShotSpecificationReport SASR ON SASR.CardNo=E.CardNo WHERE E.EmpId=@EmpId and E.CorporateId=@CorporateId and E.SalaryAdvance=1 and E.IsDeleted=1 ORDER by E.DeletedDate desc)first
Quote:In the FROM clause, each subquery requires an alias.
AS ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)