set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[STPIsCheckInExist] 
     @SerialNo  bigint,
     @CheckDate nvarchar(1000)='' ,
     @ACCNo  nvarchar(1000)=''
AS
if exists(SELECT     FK_DocSysCode
FROM         CheckInTBL
WHERE     (ACCNo = @ACCNo) AND (SerialNo = @SerialNo) AND (CheckDate = @CheckDate)) return 1 else return 0