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
 General SQL Server Forums
 New to SQL Server Programming
 Plz Help with stored Procedure?

Author  Topic 

roxcy
Yak Posting Veteran

58 Posts

Posted - 2006-11-22 : 06:23:29
Hi,
I am using two tables EmpDetails & SalesDetails.EmpDetails consists of EId,EmpCode,Branch.
SalesDetails consists of SrNo,ModelNo,Remarks.On my client End I am using a Dropdown Which consists of SrNo from Table SalesDetails.On selecting SrNo from Dropdown I am trying to display my outPut in Datagrid.I want my output in the Following Format.
EmpCode,Branch,ModelNo,Remarks.
So i would like to do this using stored procedure .
Could someone Help me..plz

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-22 : 06:31:00
How do you tie these two tables together?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

roxcy
Yak Posting Veteran

58 Posts

Posted - 2006-11-22 : 06:44:35
Will using innerjoin be the best possible solution?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-22 : 06:53:24
Maybe. But we still don't know how to tell which records/rows for SalesDetails table to connect to which records/rows in EmpDetails table.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-22 : 12:05:04
quote:
Originally posted by roxcy

Will using innerjoin be the best possible solution?


Yes. Use join. What is your problem? Did you try using joins?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -