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

    HELP WITH TRANSPOSE DATA

    Here is the output from a select statement: 1 select FCAT, TC, TT, VCAT, BOC, ENTRY , ACEV, DESCR, DB, CR, DB2, CR2, DB3, CR3, DB4, CR4, EDAT 2 from fms_glfcat 3 where fcat in ( 'V ' , 'NV') 4 AND ENTRY LIKE '1243%' 5* ORDER BY ENTRY, FCAT SQL> / FC TC TT V BOC ENTR ACEV DESCR...
  2. acct098

    Record Count - inclued first instance/exclued future instances

    Does anyone know how to write a script to count a record (T_NUM) once so that it is capture in the stats for the first date and excluded from all future dates? T_NUM EDATE ------------ --------- 797PR6005 05-DEC-06 797Q70015 05-DEC-06 797Q70015 06-DEC-06 797Q70015...
  3. acct098

    UPDATE STATEMENT

    I need help fixing the update statement below. The update statement updates all of the records on the table for a specific day. This is not what I want to happen. I would like the cleared field updated with an ‘N’ if the concatenated fields is found in a subset of concatenated fields (ref...
  4. acct098

    Monitoring Progress

    I need an sql script to manage progress when thing are constantly changing. Below is a layout of the tmp_susf table and count of the records by date. Inside of this table are records from each day--some leaving and new ones added. Does anyone have an idea as to how to show progress or a lack...
  5. acct098

    Create a spool file for each user

    Does anyone know how to create a PL/SQL script that will create a file for each USERID_2? The file will contain all records for a specific user. I would also like the file to be the name of the userid_2 (XXXXMW1). A copy of the table is as follows: EDATE USERID_2 B_ B_ B_NUM T_ AO T_NUM...
  6. acct098

    CONCENATION QUESTION

    TABLE LAYOUT: ID NOT NULL NUMBER (38) LABEL NOT NULL NVARCHAR2 (60) PARENTID NOT NULL NUMBER (38) SELECT * FROM (SELECT sYear, sMonth, SUM(DataLoad) AS DataLoad, Entity, sAcct, sGovCode FROM (SELECT...

Part and Inventory Search

Back
Top