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

Recent content by swarddb

  1. swarddb

    Rolling sum

    What i need is as follows; date count 01 1 02 2 03 7 04 10 what i need is date count rolling sum 01 1 1 02 2 3 03 7 10 04 10 20 select...
  2. swarddb

    Converting Unix t time

    I am getting 997723754 as a time from an oracle db. I need to be able to convert this field into an Oracle recognized field then trunc it so that i can aggragate the data into our data warehouse. Can't find out how to change that UNIX t timestamp to a MM-DD-YYYY format. TIA stefan
  3. swarddb

    Opinions please

    We are looking at BO and Cognos and a few other tools for our data warehouse project. Please let me know why you guys and gals went with BO over other tools and what your success has been with support, instalation and ease of end-user use. thanks much!
  4. swarddb

    Count (distinct ###) for weeks back.

    Thanks for the help. Work just fine. stefan
  5. swarddb

    Count (distinct ###) for weeks back.

    WE need to backload a data warehouse by week back two years and do a count(distinct station_id) by each week from that starting point forward. How is this done? Is there a week function we are not aware of?
  6. swarddb

    cgicmd.dat not working for me

    not reading the cgicmd.dat file for somereason please help. On a unix box runnig reports 6.i
See more

Part and Inventory Search

Back
Top