Converting to crosstab table

Hello there
I have table with 2 fields: table1(Field1, Field2)
I need to present it as crosstab in this way:
Original:
1, 1
2, 2
2, 3
3, 4
3, 5
3, 6
3, 7
Should look like this:
1, 1
2, 2, 3
3, 4, 5, 6
4, 7
How can i do this dinamicly?See if this helps.
http://groups.google.com/group/micr...br />
6dd9e73e
AMB
"Roy Goldhammer" wrote:

> Hello there
> I have table with 2 fields: table1(Field1, Field2)
> I need to present it as crosstab in this way:
> Original:
> 1, 1
> 2, 2
> 2, 3
> 3, 4
> 3, 5
> 3, 6
> 3, 7
> Should look like this:
> 1, 1
> 2, 2, 3
> 3, 4, 5, 6
> 4, 7
> How can i do this dinamicly?
>
>|||Can you explain the logic behind the result?
--
"Roy Goldhammer" wrote:

> Hello there
> I have table with 2 fields: table1(Field1, Field2)
> I need to present it as crosstab in this way:
> Original:
> 1, 1
> 2, 2
> 2, 3
> 3, 4
> 3, 5
> 3, 6
> 3, 7
> Should look like this:
> 1, 1
> 2, 2, 3
> 3, 4, 5, 6
> 4, 7
> How can i do this dinamicly?
>
>|||I think he had a typo in his sample data.
Roy, this is why producing something we can repro will cause less problems.
Please generate CREATE TABLE and INSERT statements instead of typing out
tabular data by hand, it will be much less prone to errors. See
http://www.aspfaq.com/5006
"Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
news:A4DFEBEC-BABA-4929-9821-3077466EFA2F@.microsoft.com...
> Can you explain the logic behind the result?
> --
>
>
> "Roy Goldhammer" wrote:
>|||We don't need your ddl statements to confirm that whatever
type of dynamic xtab you want you can do easily with Rac:)
www.rac4sql.net