Recent content by stiley

Thanks to both of you for your assistance. Much appreciated Sean

Hi there, Another plain SQL question. I have data that holds entity relationships across years. From it I'd like to know which values of Entity2 have only ever been related to a single Entity1 regardless of the year. Data looks like the following... Entity1 Entity2 Year 443 444...

Here is the solution... http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php#wm_concat Sean

Apologies. Using Oracle 10g Not actually coding, just writing a query to find data so just using pure SQL. Found this link that gives me what I'm looking for. http://thinkoracle.blogspot.com/2005/09/pivot-and-crosstab-queries.html Thanks

Hello, Question about formatting my query results. I have a customer table and a customer_phone table linked by customer_id field. When I select records from customer_phone for a particular customer_id I get as many rows as the customer has phone numbers. For example select * from...

It was a typo, my bad. Thanks for the solution

Hello, I have an issue with SQL and I just cant seem to figure out the approach to achieve the result I need.... I have the following record set and I am wondering how I can remove certain rows. C1[tab]C2[tab]C3[tab][tab]C4 A[tab]B[tab][tab]C[tab][tab]1 A[tab]C[tab][tab]C[tab][tab]2...

Thank you for your suggestions. I'll be sure to post to the appropriate spot next time Sean

Sorry Using Oracle. I figured it as follows SELECT * FROM ( select 'A' as id from dual union select 'B' as id from dual union select 'C' as id from dual union select 'D' as id from dual union select 'E' as id from dual) temp WHERE NOT EXISTS(SELECT * FROM SOME_TABLE a WHERE a.ID=temp.ID);

Do I need to create a function or something? When i try this I get an error.

Hello, I am fairly new to SQL and have a question that I'd like to pose. I have a list of IDs an I would like to find which IDs in that list do not exist in a particular table. It is simple to find the ones that exist in the table, but I am not sure how to go the other way. For example say I...

Hi there, These may be obvious questions, but do you have an environment variable ANT_HOME set? is ANT_HOME\bin in your system's path variable? Sean

Nevermind, my mistake, I had an extra command in the target that did the get. Sorry Sean

Hi there, I am not new to ant but have never seen the functionality it is now exhibiting, and I am confused I have a build file with 3 main targets. Target 1 functional-test: Gets all files based on branches from cvs and compiles and composes an EAR and WAR file for deployment as well, zips...