Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
3 4706How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
2 4889statement (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 3275can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
1 9141what is package configuration variable?How to change file name in folder dynamically?Plz help me
1 3274
What stored procedure would you use to view lock information?
How to compare the top two records using sql?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What happens when the SQL Azure database reaches Max Size?
What is the difference between having clause and where clause in sql server?
Explain foreign key in sql server?
Can you explain what are commit and rollback in sql?
How to verify a login name with sqlcmd tool?
What is mean by candidate key?
what's sql server? : Sql server database administration
what are the core components of SSRS?
How to restore performance issues and how to check?
How to get a list all databases on the sql server?
What are SSL and TSL protocols?
How to recompile stored procedure at run time?