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 TouchToneTommy 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: ziziak
  • Content: Threads
  • Order by date
  1. ziziak

    Need to add two parameters into VIEW

    Is there any way to send two parameters: PARAMETER_dateFrom PARAMETER_dateTo into my view (see below) called from outside? I expect query like this: select * from v_customFieldString where bug.id = XXXX and send in some way PARAMETER_dateFrom, PARAMETER_dateTo create or replace view...
  2. ziziak

    how to join two select?

    I need to create view from two select statements, need to join them. 1. select A.id,A.projectId,A.lastUpdated,A.oldValue from ( select bug.id as id ,bug.project_id as projectId ,bug.last_updated as lastUpdated ,his.old_value as oldValue from table1 bug left join history his on bug.id =...
  3. ziziak

    How to get number of months between two dates

    How can I get number of months between two dates crossing the year?
    • ziziak
    • Thread
    • Replies: 7
    • Forum: Java
  4. ziziak

    getMondayDate from weekOfYear

    how can I get date of Monday accroding given weekOfYear public Date getMonday(int weekOfYear){ ... }
    • ziziak
    • Thread
    • Replies: 1
    • Forum: Java
  5. ziziak

    group_concat change separator

    Hi all, how can I change separator in result of my group_concat? thanx
  6. ziziak

    Subselect problem

    Hi all, need help with sql cript. let's have these rows: Col1 Col2 ... Coln 1. Project1 Notes1 ... 2. Project1 Notes2 ... ...... 10. Project1 Notes2 ... and I need to get this result in one row : Col1 Col2 1. Project1 Notes1,Notes2,Notes3....Notesn how...

Part and Inventory Search

Back
Top