Cross tab

11 Aug 2006 4:26 PM

Ric

I have two tables: Task and TaskType. One Task always has three TaskTypes:

create table task (taskID uniqueidentifier,taskname varchar(20))
create table tasktype (taskID uniqueidentifier,tasktypename varchar(20))

insert into task values
('EC02ED43-265C-47BC-9575-4C62F55A24E3','Documentation')
insert into tasktype values
('EC02ED43-265C-47BC-9575-4C62F55A24E3','Creation')
insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','QA')
insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Review')

What I would like to output is:
TaskName Tasklevel1 Tasklevel2 Tasklevel3
Documentation Creation Review QA

Thanks!

Ric

11 Aug 2006 5:03 PM

Reg Besseling

Hi Ric

please post full DDL's of your tables

--
Regards

Reg Besseling

Show quote

"Ric" wrote:

> I have two tables: Task and TaskType. One Task always has three TaskTypes:
>
> create table task (taskID uniqueidentifier,taskname varchar(20))
> create table tasktype (taskID uniqueidentifier,tasktypename varchar(20))
>
> insert into task values
> ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Documentation')
> insert into tasktype values
> ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Creation')
> insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','QA')
> insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Review')
>
> What I would like to output is:
> TaskName Tasklevel1 Tasklevel2 Tasklevel3
> Documentation Creation Review QA
>
> Thanks!
>
> Ric
>

11 Aug 2006 5:14 PM

Ric

Please note that these are just samples I created to simplify my issue. The
DDL you see in the create statements is all there is basically.

Ric

Show quote

"Reg Besseling" wrote:

> Hi Ric
>
> please post full DDL's of your tables
> --
> Regards
>
> Reg Besseling
>
>
> "Ric" wrote:
>
> > I have two tables: Task and TaskType. One Task always has three TaskTypes:
> >
> > create table task (taskID uniqueidentifier,taskname varchar(20))
> > create table tasktype (taskID uniqueidentifier,tasktypename varchar(20))
> >
> > insert into task values
> > ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Documentation')
> > insert into tasktype values
> > ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Creation')
> > insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','QA')
> > insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Review')
> >
> > What I would like to output is:
> > TaskName Tasklevel1 Tasklevel2 Tasklevel3
> > Documentation Creation Review QA
> >
> > Thanks!
> >
> > Ric
> >

11 Aug 2006 5:22 PM

Reg Besseling

Ric

i asked for full ddl as i could not "see" a way to tell which of your 3
tasktypes should be labled as Level 1 ,2 or 3

--
Regards

Reg Besseling

Show quote

"Ric" wrote:

> Please note that these are just samples I created to simplify my issue. The
> DDL you see in the create statements is all there is basically.
>
> Ric
>
> "Reg Besseling" wrote:
>
> > Hi Ric
> >
> > please post full DDL's of your tables
> > --
> > Regards
> >
> > Reg Besseling
> >
> >
> > "Ric" wrote:
> >
> > > I have two tables: Task and TaskType. One Task always has three TaskTypes:
> > >
> > > create table task (taskID uniqueidentifier,taskname varchar(20))
> > > create table tasktype (taskID uniqueidentifier,tasktypename varchar(20))
> > >
> > > insert into task values
> > > ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Documentation')
> > > insert into tasktype values
> > > ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Creation')
> > > insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','QA')
> > > insert into tasktype values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Review')
> > >
> > > What I would like to output is:
> > > TaskName Tasklevel1 Tasklevel2 Tasklevel3
> > > Documentation Creation Review QA
> > >
> > > Thanks!
> > >
> > > Ric
> > >