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
 General SQL Server Forums
 New to SQL Server Programming
 Help to get data from two tables into one line for

Author  Topic 

myspeedy07
Starting Member

1 Post

Posted - 2009-08-24 : 22:29:26
I am trying to get data from a header file and detail file to all show on one line

ie:
header table sormaster has
1 record for SalesOrderNumber

detail table sordetail has
8 records for the line items associated to the SalesOrderNumber in the header file.

Can someone please help?
I have read TONS of solutions and I can t get any to work. If I were to rate myself on a SQL knowledge scale of 1-10 Im a 2. Thanks.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-08-24 : 22:51:20
see concatenate records without UDF


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -