SQLDATETIME OVERFLOW EXCEPTION
ALTER PROCEDURE [dbo].[sp_PaymentRegisterGridView]
(
-- @WhereCondition nvarchar(4000)
@dRPDate DateTime
)
AS
begin
-- declare @sqlQuery nvarchar(4000);
-- set @sqlQuery='
SELECT
ACC.dRPDate DATE,
ACC.cVType TYPE,
TS.vSeries SERIES,
ACC.iRPNo VOUCHERNO,
ACM.vAcName HEAD,
ACC.vNarration NARRATION,
ACC.deDRAmount DEBIT,
ACC.deCRAmount CREDIT
FROM tbl_Acc_Voucher AS ACC INNER JOIN
tblSerialNumbers AS TS ON ACC.iSeriesId = TS.iSeriesId INNER JOIN
tbl_Acc_AccountMaster AS ACM ON ACM.iAcID = ACC.iAcID
where ACC.dRPDate=@dRPDate
-- +@WhereCondition
--
-- exec sp_executesql @sqlQuery
-- end
-- RETURN
end