Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by stiley

  1. stiley

    Count / group by

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

    Count / group by

    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...
  3. stiley

    Collapsing results to a single row.

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

    Collapsing results to a single row.

    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
  5. stiley

    Collapsing results to a single row.

    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...
  6. stiley

    SQL remove repeating rows

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

    SQL remove repeating rows

    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...
  8. stiley

    General SQL question - set operations

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

    General SQL question - set operations

    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);
  10. stiley

    General SQL question - set operations

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

    General SQL question - set operations

    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...
  12. stiley

    Problems with running ant.

    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
  13. stiley

    Odd behaviour with CVS

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

    Odd behaviour with CVS

    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...
See more

Part and Inventory Search

Back
Top