Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 turn over table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-31 : 09:55:46
Lady writes "Hi colleagues!
my questions:
how shell I turn over table?

I have table1 that contains a list of items
1 item1
2 item2
......
and each items connact with table2 whic stories a list of Items
1 param1
2 param2
.....
params. And Table3 where values of Params for each Items.
items params values
1 1 'a'
1 2 'b'
.........
I have to get result like folowing
items params1 params2
1 'a' 'b'

perfomance is very important!!!

thanks"

Nazim
A custom title

1408 Posts

Posted - 2001-12-31 : 10:38:11
Have a look at this, i think this should help you out

http://www.sqlteam.com/item.asp?ItemID=2955



Go to Top of Page
   

- Advertisement -