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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jq65
  • Order by date
  1. jq65

    Problem modifying a simple query into a subquery

    Greg Thanks - I modified your code a little and it works fine
  2. jq65

    Problem modifying a simple query into a subquery

    Thanks for the suggestion Greg but this returns an error : "Subquery cannot return more than one result" Also I only want the location with the maximum occurences
  3. jq65

    Problem modifying a simple query into a subquery

    The following simple query executes ok select location_name, count(*) from observation where season (observation_date) = 'summer' group by location_name; Season is a function and the query returns the locations and number of occurences of a certain activity I now want to modify it into a...
  4. jq65

    Problem with date function using SQL Anywhere DBMS

    atyagi, thanks a lot that worked when I passed it date values from a column - it doesnt work when I passed it values explicitly otherwise
  5. jq65

    Problem with date function using SQL Anywhere DBMS

    I am trying to create a function to return a specific month of the year after passing the function a date argument. I have first created a table as follows: create table season1 ( season_period CHAR(6) NOT NULL CHECK (season_period IN ('spring', 'summer', 'autumn', 'winter')), start_date...

Part and Inventory Search

Back
Top