look this example:

i have a table with these data:

Sales Representative |Seattle
Vice President, Sales |Tacoma
Sales Representative |Kirkland
Sales Representative |Redmond
Sales Manager |London
Sales Representative |London
Sales Representative |London
Inside Sales Coordinator |Seattle
Sales Representative |London


how can i get this if the count of cities may change:

|Kirkland |London |Redmond |Seattle |Tacoma
Inside Sales Coordinator | | | |1 |
Sales Manager | |1 | | |
Sales Representative |1 |3 |1 | |
Vice President, Sales | | | | |1

> -----Original Message-----
> From: PUB: Wilson, Fred [mailto:fred.wilson@...]
> Sent: Martes, 25 de Junio de 2002 18:34
> To: 'ib-support@yahoogroups.com'
> Subject: RE: [ib-support] creating tables
>
>
> The ideal thing would be to describe (perhaps not in MS
> SQLServer SQL),
> what you need to do (real case), as in a specific example
> with DDL (table,
> etc) descriptions, and maybe someone will show you the IB/FB way ;)
>
>
> Best regards,
> Fred Wilson
> SE, Bell & Howell
> fred.wilson@...
>
>
> -----Original Message-----
> From: PODESTA Mariano APRE [mailto:SIDTMPO@...]
> Sent: Tuesday, June 25, 2002 2:07 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] creating tables
>
>
> hello,
> dynamic pivot is where you don't know the number of columns
> before hand.
> this is an example on m$ sql 2000 (not a real case):
>
>
> Create Table #tmp(
> IdKey char(10)
> )
>
> insert into #tmp (IdKey)
> select distinct KeyColumn
> from SourceTable
>
> declare @IdKey char(10), @Value varchar(10)
> declare @Values CURSOR
>
> EXEC EnumFilterOptions @Values output
>
> FETCH NEXT FROM @Values INTO @Value
> WHILE (@@FETCH_STATUS = 0)
> BEGIN
> Exec doAddColumn @Value
> FETCH NEXT FROM @Values INTO @Value
> END
> CLOSE @Values
> DEALLOCATE @Values
>
>
> procedure doAddColumn @Value
> AS
> execute 'ALTER TABLE #tmp ADD '+@Value+' int null'
> execute 'update #tmp
> set '+@Value+' = Val
> from SourceTable inner join #tmp
> on IdKey = KeyColumn
> where SourceTable.FilterColumn = '+@Value
>
>
> PROCEDURE EnumFilterOptions(@Values CURSOR VARYING OUTPUT)
> AS
> SET @Values = CURSOR
> FORWARD_ONLY STATIC FOR
> select distinct FilterColumn
> from SourceTable
> OPEN @Values
>
>
> > -----Original Message-----
> > From: PUB: Doug Chamberlin [mailto:DChamberlin@...]
> > Sent: Martes, 25 de Junio de 2002 17:30
> > To: ib-support@yahoogroups.com
> > Subject: RE: [ib-support] creating tables
> >
> >
> > At 06/25/2002 03:39 PM (Tuesday), PODESTA Mariano
> > APRE wrote:
> > >there are many cases where the best solution are temporary tables.
> > >one could be: making a dynamic pivot?
> >
> > I would re-phrase this to be "There are some cases where a
> > viable solution
> > is temporary tables." However, there are far more cases where
> > the need for
> > temporary tables is eliminated if you approach the problem in
> > a different
> > way. See below.
> >
> > >please do not answer with another question.
> >
> > The reason he did that was because long-time members of the
> > Firebird/Interbase community are very used to hearing the
> request for
> > temporary tables. Since they are a common solution when using
> > other RDBMS
> > products, newcomers to FB/IB can often be found to be
> > searching for these
> > old friends.
> >
> > The fact is they are not to be found in the same form you are
> > used to.
> > However, the good news is that we are really, really good
> at finding
> > alternatives. So, if you provide enough details of what you
> > are trying to
> > accomplish we may very well be able to find a solution. Thus
> > the questions.
> >
> > My question is: What's a "dynamic" pivot as opposed to a
> > regular pivot? ;)
> >
> >
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > ---------------------~-->
> > Free $5 Love Reading
> > Risk Free!
> > http://us.click.yahoo.com/3PCXaC/PfREAA/Ey.GAA/67folB/TM
> > --------------------------------------------------------------
> > -------~->
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Free $5 Love Reading
> Risk Free!
> http://us.click.yahoo.com/3PCXaC/PfREAA/Ey.GAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>