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.
| Author |
Topic |
|
tjbarr
Starting Member
8 Posts |
 Posted - 2008-07-08 : 14:50:13
|
| suppose I have a table:TableAField1 Name TammyField2 email t.barr@Field2 email tbc@Field2 email tjb@If I do a query: select * from tableA:I'll get col1 col2 Tammy t.barr@ Tammy tbc@ Tammy tjb@How can I construct an sql query that will display the fields where there is no redundancy.e.g. col1 col2 col3 col4row 1 Tammy t.barr@ tbc@ tjb@ |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-08 : 15:15:34
|
| moved from script library._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-08 : 15:16:21
|
| search for pivot around here._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
SQL CODE