[R] help with RODBC

Alemu Tadesse alemu.tadesse at gmail.com
Thu Mar 5 02:46:23 CET 2015


I want to apply  the following query to my database.

P2<-sqlQuery(ch1,'select *,
      TimeStamp_Local,
      ref_density,
      ref_dewpoint,
      ref_dir,
      ref_precip,
      ref_press,
      ref_rh,
      ref_snowfall,
      ref_snowdepth,
      ref_temperature_avg,
      ref_temperature_max,
      ref_temperature_min,
      ref_ws_avg,
      ref_ws_max,
      ref_wetbulb
  FROM ASOS.dbo.DailyData DD
  left outer join ASOS.dbo.ASOS_MetaData MD on MD.WBAN = DD.WBAN
where CallSign = 'BOS' order by TimeStamp_Local ASC')

where ch1 <- odbcConnect(dsn="SQLBI01", uid="DataPull", pwd="PullData")

in R (RODBC). I am running into the following error

Error: unexpected symbol in:
"  left outer join ASOS.dbo.ASOS_MetaData MD on MD.WBAN = DD.WBAN,
where CallSign = 'BOS"

I don't know why

Thanks,

Alemu

	[[alternative HTML version deleted]]



More information about the R-help mailing list