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