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 |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2010-04-01 : 18:13:30
|
| I need to map host_name with its associated resource name , currently i have multiple values , so i need to get distinct resource_names and its associated host_namesI cannot use distinct , if i write select distinct recource_name and host_name i get the values not mapped to each other ...Here is my Sample DataHOST_NAME RESOURCE_NAMEhcibldwin01 MOBWINhcibldwin01 hcibldwin01kwbuild06 KW_prodcadet cadetkwbuild07 KW_prodkwbuild07 KW_prodkwbuild07 KW_prodkwbuild07 KWBUILD07There are around 246 unique resource names and may be 5-6 hostname asscoaited with it , so how do i map recource name with host_name ?Please Help ... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Help With Query