set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[STPGetPerson]
	/*
	
	*/
	@AccountCode int=0,
	@code bigint =0 
AS
SELECT     PersonTbl.VisitorPer, PersonTbl.Comment, PersonTbl.Introducer, PersonTbl.Code, PersonTbl.SalePriceNo, PersonGroup2Tbl.GroupName AS GroupName2, 
                      PersonGroup1Tbl.GroupName AS GroupName1, PersonTbl.GroupId1, PersonTbl.GroupId2, PersonTbl.FK_AccountSysCode, PersonTbl.ContactId, 
                      PersonTbl.VisitorCostAcc, PersonTbl.VisitorBaseAmmount, PersonTbl.VisitorIncreaseAmmount, PersonTbl.VisitorIncreasePer, PersonTbl.VisitorAutoDoc, 
                      PersonTbl.VisitorGoodActiveStat, PersonTbl.VisitorPerActiveStat, PersonTbl.VisitorGoodGroupCode
FROM         PersonGroup1Tbl RIGHT OUTER JOIN
                      PersonTbl LEFT OUTER JOIN
                      PersonGroup2Tbl ON PersonTbl.GroupId2 = PersonGroup2Tbl.GroupId ON PersonGroup1Tbl.GroupId = PersonTbl.GroupId1
WHERE     (PersonTbl.FK_AccountSysCode = @AccountCode) OR
                      (PersonTbl.Code = @code)