Displaying 1 result from an estimated 1 matches for "patient_episode".
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
...uot;XXXXX", case = "nochange", believeNRows = TRUE)
con<-odbcConnect(dsn=c("dwParadigm","Rpt_Paradigm","WC_Reporting")
contab<-sqlTables(con)
region<-sqlQuery(con,'SELECT DISTINCT dbo_PATIENT.PATIENT, dbo_CONTRACT.CONTRACT, dbo_PATIENT.PATIENT_EPISODE, dbo_PATIENT.LAST_NAME, dbo_PATIENT.FIRST_NAME, dbo_CONTRACT.CON_STATUS, dbo_CONTRACT.CON_NUMBER, dbo_PATIENT.STATE, dbo_REGION_TERR.OPS_REGION, dbo_REGION_TERR.SPG_TERR, Sum(dbo_Line.total_ln_paid_amount) AS SumOftotal_ln_paid_amount
FROM dbo_CONTRACT...