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 |
|
vijaychaudhari_engg
Starting Member
5 Posts |
 Posted - 2008-08-02 : 02:26:48
|
| i am new to SQl.i am using vb to display records in a column based on their value into two resultant columns.for e.g. column in a table with values say TESTA and TESTB i want to dsiplay these in two diffent columns.how can i? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-02 : 05:37:03
|
| Not sure what you're looking. are you asking to show cross tabed results? some sample data will help us to understand what you want.can you post it? |
 |
|
|
vijaychaudhari_engg
Starting Member
5 Posts |
Posted - 2008-08-03 : 05:28:26
|
| what i mean is,there is table by the name say Name with entries as Author and publisher.i want to display records for author and publisher as separate rows in result of my query based on some condition...as they both are in same column i am afraid they can be separated... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-03 : 17:57:35
|
| Does the table have another column to differentiate them? If not, how can you know who is author who is publisher? |
|
|
|
vijaychaudhari_engg
Starting Member
5 Posts |
Posted - 2008-08-03 : 23:21:09
|
| u can assume that there are othr tables and can let me know so that i can gethint from it.. and yes there are othwer tables also |
|
|
|
vijaychaudhari_engg
Starting Member
5 Posts |
Posted - 2008-08-04 : 03:51:05
|
| Hello.i got it had to use alias for the table for retriving the two values of the same column into to different columns... |
|
|
|
|
|
|
Problem for select