"Filips Benoit" <benoit.filips@pandora.be> wrote in message
news:z7Xih.250704$Sp1.5410847@phobos.telenet-ops.be...

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:%23KCzregJHHA.1044@TK2MSFTNGP02.phx.gbl...
> Please post your DDL. You don't need a cursor:
>
> select
> Company
> , min (case when Date = '1/1/2007' then Code end) as D1
> , min (case when Date = '2/1/2007' then Code end) as D2
> , min (case when Date = '3/1/2007' then Code end) as D3
> , min (case when Date = '4/1/2007' then Code end) as D4
> from
> #CompanyDayCode
> group by
> Company
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> .
> "Filips Benoit" <benoit.filips@pandora.be> wrote in message
> news:z7Xih.250704$Sp1.5410847@phobos.telenet-ops.be...
> Dear All,
>
> I want to loop through a recordset in a SP and add some row-values as
> column-values in another table.
>
> #CompanyDayCode
> Company Date Code
> Com1 1/1/2007 CL
> Com1 2/1/2007 CL
> Com2 3/1/2007 CL
> Com3 4/1/2007 CL
> Com3 2/1/2007 CL
> Com3 4/1/2007 CL
>
> -----------------------------no problem till
> here ---------------------------------------------------------
>
> Resultset of SP must be
>
> Company D1 D2 D3 D4
> Com1 CL CL
> Com2 CL
> Com3 CL CL
>
>
> Thanks,
>
> Filip
>
>