Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Subquery Needed?
- Using the sql script below in SQL Query Analyzer to determine the member’s primary care physician, the physician who provided the service and the medical group IPA of the primary care physician.Select t.MEMBER_NBR, pr.PROV_ID as SvcProviderID, pr.PROV_RELATION_PROV_ID as PCPProvID,pti.PROVIDER_TAX_ID -- Is this the tax id of the PCP?,case...
- Tags: lacwill@..., physician, pti.PROVIDER_TAX_ID, medical group, pr.PROV_RELATION_PROV_ID, provider_id
- Discussion threads 2007-08-03
- ADO_Append Access Table with External Oracle Data
- I have been trying to use the following to append Oracle data to an Access table without much success at all! The error message that is received is "Invalid Precision For Decimal Data Type."Any insight as to the possible reason/resolution would be sincerely appreciated.Thank you in advance!Dim Rs...
- Tags: lacwill@..., Microsoft Access, Oracle Corp., pe.expected_reimbursement, pe.total_payment, software
- Discussion threads 2005-03-16
- Dynamic Rpt_Worksheet Change Event
- Currently, I have an Excel Spreadsheet that I plan to populate via a MS Query that "pulls" data from an Oracle Database (version 8.1.7). In essence, the spreadsheet is setup to provide a "dynamic" Variance Report that will be used to monitor underpaid customer accounts. The report will...
- Tags: lacwill@..., main worksheet, MS Query, spreadsheet, windows, worksheet
- Discussion threads 2004-12-31
- << Previous
- page 1 of 1
- Next >>