quote:

---

Originally posted by DBA in the making

Can you please check your sample data. The input doesn't appear to correspond to the desired output. eg, where did BLDBAT05 come from?

------------------------------------------------------------------------------------
Any and all code contained within this post comes with a 100% money back guarantee.

---

quote:

---

Originally posted by pk_bohra

why u don't want BTRPOD204 in your output.

---

quote:

---

Originally posted by rds207

There are almost 20 columns in host_jobdata table , with some millions of records , and from source table i get the host_name with combination of resourcenames and resource_pool_names ,
so i need to separate THAT hostname columns into two columns, resource names and resourcepoolnames ,
depending upon hostnames , if the hostname for that particular record falls into resourcepoolnames , then update resourcepoolcolumn with the same hostname and if hostname for that particular record falls in resourcenames them update resourcename with hostname else update with null.......

Please help ,

quote:

---

Originally posted by pk_bohra

Try this:

Declare @ec_resource Table
(resource_id int,
resource_name varchar(50)
)


Declare @resource_pool Table
(resource_id int,
resource_pool_name varchar(50)
)

Insert into @ec_resource
Select 24, 'BTRPOD104' union
Select 27, 'BTRPOD203' union
Select 28 , 'BTRPOD204' union
Select 35 , 'STRUT'


Insert into @resource_pool
Select 24,'POD1' union
Select 27,'POD2' union
Select 28,'POD2'


Select H.resource_pool_name as HostName,H.resource_pool_name as RESOURCE_POOL_NAME,Null as RESOURCE_NAME
From @resource_pool H
Union
Select H.resource_name as HostName,Null as RESOURCE_POOL_NAME,resource_name as RESOURCE_NAME
From @ec_resource H

---

---