Search results for query: *

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

SELECT distinct SHRTCKG_CREDIT_HOURS , SHRTCKG_HOURS_ATTEMPTED, SHRTCKG_PIDM FROM SHRTCKG,SHRTCKN where SHRTCKG_TERM_CODE = '201809' and SHRTCKN_PIDM = SHRTCKG_PIDM and SHRTCKN_CRN = '91643' and SHRTCKG_CREDIT_HOURS = '1' and SHRTCKG_HOURS_ATTEMPTED = '1';

That doesn't resolve the issue I am having with update SQL that I am writing. The problem is since there is no from statement in my update syntax the script does not acknowledge the SFRSTCR table when running the update process. I am receiving an invalid identifier error for SFRSTCR_CRN.

Once I correct the statement, I am able to accurately select the fields I am updating.

Also, I need to remove the comma and SHRTCKG_CREDIT_HOURS = '0'[highlight yellow],[/highlight]

No. The from statement is missing a table SFRSTCR

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

I have two the field shown in example two is a datatype the field shown in example 1 is a concatenated field of the two datatypes listed of above.

I have attempted to add this the full formula above, but I am receiving an error to many arguments for the function. datetimevar st := datetime(currentdate, time(({AS_CATALOG_SCHEDULE.BEGIN_TIME1},"-")[1])); datetimevar end := datetime(currentdate...

I was just reading up on that function, but I don't think it will give me what I need. The field for days of the week are separate. AS_CATALOG_SCHEDULE.MONDAY_IND1 AS_CATALOG_SCHEDULE.TUESDAY_IND1 AS_CATALOG_SCHEDULE.WEDNESDAY_IND1 AS_CATALOG_SCHEDULE.THURSDAY_IND1...

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

Thank you I figured that out.

Also could get the same results if a I did a subreport formula?

I have attempted to add the nested if statement you provide, but I am receiving a " number, currency amount, Boolean, date, time string expected" error.

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