I removed the whitespace and tried in both RNotebook and RMarkdown and it didn't work. I am inclined to think I may be doing something wrong.
---
title: "R Notebook"
output: html_notebook
---
```{r}
library(odbc)
con <- dbConnect(odbc(), Driver = "SQL Server", Server = "prodedw2",
trusted_connection = TRUE)
```
```{sql, connection=con}
select * from table
```
I tried it on the database, schema and table levels neither worked. I even tested it on a where clause and it still didn't work.
Thanks for your help in advance.