Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Apr 2010 @ 14:15:21 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Convert Access IIF to Teradata
 
From:   Good, Ken

     SELECT TPTABLES_iSEEKSchoolCrosswalk.iSEEKSchoolID,
     CRTABLES_CRProgramMeasureNew.ProgramCode,
     CRTABLES_CRProgramMeasureNew.ProgramTitle,
     CRTABLES_CRProgramMeasureNew.AwardCode,
     WIATABLES_WIACertificationOld.WIACertificationFlag,
     Case When AggregationCode = "M" Then "Y" Else "N" End AS AggregationFlag, Case When
     ProgramGraduateCount < 6 Then 1 Else ProgramGraduateCount End As PGC, Case When
     ProgramGraduateCount < 6 Then Null Else SupplementalEPRate End As EPR, Case When
     ProgramGraduateCount < 6 Then Null Else SupplementalEPRCount End As EPRC, Case When
     GWCount < 6 Then Null Else GraduateWages End As GW, Case When GWCount < 6 Then 1 Else
     GWCount End As GWC, Case When EPRCount < 6 Then Null Else EmploymentRetentionRate End As
     ERR, Case When EPRCount < 6 Then Null Else ERRCount End As ERRN, Case When EPRCount < 6
     Then 1 Else EPRCount End As ERRD, Case When RGWCount < 6 Then Null Else
     RetainedGraduateWages End As RGW, Case When RGWCount < 6 Then 1 Else RGWCount End As
     RGWC, Case When TYRRDenominator < 6 Then Null Else TwoYearRetentionRate End As TYRR, Case
     When TYRRDenominator < 6 Then Null Else TYRRNumerator End AS TYRRN, Case When
     TYRRDenominator < 6 Then 1 Else TYRRDenominator End AS TYRRD, Case When TYGWCount < 6
     Then Null Else TwoYearGraduateWages End AS TYGW, Case When TYGWCount < 6 Then 1 Else
     TYGWCount End AS TYGWC, CRTABLES_CRProgramMeasureNew.SupplementalFlag,
     CRTABLES_CRProgramMeasureNew.ICRNumerator,
     CRTABLES_CRProgramMeasureNew.ICRDenominator,
     CRTABLES_CRProgramMeasureNew.RelatedEmploymentRate,
     CRTABLES_CRProgramMeasureNew.RERNumerator,
     CRTABLES_CRProgramMeasureNew.RERDenominator,
     CRTABLES_CRProgramMeasureNew.TotalTuition,
     CRTABLES_CRProgramMeasureNew.FY
     FROM (TPTABLES_iSEEKSchoolCrosswalk INNER JOIN CRTABLES_CRProgramMeasureNew ON
     (TPTABLES_iSEEKSchoolCrosswalk.CampusID =
     CRTABLES_CRProgramMeasureNew.CampusID) AND (TPTABLES_iSEEKSchoolCrosswalk.InstitutionID =
     CRTABLES_CRProgramMeasureNew.InstitutionID)) INNER JOIN WIATABLES_WIACertificationOld ON
     (CRTABLES_CRProgramMeasureNew.AwardCode =
     WIATABLES_WIACertificationOld.AwardCode) AND (CRTABLES_CRProgramMeasureNew.ProgramTitle =
     WIATABLES_WIACertificationOld.ProgramTitle) AND (CRTABLES_CRProgramMeasureNew.ProgramCode =
     WIATABLES_WIACertificationOld.ProgramCode) AND
     (CRTABLES_CRProgramMeasureNew.InstitutionID =
     WIATABLES_WIACertificationOld.InstitutionID)
     ORDER BY TPTABLES_iSEEKSchoolCrosswalk.iSEEKSchoolID;

Kenneth M. Good, BCIS, MIT
State of Michigan/DTMB/Infrastructure Services Data Center Services/Mainframe Services
Teradata Support



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019