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
- 2860 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanthi
create procedure sp_givesomename(@Id_Receive varchar(50))
as
select Id_Receive+'_'+Description_Receive+'debit account
credit account balance:'
+Amount_Receive from dbo.Receive where
Id_Receive=@Id_Receive
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to delete multiple rows with one delete statement in ms sql server?
What is isolation levels?
What are basics of policy management?
What is sql server profiler trace data file?
What is a full text index?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How to find table changes in sql server?
What is always encrypted?
What structure can you implement for the database to speed up table reads?
How to find related tables in sql server?
Why would you call update statistics?
What is the temp table?
What is the cartesian product of the table?
What are xml indexes?
Explain the different types of backups available in sql server? : sql server database administration
