This is driving me pretty nuts but cannot get it to work.
I want to paste the following into a SQL query within R.
UKWinnersID<-c("'1WKX6'", "'ULTY8'", "'JNZX0'", "'8J4D8'",
"'KZJAJ0'", "'W8BH47'", "'CP8RPW9'", "'52TD5'", "'TLKV4'")
sqlQuery(myConn, paste("SELECT TOP 10000 [AxiomaDate]
,[RiskModelID] ,[AxiomaID],[Factor1],[Factor2],[Factor3]
FROM [PortfolioAnalytics].[Data_Axioma]
Where AxiomaID IN (",(paste(UKWinnersID, collapse = ","),")")))
AxiomaID IN ('1WKX6', 'ULTY8', 'JNZX0', '8J4D8',
'KZJAJ0', 'W8BH47', 'CP8RPW9', '52TD5', 'TLKV4')
I'm not able to recreate your exact output. Try the following; it produces the SQL code I would expect.
UKWinnersID<-c("'1WKX6'", "'ULTY8'", "'JNZX0'", "'8J4D8'",
"'KZJAJ0'", "'W8BH47'", "'CP8RPW9'", "'52TD5'", "'TLKV4'")
sqlQuery(myConn, paste("SELECT TOP 10000 [AxiomaDate]
,[RiskModelID] ,[AxiomaID],[Factor1],[Factor2],[Factor3]
FROM [PortfolioAnalytics].[Data_Axioma]
Where AxiomaID IN (",paste(UKWinnersID, collapse = ","),")"))