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: *

  1. Olivia123

    Cognos 8...Can't connect Contect Store to MSQL 2005 Express databse

    I've installed Cognos 8 and MSSQL 2005 Express on my personal computer and cannot connect Content Store to MSSQL.. I've tried everything I was told... 1. Enable TCP/IP (1433) and Named Pipes in SQL Server, by default they are disabled (and restarted)..I'm using localhost 2.Created succesfully...
  2. Olivia123

    Delete a record

    Hello, I use SQL once in a while,so, I'm not too familiar with it.. I have a really easy question... I have a duplicate record , there is two now, exactly the same records, how would I delete just one, and leave the other one there....They are exactly the same ... Thanks
  3. Olivia123

    Ignore records...

    Maybe I dont need to use this in a CASE statement, please , let me know what would be the best way to ignore these records. Thank you again
  4. Olivia123

    Ignore records...

    I have this CASE statement and with these accts, with this Ent, and this desc I need to ignore, not to iclude the records...How would I write it? What to say after THEN? WHEN a.GL_ACC < '4001' AND A.GL_ENT = '2000' AND b.GLRD_DESC = 'NS' THEN Thank You Olivia :)
  5. Olivia123

    DATES

    Hello, How can I in this sql script subtract 7 days from the DATE_CREATED. SELECT * FROM F_ACCOUNTS WHERE TRUNC(date_created) = (SELECT TRUNC(MAX (date_created)) FROM F_ACCOUNTS) Thank you
  6. Olivia123

    Having trouble w/ NULL

    Thank you, the second one helped me out, I wasn't familiar with COALESCE :)
  7. Olivia123

    Having trouble w/ NULL

    Is there anyway I can set the null value as '0' or '1' ?
  8. Olivia123

    Having trouble w/ NULL

    I was wondering if I can wright something like this.... a.CALL_CC IS BETWEEN NULL AND b.CA_CC1 This is actually the logic that I need, but, it won't work , is there any other way I can wright it, and use this logic. Thank you
  9. Olivia123

    Help with reading ranges

    Hello,I have two tables ... Table_2 GLRD_ACCT \ GLRD_ACCT1\GLRD_CC\GLRD_CC1\GLRD_USER1\GLRD_DESC\GLRD_ENTITY 4001.........\..........4002........\.................\...................\ .....10.01.......\.........NS.......\...........1000...
  10. Olivia123

    to_number

    Hello, This is an exact copy and paste of my Function [CREATE OR REPLACE FUNCTION chckAccount( ACCOUNT NUMBER, CALLCENTER NUMBER, P_USR_NAME VARCHAR2) RETURN VARCHAR2ASV_ACCT...
  11. Olivia123

    to_number

    I've changed my Function can u please let me know what am I doing wrong, because still when I ran my Select statement and use the Function in it , it won't recognize the Function name..... Here is my function CREATE OR REPLACE FUNCTION chckAccount (a.table_2.KL_ACC NUMBER...
  12. Olivia123

    to_number

    Thanks again :) This my table_1, where I have my ranges... glrd_acct/glrd_acct1/glrd_cc/glrd_cc1/glrd_user1/code_desc 6401 / 6405/ 0/ 900/ 121.02/ SS 8000 / 8999/ 700/ 760/ 150/ CC 8000 / 8999/ 801/ 802/ 150/...
  13. Olivia123

    to_number

    This Function works when I run it, it has no errors... Then I try to use it in my query, and it wont work SELECT chckAccount(KL_ACC), KL_SA, KL_CC, KL_ENT, SUM(KL_AMT) FROM <<TABLE_1>>..... Basically KL_ACC and KL_CC are my transactional tables and I need it to...
  14. Olivia123

    Help with a Function

    Hey, Thank you so much for helping, I still don't really understand what you mean by (If they are the arguments you need to provide, then you need to figure out how to provide them)... Where it says ACCOUNT in the Function, I need it to understand that it is the same as KL_ACC, or CALLCENTER...
  15. Olivia123

    Help with a Function

    Hello, Thanks to everyone that replied, I really appriciate it... But I will use this Function for my ranges to be read automaticaly...I just have one more problem CREATE OR REPLACE FUNCTION chckAccount (ACCOUNT NUMBER, CALLCENTER NUMBER...
  16. Olivia123

    to_number

    Hey, You really helped me out last time, thank you so much. I was wondering if you can help me out this time..... I have this Function that I'll be using for my ranges to be read automaticaly... CREATE OR REPLACE FUNCTION chckAccount (ACCOUNT NUMBER, CALLCENTER NUMBER...
  17. Olivia123

    Help with a Function

    Hello, I need help to write a SQL Statement/ Function that would read this table below... glrd_acct*glrd_acct1*glrd_cc*glrd_cc1*glrd_user1*code_desc 6401 * 6405 * 1 * 900* 121.01 * SS 8000 * 8999 * 700 * 755 * 150 * AA 9100 * 9120 *...
  18. Olivia123

    Help to write a Function

    Hello, I need help to write a SQL Statement/ Function that would read this table below... glrd_acct*glrd_acct1*glrd_cc*glrd_cc1*glrd_user1*code_desc 6401 * 6405 * 1 * 900* 121.01 * SS 8000 * 8999 * 700 * 755 * 150 * AA 9100 * 9120 * A030 * A030 * 389.DUBU *...
  19. Olivia123

    IF ElseIF

    Hello, Im having trouble placing IF and ELSEIF in the right place. Basically I need IF "A" = 1000 then do this... ELSE IF "A"= 2000 then do this..... I have to add "IF" before CASE and the ELSEIF to continue with statement. This is what i have now.... SELECT * FROM ( a, b, c, d, CASE WHEN...
  20. Olivia123

    to_number

    Hey, I think I just confused you more than it really is. function NUMCHK (n varchar2) return number is number_hold number; begin number_hold := to_number(trim(n)); return number_hold; exception when others then return null; end...

Part and Inventory Search

Back
Top