----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: laks_win Message 3 in Discussion Hi, Pls refer the prev post and reply for the same kind of question. http://groups.msn.com/BDotNet/general.msnw?action=get_message&mview=0&ID_Message=24143&LastModified=4675511435209833640 Hope, this will help! Regards Lakshmi Narayanan.R ----- Original Message ----- From: DotNetSaavy (Mr.BabuRaj) To: BDOTNET Sent: Thursday, August 25, 2005 9:34 PM Subject: SQL Server - How to retrieve data this way ? New Message on BDOTNET SQL Server - How to retrieve data this way ? Reply Reply to Sender Recommend Message 1 in Discussion From: DotNetSaavy (Mr.BabuRaj) Hi, I have two table Employee and EmpProjects Employee table stores data as follows ************************************** EmpId ----- 1 2 3 EmpProjects table stores data as follows ***************************************** EmpId Project ----- -------- 1 P1 1 P2 1 P3 2 P1 2 P2 I need to create a view EMP_Proj which will have the following columns EmpId and Projects. The projects for each empid must be seperated by commas and stored in the projects column of the EMP_Proj view as shown below.. EmpId Projects ----- -------- 1 P1,P2,P3 2 P1,P2 How do I achieve this ? Thanks Raj View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
