Can i update data extension with auto generated random value
I want to run an automation for adding random value into data extension field.
sql
Error in Create Mysql Procedure or Function
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:
MySQL Script for find finding missing entry from a specific group and then enter the missing row on that group
I have one table ClockIn which is as follows:
Query that provides the names of the recruiters that hire more than 3 employees, and the number of employees that were not hired by a recruiter
I’m a bit stuck on this question and was hoping for some help. Here’s where I’m at currently.
Nested or multiple case functions
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
How to use NOT IN in binary tree problem using MySQL
I am trying to solve this problem,
SQL: Combining WHERE, ORDER and LIMIT on 15 million+ row query
I have 2 tables, item and config.
Pass list of values to be inserted as parameter to stored procedure
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.
Unknown column in where clause when nested selection
I have to get results from different tables in one query. But got the unknown column error.
Convert text string in wrong format to date with in MySQL
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.
