2 Replies Latest reply: Jul 10, 2010 4:27 PM by GAPOWERS RSS

    Creating a new field by concatenating two field


      CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=HDW;Data Source=dvdb7;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WCORR896ZB9;Use Encryption for Data=False;Tag with column collation when possible=False]; SQL SELECT "ADMIT_ARRIVE_DATE" as Admit_Date, "DISCHARGE_DISPOSITION_DATE" as Disch_Date, FacilityId, "INSURANCE_ID", "PA_ACCOUNT_STATUS_ID" as STATUS, "PATIENT_ACCOUNT_NUMBER" as ACCT_NUM, "PATIENT_SERVICE_ID", "PATIENT_STATUS_ID", "TOTAL_ADJUSTMENTS" as AdjustmentTotal, "TOTAL_CHARGES" as Charges, "TOTAL_INTEREST", "TOTAL_PAYMENTS" as Receipts, "TOTAL_WRITEOFFS", "VISIT_ID" as VISIT, FAC_INS =concat(FacilityId,"INSURANCE_ID") FROM HDW.dbo."Aff_VISIT";


      Above is my select statement to being field from my SQL server. I need to create a distinct field by combining the FacilityID and the Insurance_ID. I different facilities that use the same code for different insurance names. My final QV will analyze each distinct insurance plan's performance.


      When I run this script, I get an syntax error.


      How can correct this so the field is available?