SELECT RTGSEntries.ReceiptDate, RTGSEntries.ReceiptNo, RTGSEntries.DepositorName, RTGSEntries.DepositorContact, RTGSEntries.AccountNo, RTGSEntries.AccHolderName, Banks.BankName, Branches.BranchName, RTGSEntries.IFCS, RTGSEntries.Fees, RTGSEntries.Amount, @Start AS FromDate, @End AS ToDate FROM ((RTGSEntries INNER JOIN Banks ON RTGSEntries.BankId = Banks.BankId) INNER JOIN Branches ON RTGSEntries.BranchId = Branches.BranchId) WHERE (RTGSEntries.ReceiptDate BETWEEN @Start AND @End)
Error in SELECT clause: expression near '@'. Error in WHERE clause near '@'. Unable to parse query text.
PARAMETERS dStart DateTime, dEnd DateTime; SELECT ... dStart AS DateFrom, dEnd AS DateTo ... WHERE ... BETWEEN #dStart# AND #dEnd#
PARAMETERS ReceptId NUMBER;SELECT RE.RTGSEntryId, RE.ReceiptNo, RE.ReceiptDate, RE.DepositorName, RE.DepositorContact, RE.BankId, BA.BankName, R.AccountNo, RE.AccHolderName, RE.BranchId, BR.BranchName, RE.IFCS, RE.Amount, RE.Fees, RE.Note1FROM RTGSEntries AS RELEFT JOIN Banks AS BA ON RE.BankId = BA.BankIdLEFT JOIN Branches AS BR ON RE.BranchId = BR.BranchIdWHERE RE.RTGSEntryId = ReceptId
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)