If anyone wants a suite of the following List functions for use in SQL 2000...let me know offlist..
listAppend listDeleteAt listFirst listGetAt listInsertAt listLast listLen listPrepend listSetAt listToTable -----Original Message----- From: Justin [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:54 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT ValueList() in T-SQL That is sweet!!! Thanks Adrian. declare @Emaillist varchar(8000) SELECT @Emaillist = COALESCE (@Emaillist + ', ', '') + CAST(Email AS varchar(250)) FROM Notification select @Emaillist Only thing is to remove duplicates.... Work distinct in tere somewhere... Justin -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 15:38 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT ValueList() in T-SQL ooo - that's nice. > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:37 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > Scroll to the bottom... > > http://www.sqlteam.com/item.asp?ItemID=2368 > > Ade > > -----Original Message----- > From: Justin [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:33 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > > You could use COALESCE to build a valid list. > > If your on mssql. > > I am. Version 7. > > Not sure how to that? If I have > > Email > ------------- > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > How do I get > > [EMAIL PROTECTED],[EMAIL PROTECTED] > > SELECT EMail From Table > > Thanks > > > -----Original Message----- > From: Paul Fennell [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:14 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT ValueList() in T-SQL > > > > > -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:14 > To: Cfuk > Subject: [ cf-dev ] OT ValueList() in T-SQL > > > Hi all, > > Anyone know of T-SQL to do the same as ValueList() ??? > Am I stuck with a cursor? > > Thanks Justin > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003 > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
