Posted on: 5/7/2014 7:58:08 AM | Views : 376

When I am trying to exute the below query I am not getting any data even though I have currnt year and month data avaliable in the table.
Table is like as followes:
TNUMBER     DOT     TXNTYPE     CHQNUM    CHQDATE    TXNAMT    ACID    BRID    USERID

TNUMBER: TRANSACTION NUMBER, DOT: DATE OF TRANSACTION , TXNTYPE:TRANSACTION TYPE, CHQNUM:- CHEQUE NUMBER,
CHQDATE: CHEQUE DATE, TXNAMT: TRANSACTION AMOUNT, ACID: ACCOUNT ID, BRID: BRANCH ID, USERID: USER ID( BANK EMPLOYEE NUMBER)

===============================GET THE DATA OF CURRENT MONTH=========================================

SELECT     ACID,                 DOT,                 TXNTYPE,                   &nbs ...

Go to the complete details ...