I want to run an automation for adding random value into data extension field.
I tried many times to create mysql procedure or function but failed all my tries!
This is the SQL statements (run without error as sql query) that I want to make it as procedure or function:
I have one table ClockIn which is as follows:
I’m a bit stuck on this question and was hoping for some help. Here’s where I’m at currently.
I am trying to do a nested case when query. My table has ID, code1 and code2 columns.
create table as select ID, code1 case when code1 is not null then 'yes' else (select code2, case when code 2 is not null then 'no' else 'NA' from table) from table
I am trying to solve this problem,
I have 2 tables,
I have this stored procedure in MySQL version 5.7. If I want to create n elements it would be much faster to insert n elements in one statement two times rather than call the stored procedure n times.
I have to get results from different tables in one query. But got the unknown column error.
I have this sql table in which I have a column with dates, but they are text strings and they are not in YYYY-MM-DD format. My dates are in DD/MM/YYYY.