Note on using T-SQL via R and ODBC

Reminder to self: when trying to query data into R using an existing SQL script that uses T-SQL to access data in Microsoft SQL Server, add SET NOCOUNT ON; to the beginning of the script, then add SET NOCOUNT OFF before the last select statement (the query returning the data of interest). If this is not done, an empty is returned instead.