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
 Transact-SQL (2000)
 interesting stored procedure & help

Author  Topic 

cez
Starting Member

37 Posts

Posted - 2002-09-14 : 16:58:24
Hi

Please help me if possible ..

I have a table called articles (- with art_id, art_name, ..), a table called properties ( with p_id, p_name, ..), a table values ( v_id, p_id, value) and a table articles_properties ( id, art_id, p_id, v_id).

Now I want from an ASP.NET page to make a query and build a table with the results like :

Article Name | Property 1 | Property 2 | Propery 3 | ...
name | 4.5 | 6.7 | 55
etc | etc | etc | etc

Because of one reason, I can't make this from programming so I need to build a SQL. Please can you help me ?

Thanks in advance



Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-09-15 : 01:21:33
Hi

This should do what you want
http://www.sqlteam.com/item.asp?ItemID=2955

Damian
Go to Top of Page
   

- Advertisement -