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.

It kind of helps, but I only have SSIS there.  How do I get the rest of the SSDT features?

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...

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...

Thanks the for the information about LEFT join.  I modified the query and it did populate with approximately 50 extra records.

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.

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...

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...

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...

Today's VR (AR) tech ala Halolens, Pokémon Go, Google Glass, etc is something I personally do not like, however I would love to live to see the day that I...

Yep, I don't know why I didn't think this way (feel stupid sometimes), but NULL values are not counted anyway so yes, thank you!  Things are good.

Actually I think after some advice from our DBA here and playing around, I did this and it works

Select * from (

SELECT ClientName

,Telephone

,apptdate

,ROW_NUMBER() over...

This topic is very timely and interesting as just yesterday I heard that the Breitbart company now wants to capitalize on working with data within the White House and the...