0 Replies Latest reply: Jun 8, 2016 4:51 PM by Robert Winkel RSS

    can you create a microsoft excel OBDC query file (.dqy)

    Robert Winkel

      Can you use this type of file to extract your data in data load?

       

      SELECT "PhTheraChange"."PhNPI", "PhTheraChange"."GPIDrugGroup", "PhTheraChange"."GPIDrugClass", "PhTheraChange"."GPIDrugSubClass", "PhTheraChange"."GPIDrugNameCd", "PhTheraChange"."Product", "PhTheraChange"."TheraType", "PhTheraChange"."ReplaceNDC", "PhTheraChange"."NDC", "PhTheraChange"."Sig", "PhTheraChange"."ReplaceCCID", "PhTheraChange"."CCID", "PhTheraChange"."PhTCguid", "Physicians"."PhLName", "Physicians"."PhFName", "PhTheraChange"."InsID", "InsPlans"."InsName", "PhTheraChange"."FacID", "Facilities"."FacName", "FacGroupDefs"."FGName", "FacGroups"."FGID"   FROM   (((("Fac"."dbo"."PhTheraChange" "PhTheraChange" FULL OUTER JOIN "Fac"."dbo"."Physicians" "Physicians" ON "PhTheraChange"."PhNPI"="Physicians"."PhNPI") FULL OUTER JOIN "Fac"."dbo"."InsPlans" "InsPlans" ON "PhTheraChange"."InsID"="InsPlans"."InsID") INNER JOIN "Fac"."dbo"."Facilities" "Facilities" ON "PhTheraChange"."FacID"="Facilities"."FacID") INNER JOIN "Fac"."dbo"."FacGroups" "FacGroups" ON "PhTheraChange"."FacID"="FacGroups"."FacID") INNER JOIN "Fac"."dbo"."FacGroupDefs" "FacGroupDefs" ON "FacGroups"."FGID"="FacGroupDefs"."FGID"   WHERE   NOT ("PhTheraChange"."FacID"='mstr' OR "PhTheraChange"."FacID"='test') AND "FacGroups"."FGID"<>'CYCLE'   ORDER BY "FacGroupDefs"."FGName", "PhTheraChange"."FacID", "PhTheraChange"."PhNPI", "PhTheraChange"."GPIDrugGroup", "PhTheraChange"."GPIDrugClass", "PhTheraChange"."GPIDrugSubClass", "PhTheraChange"."GPIDrugNameCd", "PhTheraChange"."ReplaceNDC", "PhTheraChange"."InsID"