IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[STPListCheckInForPrint_Body]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[STPListCheckInForPrint_Body]
GO
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[STPListCheckInForPrint_Body]
    
AS
SELECT     Radif, SerialNo, ACCNo, CheckDate, BankName, Amount
FROM         CheckInsForPrintTBL
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[STPListCheckInForPrint_Header]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[STPListCheckInForPrint_Header]
GO
create PROCEDURE [dbo].[STPListCheckInForPrint_Header]
    
AS
SELECT     count(Radif) as CheckCount, sum(Amount) as TotalAmount,dbo.FunConvCurToString(sum(Amount)) as TotalAmountStr
FROM         CheckInsForPrintTBL
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StpListStpForCheckInsPrint]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[StpListStpForCheckInsPrint]
GO
create PROCEDURE [dbo].[StpListStpForCheckInsPrint] 
AS
declare @T table(
	StpName nvarchar(100),
	TableName nvarchar(100)
)
insert into @T (StpName,TableName) Values ('STPListCheckInForPrint_Body','Body')
insert into @T (StpName,TableName) Values ('STPListCheckInForPrint_Header', 'Header')
select * From @T