MANEESH AN

MANEESH AN

  • NA
  • 110
  • 46.9k

SQLDATETIME OVERFLOW EXCEPTION

Jul 6 2013 12:45 AM
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

Answers (7)