I am attempting to pass a column from another table as an argument to a stored procedure. When the procedure takes only one parameter, this works beautifully. However, when the procedure takes two parameters, I am getting a column not found error. For example:
The above query returns what I would expect. The date_dimension.full_date column is recognized and I get a row back from the procedure for every date in my date_dimension in the given date range. However,
Gives me the error Error: SQL Anywhere Error -143: Column 'full_date' not found SQLState: 52003 ErrorCode: 207 I have tried qualifying and not qualifying full_date, as well as aliasing the date_dimension table. Each time I get the same results. Can I pass multiple parameters using a lateral procedure call? IF so, how? Any help would be appreciated. Thanks! |
Did you try with CROSS APPLY / OUTER APPLY instead of LATERAL?