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
- 3419 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
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Do you know what is openxml in sql server?
How to generate create function script on an existing function?
Difference between DELETE and TRUNCATE?
How will you find out if there are expensive SQL statements running or not?
Can you edit the .rdl code associated with a linked report?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to view existing indexes on an given table using sys.indexes?
What is the process of normalising?
Can sql servers link to other servers?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is bcp? When does it used?
What is use of except clause? How it differs from not in clause?
Why is the need for data conversion transformations?
