OLEDB Read Failed Error

[Anonymous]

I have the following Script:

When i  load the above script i get an OLEDB Read Failed error message.  What is wrong in the Script?

[Anonymous]

Thanks Antonio.  I am getting the following error message with the SQL statement:

[antoniotiman · Accepted solution]

SQL Select

Branch,[Retail Pharmacy],[Script Number],

Count(Distinct [Script Number]) as Rx

from PharmaMarketAudit.dbo.tblDatawarehouseConsolodatedCleanStage

Group By

Branch,

[Retail Pharmacy],

[Script Number];

[Anonymous]

Many thanks Antonio

[Anonymous]

Thanks Mayuresh