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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2007-05-29 : 09:56:52
|
| how to convert rows into columns.Data in tableempcode basic1 1000 2 2000 Required outputempcode 1 2 basic 1000 2000 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-29 : 10:06:36
|
Remember these two simple equations:SQL Server = Efficient Data RetrievalFront-End = Easier Data FormattingSince, your question = Data Formatting questionand Data Formatting <> SQL ServerThe solution to your problem is,DIIFE ! (= Do It In the Front-End)  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2007-05-29 : 10:16:12
|
| dear harsh data is like 1 1000 2 2000i want data to be 1 2 1000 2000can v handle this in a query |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-29 : 11:47:43
|
| search for "pivot" around here_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
how to convert rows into columns