With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Is there any way I can innerjoin the following with the keyidentifiers only something like below:
select KeyIdentifiers.GPIDrugGroup, facname,reorders.RoNo,LastRxNo,Qty,dayssupply,reorders.ndc, cutoffdt,DrugLabelName,patlname+', '+PatFName PatName,p.NsID,bed,room,PhName ,d.ExpandedSig,reorders.lastfilldt,reorders.OrigDt,REORDERS.CutoffDt from Reorders left join KeyIdentifiers on reorders.NDC = KeyIdentifiers.NDC left join Facilities on Reorders.FacID = Facilities.FacID left join Patients p on reorders.PatID = p.PatID and reorders.FacID = p.FacID left JOIN "FwReports"."dbo"."vwReorderDirectionsExpandedSig" d on Reorders.RoNo = d.RoNo and reorders.PatID = d.PatID where reorders.FacID in('292')and (KeyIdentifiers."GPIDrugGroup"='57') and (reorders.CutoffDt is null or reorders.CutoffDt >GETDATE()) order by PatName
and in my select I be able to select GPIDrugGroups.groupname along with other fields
INNER JOIN "FwReports"."dbo"."GPIDrugGroups" "GPIDrugGroups" ON "KeyIdentifiers"."GPIDrugGroup"="GPIDrugGroups"."GPIDrugGroup"
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL SERVER 2008 R2 Could not obtain information about Windows NT group/user||5||55|
|Check ALL SP in database make sure there are no errors||17||60|
|How come this XML node is not read?||3||28|
|Checking for column changes SQL 2014||4||21|