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 Chris 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: *

  1. rohithrn

    Help on Query to identify Dates sequence

    Hello, I got this issue answered from a different forum as I posted the same question over there. Below is the link for anyone who might have a similar requirement. http://www.dbforums.com/db2/1677540-query-identify-sequence-date-range.html Thank You !!!
  2. rohithrn

    Help on Query to identify Dates sequence

    I'm working on a DB2 query to identify the date sequence and to filter out any sub sets of date ranges. I really appreciate any help on this. This is how I have data in a view. ID Begin Date End Date 140721 6/26/2010 12/31/2010 <-- 140721 7/31/2010 8/27/2010 140721 9/25/2010...
  3. rohithrn

    SQL QUERY TO ROLLOVER VALUES FROM PRIOR YEAR TO CURRENT YEAR

    Hi, Thanks for the suggestion. I have learned the 'LEAD' and 'LAG' analytical functions and these helped me in solving my issue. Thank You
  4. rohithrn

    SQL QUERY TO ROLLOVER VALUES FROM PRIOR YEAR TO CURRENT YEAR

    HI ALL, Here is the scenario: In a table I have three columns year, price and expenses respectively. The values in it are as follows: YEAR PRICE EXPENSES 1/1/1999 4502 5681 1/1/2000 9644 157 1/1/2001 1036 16401 1/1/2002 1897 6443 1/1/2003...
  5. rohithrn

    SQL QUERY TO ROLLOVER THE VALUES FROM PRIOR YEAR TO CURRENT YEAR

    HI ALL, Here is the scenario: In a table I have three columns year, price and expenses respectively. The values in it are as follows: YEAR PRICE EXPENSES 1/1/1999 4502 5681 1/1/2000 9644 157 1/1/2001 1036 16401 1/1/2002 1897 6443 1/1/2003 8275 2390 1/1/2004 1405 1163 1/1/2005...

Part and Inventory Search

Back
Top