set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STPGetCheckOut_Print] /* */ @DetailCode int AS SELECT CheckOUTTBL.SerialNo, CheckOUTTBL.Comment AS CheckComment, CheckOUTTBL.CheckDate, CheckOUTTBL.FK_DocSysCode, dbo.FunConvDateToString(CheckOUTTBL.CheckDate) AS CheckDateString, DocDetailTbl.AmmountOUT AS Amount, DocDetailTbl.Comment AS DocComment, VWCompleteCode.Title AS To_AccountTitle, BanksTbl.AccountNo, dbo.FunConvCurToString(DocDetailTbl.AmmountOUT) AS AmountString, floor(DocDetailTbl.AmmountOUT / 10) AS Amount_Toman, dbo.FunConvCurToString(floor(DocDetailTbl.AmmountOUT / 10)) AS Amount_TomanString FROM CheckOUTTBL INNER JOIN DocDetailTbl ON CheckOUTTBL.FK_DocSysCode = DocDetailTbl.Syscode INNER JOIN BanksTbl ON CheckOUTTBL.FK_BankAccount = BanksTbl.Fk_AccountSyscode LEFT OUTER JOIN VWCompleteCode ON DocDetailTbl.SndFk_AccountSyscode = VWCompleteCode.AccountSysCode WHERE (CheckOUTTBL.FK_DocSysCode = @DetailCode)