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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Having issue with ORA 00920. sql works when run seperately
select distinct spriden_id, spriden_last_name, Spriden_first_name, Sfrstcr_term_code, SFRSTCR_CRN, SFRSTCR_GRDE_CODE, GRDE_CODE_FINAL from spriden, sfrstcr left join (select shrtckn_pidm, SHRTCKG_GRDE_CODE_FINAL as GRDE_CODE_FINAL from shrtckn, shrtckg where SHRTCKN_PIDM = SHRTCKG_PIDM...- DeShaun
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Mutiple Where table in Update/Set
I am writing the current update SQL I am trying to update a field but the where requirements are from multiple table. I have tried a join and ON statement, but the error I receive is missing SET keyword update SHRTCKG set SHRTCKG_CREDIT_HOURS = '1', SHRTCKG_HOURS_ATTEMPTED = '1' where...- DeShaun
- Thread
- Replies: 10
- Forum: Oracle: All versions
-
Academic Scheduler Need to identify differences in meeting Patterns
I need assistance with with writing or script or creating formula fields that would help me to quickly identify schedule offenses by meeting patterns days and times. The goal is to identify the following. If day is MWF the course time should be 50mins If day is TR the course time should be 75mins- DeShaun
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Show available rooms for null values
Hello, I am needing some help writing a crystal report formula to pull null values for availability. I am an academic scheduler and I would like to be able to pull a list of available classes by term. I have attempted to write the following formula: if (isnull ({room})) and If ({time} =...- DeShaun
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
