Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Stored Procedures

Author  Topic 

raja.narina
Starting Member

6 Posts

Posted - 2011-01-18 : 05:58:16
how store the all the employeedetails and companydetails(joining these two tables using join command) in stored procedures

hint : the two tables are employeemaster and companymaster

N.S.Sitaram

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-01-18 : 06:04:32
Please explain what you are after further. Do you mean how to return all the details or how to write insert/update/delete statements via a stored procedure?

Is this homework?
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-18 : 07:18:55
hint : If you want us to write queries that work, you'll need to provide the definition of the tables.

What do you mean by ' store in stored procedure'? Stored procedures don't store data.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -