tables design help - 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

General SQL Server Forums

Database Design and Application Architecture

tables design help

Author

Topic

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2007-05-13 : 12:34:10

I used to get flat files which i need to import into tables..
The flat files data which contains.....

How should i design the tables so that i can get the output in single row...

Table1ForRow1
--------------
col1,100
col2,1
col3,xx
col4,yy
col5,,,
col6,20030101

Table1ForRow2
-------------
col1,100
col2,2
col3,20030101

Table1ForRow3
------------
col1,100
col2,3
col3,01
col4,20030101

FlatFiledata:
------------
100,1,xx,yy,,20030101
100,2,20030101
100,3,01,20030101

I want the output:
100,1,xx,yy,20030101,2,3,01

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-13 : 15:39:43

locked because it's dupe
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83514

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources