2 Replies Latest reply: Feb 24, 2012 7:03 AM by chris goudy RSS

    Numeric to Text

    chris goudy

      I'm having trouble getting the Client data to execute in the script. Here is the script I used, but when I reload it says there is an error

       

      Client:

      SQL SELECT

            [ProfileNo],

            [PatientName],

            [PatientTelNo],

            [ContactName],

            [ContactTelNo],

            [ContactCellNo],

            [ContactAddress1],

            [ContactAddress2],

            [ContactAddress3],

            [CallIncrementFlag],

            [InitialCallDate],

            [RamsNo],

            [Notes],

        FROM [CCP_Compliance].[dbo].[ex_ProfileMaster];

       

      **************the entire script reads

       

       

      Pharmacy:

      SQL SELECT

           [ramsno],

           [PharmacyName]

        FROM [CCP_Compliance].[dbo].[ref_Pharmacies];

       

      Client:

      SQL SELECT

            [ProfileNo],

            [PatientName],

            [PatientTelNo],

            [ContactName],

            [ContactTelNo],

            [ContactCellNo],

            [ContactAddress1],

            [ContactAddress2],

            [ContactAddress3],

            [CallIncrementFlag],

            [InitialCallDate],

            [RamsNo],

            [Notes],

        FROM [CCP_Compliance].[dbo].[ex_ProfileMaster];

       

      LOAD agentcode,

           agentname,

           callduration,

           callid,

           id,

           profileno as Client,

           ramsno as 'Pharmacy Name',

           statedescription,

           timestamp

      FROM

      C:\Users\chrisg\Documents\CallLogs.qvd

      (qvd);