JAYESH AJ

JAYESH AJ

  • NA
  • 97
  • 30k

Query analizer(8-2013)

Aug 8 2013 12:11 AM
The 3 type field displasy ,any schme display ,but The any loan creating one scheme select ,the scheme select dissuedate creating and partiqular duedate creating...... scheme A select loan creating (set perioddays 250)(scheme B is period days 100) .The any type scheme select the combobox and one year closing people display the query


example: ********Alter PROCEDURE sp_fillng
(
@vScheme varchar (50),
@vStatus varchar(50)

)
AS
begin



select vLoan_No as LoanNumber,vParty_Id as CustomerName ,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster

WHERE vScheme =@vScheme and ? and vStatus='N'
********************************************************************


vScheme
********
MONTHLY
Monthly
Monthly
SCHEME A
SCHEME B
Monthly
SCHEME A
Monthly
Monthly
SCHEME A
SCHEME A
SCHEME A
SCHEME A
SCHEME A

dissue date
***********

13-Feb-13 12:15:38 PM
13-Feb-13 2:26:25 PM
13-Feb-13 3:05:06 PM
14-Feb-13 10:45:43 AM
14-Feb-13 11:56:27 AM
14-Feb-13 12:58:03 PM
20-Feb-13 11:43:27 AM
19-Feb-13 11:43:27 AM
01-Jan-13 11:48:38 AM
01-Jan-13 3:17:08 PM
21-Feb-13 4:52:49 PM
22-Feb-13 6:22:33 PM
23-Feb-13 2:11:44 PM
23-Feb-13 2:28:00 PM

due date
***********

13-Feb-13 12:15:38 PM
13-Feb-13 2:26:25 PM
13-Feb-13 3:05:06 PM
14-Feb-13 10:45:43 AM
18-Feb-13 11:56:27 AM
14-Feb-13 12:58:03 PM
20-May-13 11:43:27 AM
20-Mar-13 11:43:27 AM
21-Feb-13 11:48:38 AM
21-Feb-13 3:17:08 PM
21-Feb-14 4:52:49 PM
22-Feb-14 6:22:33 PM
23-Feb-14 2:11:44 PM
23-Feb-14 2:28:00 PM
23-Feb-14 2:32:02 PM
26-Feb-14 3:58:05 PM
26-Feb-14 4:03:39 PM

Answers (5)