TSQL help column to rows

[lendbz]

Hello,

I have a question:

I have a Table of certain items

create table item (
IdItem int,
Item varchar(64),
...
);

a lookuptable which defines some properties

create table property (
IdProperty int,
Property varchar(64)
);

and a table which defines the different properties which are possible for
a certain item:

create table tlkp_item_property (
IdItem int,
IdProperty int
);

So I can easily select all the properties of a certain item in a table
where the columns contain the properties. But I want to have an output
of the kind

Item 1, Property 1, Property 2, Property 3, ...
Item 2, <Properties of Item 2>
...

Any idea of how I would do this???

Thanks in advance

lendbz

 

[lendbz]

nevermind this thread. i posted on the wrong forum. sorry..