set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STPGridListPerson_Remain_CheckRemain_Contact] @UserSecLevel int AS SELECT FunCodeComplete_1.AccountSysCode, FunCodeComplete_1.Title, FunCodeComplete_1.CreditLimit, PersonGroup1Tbl.GroupName AS GroupName1, PersonGroup2Tbl.GroupName AS GroupName2, PersonTbl.Comment, PersonTbl.Code, PersonTbl.Introducer, PersonTbl.VisitorPer, VW_ContactId_ContactSumary.Fax, VW_ContactId_ContactSumary.Mobile, VW_ContactId_ContactSumary.Tel, VW_ContactId_ContactSumary.Address, VW_Account_Remain.LastDate, VW_Account_Remain.Remain, VW_Account_CheckInUnPass_Sum.Remain AS CheckRemain, InfoSecurityLevelTbl.Caption AS SecurLevel, InfoPersonPriceNoTbl.Caption AS SalePriceNo, PersonTbl.GroupId1, PersonTbl.GroupId2, PersonTbl.SalePriceNo AS SalePriceNoId, FunCodeComplete_1.SecurLevel AS SecurLevelId, VW_ContactId_ContactSumary.email FROM PersonTbl INNER JOIN dbo.FunCodeComplete(@UserSecLevel) AS FunCodeComplete_1 ON PersonTbl.FK_AccountSysCode = FunCodeComplete_1.AccountSysCode LEFT OUTER JOIN InfoSecurityLevelTbl ON FunCodeComplete_1.SecurLevel = InfoSecurityLevelTbl.Value LEFT OUTER JOIN InfoPersonPriceNoTbl ON PersonTbl.SalePriceNo = InfoPersonPriceNoTbl.Value LEFT OUTER JOIN VW_ContactId_ContactSumary ON PersonTbl.ContactId = VW_ContactId_ContactSumary.ID LEFT OUTER JOIN VW_Account_Remain ON PersonTbl.FK_AccountSysCode = VW_Account_Remain.Account LEFT OUTER JOIN VW_Account_CheckInUnPass_Sum ON PersonTbl.FK_AccountSysCode = VW_Account_CheckInUnPass_Sum.AccountCode LEFT OUTER JOIN PersonGroup2Tbl ON PersonTbl.GroupId2 = PersonGroup2Tbl.GroupId LEFT OUTER JOIN PersonGroup1Tbl ON PersonTbl.GroupId1 = PersonGroup1Tbl.GroupId