Query

[Prakash]

Hi;

Can someone help me forming the following query.

I have a table with name, value, environment as column names. And the
data looks like

JMSHost prdIPAddress production
JMSHost devIPAddress development
JMSPort Portnumber production

As you can see, the config table contain the values for different
environments. I would like to select all the "production" values first
and overwrite with an specific environment value. For eg, if its
"development" I would like to get the data of rows 2 and 3.

I hope this is clear. I appreciate your help on this.

Thanks

[Mark A]

"Prakash" <ve***********@hotmail.com> wrote in message
news:78**************************@posting.google.c om...

Hi;

Can someone help me forming the following query.

I have a table with name, value, environment as column names. And the
data looks like

JMSHost prdIPAddress production
JMSHost devIPAddress development
JMSPort Portnumber production

As you can see, the config table contain the values for different
environments. I would like to select all the "production" values first
and overwrite with an specific environment value. For eg, if its
"development" I would like to get the data of rows 2 and 3.

I hope this is clear. I appreciate your help on this.

Thanks

Not clear to me. Rows 2 and 3 are development and production.

[Prakash]

yes. 2 and 3 are dev and production. Since there are 2 rows for
"JMSHost" I want to take only one, which is "dev". So I want the
output to show JMSHost for "dev" (overwritten with JMSHost of
production) and JMSPort of production (since there are no JMSPort for
dev).

Thanks

[Tokunaga T.]

ve***********@hotmail.com (Prakash) wrote in message news:<78**************************@posting.google. com>...

yes. 2 and 3 are dev and production. Since there are 2 rows for
"JMSHost" I want to take only one, which is "dev". So I want the
output to show JMSHost for "dev" (overwritten with JMSHost of
production) and JMSPort of production (since there are no JMSPort for
dev).

Thanks

How about this?

SELECT name, value, environment
FROM your_table X
WHERE environment = 'development'
OR environment = 'production'
AND
NOT EXISTS
(SELECT *
FROM your_table Y
WHERE Y.name = X.name
AND Y.environment = 'development'
)
;

[Prakash]

Great. Thanks !!