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
- 3282 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
Can we use custom code in ssrs?
What is the difference between implicit and explicit transaction?
Tell me about joins in database system and explain each in detail.
What are the triggers in sql?
How can you check the version of sql server?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is SubQuery in SQL Server 2008
Is mysql the same as sql server?
What are the restrictions that views have to follow? : SQL Server Architecture
How many columns can we include on clustered index ?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to check if a table is being used in sql server?
What is statement level trigger?
How to reaname table name without using sp_Rename in sql server..?
What is the meaning of resultset type_scroll_insensitive?
