Click here to Skip to main content
15,113,295 members

Comments by Member 11148917 (Top 3 by date)

Member 11148917 10-Mar-17 8:38am View
   
Thanks a lot for ur response and i got the same result as above that

104 25400.00 66400.00
106 32500.00 75000.00
110 250000.00 78900.00

first account table data is
acno cust_name balance
101 aa 200000.00
102 bb 235000.00
103 cc 450000.00
104 dd 350000.00
105 ee 985000.00
106 ff 567000.00
107 gg 262000.00
108 hh 655000.00
109 ii 785000.00
110 jj 489000.00

the deposite table data is

acno deposited_amt
101 10000.00
102 12500.00
103 15500.00
104 25400.00
105 26000.00
106 32500.00
107 15400.00
108 100000.00
109 200000.00
110 250000.00

withdraw table data is

acnt_no balance
101 15000.00
102 75000.00
103 85500.00
104 66400.00
105 12000.00
106 75000.00
107 45400.00
108 10000.00
109 45600.00
110 78900.00

and i want to get result table with 3 columns with acno_no,deposited_amt in deposite table which is >25000 and balance in withdraw table which is >50000
Member 11148917 10-Nov-16 9:15am View
   
i had installed through the given link.but still not working.. :-(
Member 11148917 20-Oct-16 6:58am View
   
Thank you very much for respondig to the problem Plz help me on this....which SQL server 2008 version I need to download for management studio....

But i am not getting integration,analysis and reporting services in server type while connecting to server in management studio

Thanks in advance