Join data / union data ?? - SQL Server Forums

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)

Join data / union data ??

Author

Topic

n1ckyr
Starting Member

1 Post

Posted - 2006-12-20 : 04:38:01

how to join data in another view

Tabel data 1
ID HeadSubject HeadID
1 Outdoor 6
2 Indoor 6

ID Subject Access HeadID
1 Marketing 5 6
2 Sales 2,3 6
3 Sekretary 2,5 7

Result that i want in another view
ID HeadSubject Access HeadID
1 Outdoor 2,3,5 6
3 Indoor 2,5 7

how to join / union that data to make the access

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-20 : 04:41:18

Search SQLTeam for a CSV user defined function.

But you should really benefit by normalizing your data.

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-20 : 05:19:53

1 Normalise the table. Do google search on Normalization
2 Do all concatenations at front end application

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources