-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am having trouble on running below Dynamic SQL query. Can someone have a look and troubleshoot what am I doing incorrectly? Also, is there any way I can able to print Dynamic SQL query? SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'sum(case when x.question_text = ''', question_text, ''' then x.answer_text…
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
