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:44:20
|
| 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 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-16 : 05:48:03
|
| You need to create a stored procedure after deciding what you are doing to doPost your query we will teach you how to make use of stored procedure.Also read about Stored procedures in sql server help file for basic informationsMadhivananFailing to plan is Planning to fail |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-16 : 05:51:15
|
| 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 |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-16 : 06:01:20
|
Instead of posting same problem twice or thrice, it would be more useful if you could describe your problem in more details and in simpler terms. Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
stored procedure