MEDITECH DR, NPR, MEDITECH Reporting, MEDITECH Reports, MEDITECH DR Reports, MEDITECH BI, MEDITECH Data Repository
I'm your host, John Sharpe, a MEDITECH Consultant living in Spokane, WA. Read more ...
Expand your network by connecting on these social media sites:
Sign up for the MEDITECH Reports Blog; details to attend MEDITECH workshops are sent out 1 week in advance to all MEDITECH Report blog subscribers.These MEDITECH Workshops are sponsored by Donna Carroll at the MEDITECH Community Bulletin
Ascii Table: For NPR Report Writer Loop Builder: For NPR Macros Key Codes: For CDS Attributes List Builder: For NPR Macros MT Report Names: For NPR Reports MT Structure Viewer: For Physicals Strings: Format & Sort
Current Articles | RSS Feed
Writing adhoc SQL to explore the MEDITECH DR Data Dictionary works for a while, but sooner or later you tire of re-writing the same SQL code and standardize on a query that works for 99% of your needs.
This stored procedure 'DrTableColumns_ByNprDpmField' is an example of SQL query I've implemented as an SQL stored procedure. This procedure accepts 3 parameters: DPM, Segment, and Field.
Execute the procedure and it returns this result.
The SQL to return this result wasn't more than a few lines, but anytime I can reduce the number of keystrokes as I write reports, I do. If you're interested, you can read more in the MEDITECH Community Bulletin: here.
Want an alert when the next post is published? Click the phone and Subscribe to the MEDITECH Reports Blog!
Allowed tags: <a> link, <b> bold, <i> italics
I'm your host, John Sharpe, a MEDITECH Consultant living in Spokane, WA. Read more ...