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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2008-04-05 : 10:26:47
|
| i have a table that contains 2 columnsA B (B values are only 1 and 2)-- --x 1y 2z 1x 2z 1j 1k 2i want to make a query that will check for dinstinct x what B values it has Ex. It will show result like this resultA B-- --X 1 and 2Y 2z 1K 2how to make please help |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Computed Column?