how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

---

Write an sql query for deleting duplicate rows?

0 Answers  

---

What are statistics?

0 Answers  

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

Do you know what is a with(nolock)?

0 Answers  

---

---

How to set a database state to offline in ms sql server?

0 Answers  

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

What is the recursive stored procedure in sql server?

0 Answers  

---

What is importing utility?

0 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

What are Row versions of DataRow?

0 Answers  

---

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  

---