store procedure with join

joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.

Types of JOIN you can use

• JOIN: Return rows when there is at least one match in both tables
• LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table
• RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table
• FULL JOIN: Return rows when there is a match in one of the tables

For more detail about joins refer this 
http://www.gplivna.eu/papers/sql_join_types.htm

I hope after reading this you can create a stored procedure using join

It's simple, the selectable stored procedure works as any table.

select t1.id, sp1.field1
from t1
join sp1(parameters) on t1.id = sp1.id;

It you wish, you can also use fields from the table as input values into stored procedure. It that case, make sure you use LEFT JOIN to force table fields to be evaluated first (so they are available to stored procedure):

select t1.id, sp1.field1
from t1
left join sp1(t1.id) on 1=1;











Thanks.....

Hi,

You can get Sample Code from :

http://searchsqlserver.techtarget.com/feature/Sample-T-SQL-stored-procedure-P_DisplayProductDetails