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 |
|
TorspeR
Starting Member
11 Posts |
 Posted - 2010-09-27 : 07:56:21
|
| Hi,I would like to know how to include multiple values in one column for example per user. I have a table like so (SPACE separates column values on rows):user packet priceu1 1 5u2 3 4u3 2 3I need to know how to have multiple values in one column. In this case I need multiple values to packet column. After this I could be able to see how packet affects to the price column IF packet of u1 was 3 and not 1. But I still need to keep the packet column values the same all the time.Another way to do this would be if there's some kind of if clause. I mean that IF packet was 4 THEN price would be something else. I dunno how to do this in SQL. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-09-27 : 09:44:04
|
And we dunno what you want.Can you give example output?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Multiple column values