set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[STPIsCheckOutExist] 
     @SerialNo  bigint,
     @BankAccountCode  Int 
    
AS
Begin
if exists(SELECT     CheckOUTTBL.FK_DocSysCode
FROM         CheckInTBL CROSS JOIN
                      CheckOUTTBL
WHERE     (CheckOUTTBL.SerialNo = @SerialNo) AND (CheckOUTTBL.FK_BankAccount = @BankAccountCode)) return 1 else return 0
END
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[STPGetVisitorByVisitGoodGroup]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[STPGetVisitorByVisitGoodGroup]
GO
create PROCEDURE [dbo].[STPGetVisitorByVisitGoodGroup]
	@GoodGroupCode int,
	@VisitorSysCode int output
AS

if @GoodGroupCode>0 
SELECT    @VisitorSysCode= FK_AccountSysCode
FROM         PersonTbl
WHERE     (VisitorGoodGroupCode = @GoodGroupCode)