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 TechMaria

  1. TechMaria

    Computing sums & formatting ...

    Ygor ! I sure don't know how many stars I should give for this post !... (actually I was waiting for your response !) As usual, your solution rocks ... and it works like a charm ... I am definitely in the process of learning awk and this would definitely help me get jumpstarted ! Just a...
  2. TechMaria

    Computing sums & formatting ...

    Hi, I have the following file : ROGER Jan 1000 4000 5000 20 80 ROGER Feb 2000 2000 4000 50 50 ROGER Mar 3000 3000 6000 50 50 TAMMY Jan 1000 4000 5000 20 80 TAMMY Feb 2000 2000 4000 50 50 TAMMY Mar 3000 3000 6000 50...
  3. TechMaria

    Append the next line

    Thanx a great lot for the responses ... Martin's solution worked the best ...Ygor's solution too worked when the file was exactly the same as given above .. but in some of my files, there were DDDDD1, EEEEE1 after the CCCCC1 ... and then Ygor's solution had to be modified ... And Martin's...
  4. TechMaria

    Append the next line

    Hi, I have a file with following info: AAAAA1 BBBBB1 CCCCC1 AAAAA2 BBBBB2 CCCCC2 AAAAA3 BBBBB3 CCCCC3 AAAAA4 BBBBB4 CCCCC4 AAAAA5 BBBBB5 CCCCC5 AAAAA6 BBBBB6 CCCCC6 I want it to be...
  5. TechMaria

    Select based on dates

    Thanx a lot for the responses ... Dave's solution does make my query look very decent ... I sure will use that ... Stefan, if I use partitioned tables, then both arc and data partitions will be in 1 table, right ? and so unless we change our application code it will scan the entire table...
  6. TechMaria

    Select based on dates

    Hi, I need to create a table by selecting data from another table based on one of its columns (which is a date field named t_data_date)... 1) Create a new archive table (t_arc) which stores 6 months of latest data from table (t_data) ... t_data currently has over 80 million rows and has about...
See more

Part and Inventory Search

Back
Top