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
  • Order by date
  1. acct098

    HELP WITH TRANSPOSE DATA

    I'm trying to get both fundcat on one line. All of the remaining fields in the record are the same (this should be grouped). I typed the output in the original post. I could not get the function or SQL statement to produce the desired output.
  2. acct098

    HELP WITH TRANSPOSE DATA

    INSERT INTO FMS_GLFCAT VALUES( 'VR', '35', 'NV', 'G', '2104', '1243', 'SP03', 'test ', '2113', '2122', '4650', '490N', '2113', '2122', '4650', '490N', '11-MAR-08', '08'); INSERT INTO FMS_GLFCAT VALUES( 'VR', '35', 'V', 'G', '2104', '1243', 'SP03', 'test ', '2113', '2122', '4650'...
  3. acct098

    HELP WITH TRANSPOSE DATA

    CREATE TABLE FMS_GLFCAT ( TC VARCHAR2(02), TT VARCHAR2(02), FCAT VARCHAR2(02), VCAT VARCHAR2(01), BOC VARCHAR2(04), ENTRY VARCHAR2(04), ACEV VARCHAR2(04), DESCR VARCHAR2(30), DB VARCHAR2(04), CR VARCHAR2(04), DB2 VARCHAR2(04)...
  4. acct098

    HELP WITH TRANSPOSE DATA

    Looking a few of your answers from other posts I think that a function would be appropriate(unsure about if a create or replace function would work). I know what I want the output to look like. Below is the sql that I think may work User-defined function) create or replace function fcat...
  5. acct098

    HELP WITH TRANSPOSE DATA

    ..., 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 DB CR DB2 CR2 DB3 CR3 DB4 CR4 EDATE -- -- -- - ----...
  6. acct098

    ORA 27101 Shared memory...

    Does anyone know of another way that the database can be started besides using SQL+? Im getting the same error and I can't get to SQL+.
  7. acct098

    Record Count - inclued first instance/exclued future instances

    ...4 ELSE NULL END) A , 5 COUNT(CASE WHEN CLEARED = 'N' 6 THEN 'X' 7 ELSE NULL END) B , 8 COUNT(*) AS TOTAL 9 FROM SUSF u 10 WHERE USERID_2 = 'S796MRR' AND 11 MAX(EDATE) From 12 EXISTS (SELECT 'x' FROM SUSF q 13...
  8. 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...
  9. acct098

    UPDATE STATEMENT

    ...IS NULL THEN 'X' ELSE NULL END) A , COUNT(CASE WHEN CLEARED = 'N' THEN 'X' ELSE NULL END) B , COUNT(*) AS TOTAL FROM SUSF WHERE EDATE IN ('05-DEC-06' , '06-DEC-06') AND USERID_2 = 'S796MRR' GROUP BY USERID_2, EDATE ORDER BY USERID_2, EDATE;
  10. acct098

    UPDATE STATEMENT

    Found it: Set timing on
  11. acct098

    UPDATE STATEMENT

    Does anyone know the syntax to show the runtime of a sql script?
  12. acct098

    UPDATE STATEMENT

    After messing with the code it looks like I am onto something. I did not want to update the whole table so I adde the edates. I have remove them and currently running the following code: UPDATE SUSF u SET CLEARED = 'N' where EXISTs ( SELECT...
  13. acct098

    UPDATE STATEMENT

    ...4 SELECT '?' FROM SUSF q 5 WHERE q.EDATE = u.EDATE + 1 6 AND q.USERID_2||q.B_C||q.B_AO||q.B_NUM||q.T_C||q.AO||q.T_NUM 7 = u.USERID_2||u.B_C||u.B_AO||u.B_NUM||u.T_C||u.AO||u.T_NUM) 8 / SELECT '?' FROM SUSF q * ERROR at line 4: ORA-00936: missing expression
  14. acct098

    UPDATE STATEMENT

    ...FROM SUSF q 6 WHERE Q.EDATE = U.EDATE + 1 7 AND Q.USERID_2||Q.B_C||Q.B_AO||Q.B_NUM||Q.T_C||Q.AO||Q.T_NUM 8 = U.USERID_2||U.B_C||U.B_AO||U.B_NUM||U.T_C||U.AO||U.T_NUM) 9 / EXISTS ( * ERROR at line 4: ORA-00920: invalid relational operator
  15. acct098

    UPDATE STATEMENT

    Im still stuck. Any ideas on how to fix the code below: UPDATE SUSF SET CLEARED = 'N' WHERE EDATE IN ('01-DEC-06' , '30-NOV-06') AND Q.USERID_2||Q.B_C||Q.B_AO||Q.B_NUM||Q.T_C||Q.AO||Q.T_NUM EXISTS ( SELECT U.USERID_2||U.B_C||U.B_AO||U.B_NUM||U.T_C||U.AO||U.T_NUM FROM...
  16. 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...
  17. acct098

    Monitoring Progress

    Im taking a different approach. Does anyone know how to speed this query up? SELECT EDATE, USERID_2||B_C||B_AO||B_NUM||T_C||AO||T_NUM FROM SUSF WHERE SUBSTR(USERID_2,1,1) IN ('R' , 'S') AND EDATE + 1 IN (SELECT EDATE FROM SUSF) AND USERID_2||B_C||B_AO||B_NUM||T_C||AO||T_NUM IN (SELECT...
  18. acct098

    Monitoring Progress

    I looking for ideas an easy to show progress. Example: Date Record USER 01/01/2006 A CAT 01/01/2006 B DOG 01/02/2006 A CAT 01/02/2006 C CAT 01/03/2006 A CAT 01/03/2006 C CAT 01/03/2006 D MOUSE In the...
  19. acct098

    Monitoring Progress

    ...AO VARCHAR2(4) T_NUM VARCHAR2(12) EDATE COUNT(*) --------- ---------- 03-NOV-06 9029 07-NOV-06 8510 09-NOV-06 8976 14-NOV-06 9273 15-NOV-06 8810 16-NOV-06...
  20. acct098

    Create a spool file for each user

    LK Same concept different file. I can the the sql to just select a specific date (TDATE). Any ideas why? Set Pages 0 Feed Off Ver Off Term Off Trims On Lin 200 Spo C:/_AL_FILES/SQL/GLFCAT.SQL Prompt Set Pages 55 Feed On Ver On Term On Trims On Lin 200 Select 'Spo '||FUNDCAT||'.txt'||Chr(10)...

Part and Inventory Search

Back
Top