Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Notes shouldn't have a comma
Wow, silly mistake.
Thanks