Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #920

Re: Custom agregation in Sql server 6

Show all headers | View raw

On 1 feb, 12:36, Erland Sommarskog <esq...@sommarskog.se> wrote:
> bradbury9 (ray.bradbu...@gmail.com) writes:
> > Input data
>
> > Col1, col2
> > 1,      'nebraska'
> > 1,      'boston'
> > 2,      'new york'
> > 3,      'pekin'
>
> > results desired:
> > Col1 col2_concatenated
> > 1      'nebraska,boston'
> > 2      'new york'
> > 3      'pekin'
>
> > The problem i find is using sql server 6 (sql server 2000 with
> > backward 6.0 compatibility actually).
> > I cant do custom agregate functions (those are sql 2005 or later)
> > I cant do "FOR XML PATH" (2005 or later also)
>
> In SQL 2000, no matter the compatibility mode, creating comma-separated
> lists means lots of dirty work. I didn't check your solution in detail, but
> if you have it work, there is no idea to look for anything better. Well, it
> is better to do it the client, that's where presentation belongs.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Well, the code does work. My guess is that was no nice and clean
solution but was not sure about it.

Thanks or the feedback.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Custom agregation in Sql  server 6 bradbury9 <ray.bradbury9@gmail.com> - 2012-02-01 03:21 -0800
  Re: Custom agregation in Sql server 6 Erland Sommarskog <esquel@sommarskog.se> - 2012-02-01 11:36 +0000
    Re: Custom agregation in Sql server 6 bradbury9 <ray.bradbury9@gmail.com> - 2012-02-01 06:27 -0800

csiph-web