Recent content by Olivia123

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...

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

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

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

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

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

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

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

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...

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...

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...

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/...

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...

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...

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...