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 Chriss Miller 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: zinkjo
  • Content: Threads
  • Order by date
  1. zinkjo

    DB2 Sequence Object Grant Usage

    Anyone know how to grant user access to a sequence object in a physical model? Basically want the exported DDL to include GRANT USAGE ON SEQUENCE tablename TO username I know how to do it for tables and views. Any help would be appreciated. thanks.
  2. zinkjo

    comparing to datetime column

    what is the best way to compare a constant such as '07-21-2004' to a datetime column I want something like the following select * from tableA where myDateCol = '07-21-2004' if myDateCol has a value of '07-21-2004 10:15:00' the row should be selected. I want the query to ignore the time portion.
  3. zinkjo

    Self Join

    I have a need to join a table to itself. I need to determine if for a given deal number the swap deal number does not exist on the table. Here is my query thus far, but it is really dogging. Is there a better approach ?? select a.counter_ccy, a.value_date...
  4. zinkjo

    Left Join Problem

    I have 2 Tables: SeasonPlayer and GamePlayerStats. I want to retrieve all of the info from SeasonPlayer and if their is matching info on GamePlayerStats(for a particular game) retrieve that also. I think this is the correct query, but I keep getting "Join Expression Not Supported&quot...

Part and Inventory Search

Back
Top