I’m using Toad for Data Analysts version 184.108.40.2061. If I enter the folloiwng into an editor window:
INNER JOIN JBIWarehouse_mf.dbo.dimProduct dp
ON di.DaxItemID = dp.ProductNum
dp.originid = ‘ECOM’
Then position the cursor after the SELECT statment and enter dp., as soon as I enter the asterisk, Toad replaces the asterisk with TWO asterisks. I’m not sure what Toad is tryin to do here. ** is not a valid tSQL statement (I’m querying SQL Server 2008). The only reliable way around this is to open an alternative editor, enter dp. in that editor and then cut and paste from that editor into Toad.
I’ve looked for an option that controls this, but the only thing I can find is the one about replacing * with field names which is not what I want.
Does anyone else have this issue? Any fix or workaround?
Thanks for the help.