SQL problem

Baz

Baz

Baz

Soldato
Joined
9 Dec 2002
Posts
4,376
Location
Peterborough
I have a table with information in, where multiple lines refer to the same item, each line has a unique identity to it.
I want to insert 2 items from each line into a (temporary) table on one line, and have the new table only have as many columns as i need, so if i need 10 items, it only creates 10 columns, if i have 14 items, it creates 14 columns

possible or not?
 
Maybe I can query the table, I am looking at Cross-Tabs at the moment, and possibly a cube, getting complicated :D
 
In pratice, that is what I am trying to extract data from, I have already made a view from several tables.
 
You must log in or register to reply here.
Back
Top Bottom