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 John Tel 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: Olivia123
  • Content: Threads
  • Order by date
  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...

    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 :)
  4. 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
  5. 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
  6. 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...
  7. 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 *...
  8. 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 *...
  9. 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...

Part and Inventory Search

Back
Top