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 Mike Lewis 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. Healthc12

    creation of temp table within a proc ISSue

    How do I load the following into the table? SELECT CASE WHEN ttp.TCV_FACILITY_YN = 'Y' AND ttp.TCV_TYPE = 'R' AND ttp.TCV_PRIMARY_YN = 'Y' THEN 'FACILITY' WHEN ttp.TCV_FACILITY_YN = 'N' AND ttp.TCV_TYPE...
  2. Healthc12

    creation of temp table within a proc ISSue

    Thanks, but now I need to utilize the table. SELECT CASE WHEN ttp.TCV_FACILITY_YN = 'Y' AND ttp.TCV_TYPE = 'R' AND ttp.TCV_PRIMARY_YN = 'Y' THEN 'FACILITY' WHEN ttp.TCV_FACILITY_YN = 'N' AND ttp.TCV_TYPE...
  3. Healthc12

    Issue with create global temporary table

    Thanks
  4. Healthc12

    creation of temp table within a proc ISSue

    create or replace PROCEDURE BANDIT( rc1 in out spm.rctl) IS BEGIN open rc1 for "CREATE GLOBAL TEMP TABLE Bandi" (TA_SERVICING_TYPE CHAR(2), TA_TCV_PVD_UID_PHYS NUMBER(10,0), TA_tcm_uid NUMBER(10,0), TA_OPP_LOB_CODE...
  5. Healthc12

    Issue with create global temporary table

    Error starting at line 1 in command: create global temporary table inpatient_census (ic_servicing_type vchar(1) null, ic_member_county vchar2(50) null, ic_icd9 vchar2(11) null), ic_primary_diagnsois vchar2(50) null, ic_member_dob date, ic_member_name vchar2(64) null...
  6. Healthc12

    Crystal Parm Question

    Using Crystal Reports 2008, I have setup a parm that is a multiple selection, that parts is done. What I can not remember is how to handle the Report Selection area for a Multiple selection Parm. Thanks in Advance!
  7. Healthc12

    Create a procedure and pass a date with out using a cursor?

    Current Code is create or replace PROCEDURE APPEALS( Selected_EMPLOYEE in STF_STAFF.STF_FORMATTED_NAME%TYPE, APPEAL_TYPE in MAP_MEM_APPEAL.MAP_APPEAL_TYPE%TYPE, APPEAL_STATUS in MAP_MEM_APPEAL.MAP_APPEAL_STATUS%TYPE, rc1 in out spm.rctl) IS BEGIN open rc1 for Now I need to...

Part and Inventory Search

Back
Top