> > Hi,
> >
> > I do not have much exposure to SqlServer. I want to know if there is any aggregate function with group by clause that concatenates a field values.
> >
> > I have three tables (size,constraints omitted):
> > bookMast (bmpk,bincd,bookId,bookName,language,genre,publisherid)
> > bookAuthors(bapk,bookId,authorId)
> > authorMast(ampk,authorId,title,fname,mname,lname,penname)
> >
>
> Yes, there are a couple of ways to do this in SQL Server. Check out my article on the subject:
>
>
http://www.tomorrowssolutionsllc.com/Articles/Consolidate%20data%20from%20a%20field%20into%20a%20list.pdf>
> Tamar
Great. Thank you very much.
C.V.Ramesh