'Reading multiple .Rmd scripts including SQL-queries from a separate .Rmd script

I have created a .Rmd script where I try to read multiple external .Rmd scripts that includes a combination of R and SQL syntax. For this I tried to use:

rmarkdown::render("my_script.Rmd")

However, this stops at the second SQL query within the first .Rmd script being read, which does not happen if I read that .Rmd script indiviually.

Anyone who knows how/if this problem can be solved. Can unfortunately not provide a reproducible example for this problem.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source