Comments
-
Thank You MarkSnodgrass for your suggestion. Unfortunately its not working as expected. Basically I want to update a column which I have added in SQL table created in this Data Flow "xxtm_demand". Seems the issue is with UPDATE statement as even below is not working irrespective of any Cursor. CREATE PROCEDURE GetAllDates…
-
Sorry for the unformatted MySQL Code. Please find below in a formatted one CREATE PROCEDURE GetAllDates () BEGIN DECLARE l_cnt INTEGER DEFAULT 1; DECLARE l_region VARCHAR(10); DECLARE l_org VARCHAR(3); DECLARE l_ordered_item VARCHAR(100); DECLARE l_date DATE; DECLARE l_group_sequence INTEGER DEFAULT 0; DECLARE C_DATE…
