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
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
Explain the microsoft sql server delete command?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Does a sql server 2005 select statement require a from?
Do you know nested transaction?
What is normalization and its types?
What do you mean by authentication modes in sql server?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is implicit mode in sql server?
What is attribute? : sql server analysis services, ssas
Do you know what is xpath?
How to search for a string in all stored procedure in sql server?
What is the difference between a unique key and primary key?
What do you know about system database? : SQL Server Architecture
What is a non equi join?
What are the differences between triggers and stored procedures?