mrazek@compik.fd.cvut.cz (Martin Mrazek) wrote in message news:<dcd39e84.0405271815.13dd8e97@posting.google.com>...
> Hi,
> this is easy with OLAP tools, but I need to do it just with MS-SQL
> server:
>
> fatTable
> year type val
> 97 a 1
> 97 b 2
> 97 c 3
> 98 a 4
> 98 b 5
> 98 c 6
> ...
>
> year type_a type_b type_c
> 97 1 2 3
> 98 4 5 6
> 99 ...
>
> The problem is number of different types - not just 3 like a,b,c but
> more than 100, so I don't want to do it manually like
>
> select
> year, a.val, b.val, c.val
> from
> (select year, val from factTable where type='a') a
> full join (select year, val from factTable where type='b') b
> on a.year = b.year
> full join (select year, val from factTable where type='c') c
> on a.year = c.year
>
> is it possible somehow with DTS or otherwise? I just need to present
> the data in spreadsheet in more readable form, but I cannot find any
> way how to export the result from MS-SQLserverOLAPservices to Excel...
>
> Martin