Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shohan_db
Starting Member
36 Posts |
 Posted - 2006-11-16 : 05:40:10
|
| I want to make a simple Account report.Format will as followsCustomer ID: 101Date Reference Debit tk Credit tk1/9/06 Invoice 500 1/9/06 Money receipt 2003/9/06 Invoice 100 4/9/06 Money receipt 4000There are two tables in my DatabaseInvoiceInfo and MRInfoInvoiceInfo InvoiceDate Reference Amount MRInfo MRDate Reference NetAmountthe Date Field will fill by either InvoiceDate or MRDate and Amount field of Invoiceinfo table will execute in Debit tk field.NetAmount field of MRInfo table will execute in Credit tk field.I want to use a Stored procedure in SQL SERVER.What will be the query?Thanks Mainurshohan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-16 : 05:50:38
|
| Shohan, when will you ever learn!?DO NOT POST SAME PROBLEM MORE THAN ONCE! YOU ONLY MAKE PEOPLE ANGRY!The most possible result is that you get no help at all! Post just once, please...Almost every problem you post and ask for help is double or triple posting. DO NOT DO THIS!Peter LarssonHelsingborg, Sweden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
stored procedure