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)
 Query help

Author  Topic 

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2006-08-03 : 11:55:06
I need a help in displaying the data.

Table:PCD
----------
PID PCD
1004 010
1004 020
1004 030

Table:PACD
----------
PID PDD
1004 010
1004 020
1004 040
1004 060
1004 070


Desired output:

Pid PCD PDD--- ---- ----
1004 010,020,030 010,020,040,060,070

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-08-03 : 12:09:54
Display = Front end

For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx

Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-08-03 : 12:22:11
For Rows to Columns:

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx

Srinika
Go to Top of Page
   

- Advertisement -