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

    Transformation

    Hi, I want to create a report that looks like this: Metric 1 ============ 2004 2005 A Data is updated fortnightly (not exactly on the 15th and 30th of every month. updates take place on 13th or 14th or 15th or 16th of every month). Today I want sum(Metric 1) from Jan 1, 2005 to Jan...
  2. sntrao

    sql

    hi, i generate the following sql while executing a report: 1 select a14.PAY_PERIOD_YEAR PAY_PERIOD_YEAR, 2 sum(a11.DEALER_CONCESSION_AMOUNT) WJXBFS1 3 from CPC.CPC_PRODUCT_FACTS a11, 4 CPC.CPC_REPS a12, 5 CPC.CPC_BRANCHES a13, 6 CPC.CPC_PAY_PERIODS a14 7 where a11.REP_CODE = a12.REP_CODE and 8...

Part and Inventory Search

Back
Top