ChatterBox Member

Comments

  • I changed the datatype of the OpportunityCloseDate column, removed nulls by assigning now() as default; also tried making both of them TimeStamp. This is the error: Data truncated: Incorrect datetime value: '2068-03-12 00:00:00' for column 'OpportunityCloseDate'. Could you think of any other possibility please ?
    in Data truncated: Incorrect TimeStamp Comment by ChatterBox March 2017
  • Thank you. This helped me get to the next step in solving the problem ?
    in SQL stored procedure does not work Comment by ChatterBox February 2017
  • Yes, it works now. I was trying to select from a table and insert into the same one. Creating a temporary table and selecting from it worked. Thank you.
    in With clause CTE redshift issue Comment by ChatterBox February 2017
  • Thank you Aaron. Is there any other way to achieve this objective apart from procedures in MySql. The objective is to populate the table with 12 rows (with split revenue) based on a revenue record which meets a certain business criteria. Following is the piece of Mysql procedure I've used: This doesn't give an error, but…
    in With clause CTE redshift issue Comment by ChatterBox February 2017
  • Hi, I'm working exactly on the same business requirement. The data sits in Salesforce, and I'm using a connector to pull it into Domo and then manipulate it. But, the problem is , I'm trying to create a dataflow to run stored procedure. However, Domo wouldn't execute the code and keeps throwing an error at variable…
    in Table Variables in Workbench Comment by ChatterBox February 2017
Default Avatar