Viewing 15 posts - 1 through 15 (of 115 total)
Thanks for this useful information. And yes, I just reworked your response and it works fine. And yes, I am a programmer, not a DBA 🙂
June 3, 2019 at 3:05 pm
Thanks Sue. Using NT AUTHORITY\Authenticated Users seems to have worked
December 28, 2018 at 5:25 am
Thanks and I will try it out tomorrow morning
December 27, 2018 at 2:56 pm
Thanks, I will check that out
December 5, 2018 at 11:28 am
So for example, I have a list of Last Name, First Name, MI concatenated with Title (such as PhD, MD, CRNA, etc) and then concatenated again with specialty (like Cardiology,...
December 4, 2018 at 10:26 am
Yep. got it and thanks! Redownloading it brought up the options of components to install.
December 3, 2018 at 12:10 pm
And when I do that through the control panel, the Visual Studio installer comes up and under Data Tools, I do not have the option for Reporting Services.
December 3, 2018 at 11:55 am
It kind of helps, but I only have SSIS there. How do I get the rest of the SSDT features?
December 3, 2018 at 11:24 am
I have been in the IT world on both hardware and software for over 30 years now. Yes, I just turned 51 yesterday and an starting to count the years...
September 7, 2018 at 8:32 am
Yeah, Symplr sent me the data table dictionary and it is pretty massive. We need some licensing reports for our Pharmacy that we are running using the Cactus DB. I...
June 6, 2018 at 6:36 am
Thanks the for the information about LEFT join. I modified the query and it did populate with approximately 50 extra records.
June 6, 2018 at 6:06 am
Thanks so much! That worked. I have been working with SQL for nearly 20 years, but again, I don't author SQL scripts that much.
June 5, 2018 at 10:31 am
Okay, so if I have a list of 500 providers and let's take one, like Provider A. When I run the query, Provider A has TWO records because there is...
June 5, 2018 at 9:02 am
I am joining the License table based on Provider ID and the relationship is a one to many, however based on the license type (and for now there are two...
June 5, 2018 at 8:31 am
Interesting that this topic is resurfacing. My husband and I this morning were just discussing the same topic, as we are both gamers, and we saw a story about Activision...
October 18, 2017 at 5:20 am