Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3156 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
What do you mean by data manipulation language?
What are the kinds of subquery?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How does normalization work?
How to loop through the result set with @@fetch_status?
In which tcp/ip port does sql server run? Can it be changed?
What do you mean by a dependent functionality in a build?
What is identity?
Which rendering formats are affected by the pagesize properties?
How to test odbc dsn connection settings?
What are the different types of lock modes in sql server 2000?
What is #table in sql server?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is subquery explain with example?
