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
- 2590 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
‘Order by’ is not allowed in a view how can you sort information from a view?
What is RAID and what are different types of RAID configurations?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
What is the contrast amongst drop and truncate?
How to delete multiple rows with one delete statement in ms sql server?
How does clustered and non clustered index work?
Difference between 2NF &3NF ?
What is Schema? and why we use schemas?
Explain full-text query in sql server?
What is inline table-value user-defined function?
Define full outer join in sql server joins?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
