Viewing 15 posts - 16 through 30 (of 120 total)
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
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...
September 29, 2017 at 6:16 am
June 20, 2017 at 8:11 am
June 20, 2017 at 7:45 am
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.
May 19, 2017 at 6:34 am
Actually I think after some advice from our DBA here and playing around, I did this and it works
Select * from (
December 5, 2016 at 8:10 am
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...
November 30, 2016 at 5:58 am
Nope, I did not mean to sound defensive in anyway at all and sorry if I came across that way
September 22, 2016 at 6:31 am
thanks for the response. I actually think it was the table that I was querying against as it stored millions of records. I changed to a different version...
September 22, 2016 at 5:59 am
Yep, it looks okay. In doing further investigation and trying to trace the issue through execution results, it looks like the permissions on the destination table changed somehow. ...
September 15, 2016 at 11:35 am
Nope, I deleted the whole Data flow, recreated it and still the same. And this is with a new refreshed tsv file too. I waited yesterday thinking maybe...
September 15, 2016 at 10:15 am