Answer / Manish Jhala

* FROM table_name

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

Can group functions be used in the order by clause in ms sql server?

1 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

How to retrieve error messages using odbc_errormsg()?

1 Answers  

---

Explain the truncate command? : SQL Server Architecture

1 Answers  

---

How do I find the sql server version?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

Explain features and concepts of analysis services?

1 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---