How do you do a parameter query when not using Microsoft Query?
I've been scouring the internet for the better part of a week trying to figure this out, so I'm hoping there's an Excel/data ninja here that can help. Problem: I have several SQL queries embedded in my workbook, but need the end user to be able to pass values from cells to the query. For the most part, it'll be a couple of simple values, such as start date, end date, and username. Most of the solutions I've found say to go to Connection Properties > Definitions and add parameters, then add them to the query at the bottom of the box, but this field is always greyed out for me - whether it's regarding a Query or a connection. Additionally, the query I'm running is a monster (I'm trying to make the server do the processing rather than Excel on my local machine), so I need a solution that lets me pass values to a complex query, not just a single table. This can't be very difficult, but I can't for the life of me get any of the answers I've found to work. Also, many of the answers I've found on StackOverflow and other forums are 6+ years old. Attempted Solutions: This similar post was answered by telling the user to add parameters in the Connection Properties > Definitions> Command Text box. When I go there, that entire tab is grayed out. I've found ways to setup parameters, but can't figure out how to add them to the query without kicking a SQL error at runtime. This support.office.com page has instructions that should be valid for my version of Excel (2016), but again, they suggest adding parameters and the entire Definitions tab is grayed out. (Also, the images in this page show the ribbon/icons with a blue background, which is from an older version of Excel. So, something was updated?) This post has what looks like the answer, but again, they're trying to edit the query in the Definitions tab, which I've also seen solutions that involved entering a string of code that looked like VBA code into the query, but those would always just cause syntax errors. I don't have any examples of these handy. What I'm hoping for: I would be eternally grateful for a simple explanation as to why the Definition tab is always grayed out, and a guide on how to make this work. I'm running Excel 2016 (Office365) and the SQL Server 2008. Thanks in advance!Shelly's Take on… new MS Teams Firstline workers features for Healthcare
The recent announcements by Emma Williams, Corp Vise President of Modern Workplace Verticals, around new Firstline Worker features in MS Teams, is exciting for many organization and industries across the country, but I wanted to call out a few features that are revolutionary for Health Providers. To see the full original post, please read here.How MS Teams Helps Reduce the Average Length of Stay!
By reducing the average length of stay or eliminating avoidable days everyone wins! Patients get to go home to be with their families faster, nurses can free up a bed for someone who really needs it, and hospital systems can reduce the cost of care!Shelly's Take on... How Health Providers can Close the Communication Gap Around Care
I hope that you got a chance to read my last blog, if not please check it out here as it talks about all the latest and greatest announcements from MS Ignite. MS Teams is adding features and capabilities at lightning speed and many of these are benefiting Health and Life Sciences customers. Features like secure messaging, image annotation and care coordination templates.
