----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: vidhu1982 Message 4 in Discussion hi, declare @strCols as varchar(8000) set @strCols = '' select @strCols = @strCols + BankName from tblBank select @strCols from tblBank Regards, Vidhya >From: "Dreams" <[EMAIL PROTECTED]> >Reply-To: "MumbaiUserGroup" <[email protected]> >To: "MumbaiUserGroup" <[email protected]> >Subject: Re: Concat different rows column into single row field >Date: Wed, 15 Mar 2006 21:41:01 -0800 > > > > > > > > > > > > > New Message on MumbaiUserGroup > > > > > > > > Concat different rows column into single row field > > > > > Reply > > > > > > Reply to Sender > Recommend > > Message 3 in Discussion > > > > > > > > From: > Dreams > > > > > > > > > > New Message on MumbaiUserGroup > > > > > > > > Concat different rows column into single row field > > > > > Reply > > > > > > Reply to Sender > Recommend > > Message 1 in Discussion > > > > > > > > From: > Dreams > > > > > Concat different rows column into single row field Hi >Everyone , There is a table >ID Name >---- ----- >1 Peter >2 Mary >3 PauL > >I would like to get all these three records and return in a single field, >that is, PeterMaryPaul > >Thanks in Advance Dreams > > > > > > > View other groups in this category. > > > > > > > > > > > > > > > View other groups in this category. > > > > > > > > > > > > > >Also on MSN: >Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily >Horoscopes > > > > > > > > > > > To stop getting this e-mail, or change how often it >arrives, go to your E-mail Settings. > > > Need help? If you've forgotten your password, > please go >to Passport Member Services. > > For other questions or feedback, go to our > Contact Us >page. > > > 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. > > > Remove my e-mail address from MumbaiUserGroup. > > > > > > > _________________________________________________________________ NRIs Zero balance Account. FREE Money Transfers with FREE DVD https://www.online.citibank.co.in/portal/rca_msntagofline.htm ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_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]
