This is my first post. I program for a large hospital. Been a programmer for 30+ years! But I'm a Cobol/MVS/CICS/etc.. programmer who works on some servers as well (Report2Web and now Linux!)
Well we have some super applications coming up and need SQL skills.
I have Microsoft SQL Server Management Express Studio on my pc and I've made tables for ICD9 and ICD10 comparison.
Now the question... besides scripts to load and run on the server via the Server Management Studio is there any way to compile these and run as modules? How would I set up ways for users to run their own reports I've developed?
I've done this with Freebasic and bat files but never on a SQL database and I know of no way to get a bat file to execute SQL scripts!
What sort of reports are they? One method I've used quite a lot recently - but this is for daily reports to DBAs - is running Powershell scripts , which manage the connection to the database, execute the code , and then output the report to a html and email them. To create this method - does require some Powershell knowledge.