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
 Need to write a stored proc or view

Author  Topic 

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-12-20 : 15:14:28
Need help to write a Stored proc or create a view from another view

Sample Data of the view we have

Requestnumber Puchaseid
1 aab
1 bcc
1 c12
2 x13
2 y27

we have to write a stored proc or create a view where the data should look like

Requestnumber Purchaseid
1 aab,bcc,c12
2 x13,y27



Thanks
Vamsi


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-20 : 15:19:01
Duplicate post.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -