Viewing 15 posts - 1 through 15 (of 221 total)
You're getting the duplicates because M2 has two parents -- P2 & P3. If you don't care about that and need the single row for each such case you'll...
June 10, 2022 at 8:03 am
At a minimum, don't allow a mobile phone app the see location data unless it really needs it (ie: web browsers, hotel reservations, social media, etc.). Sure, there may...
October 5, 2021 at 2:45 pm
I am not arguing nor disapproving anyone and fully appreciate the time people took to reply.
My concern was if the proposed solution, with several SELECT statements from the same table,...
September 16, 2021 at 10:19 am
Thank you for posting your solutions, I just wonder how those multiple SELECT statements will affect the server, when the real tables will be very big >1M each.
September 16, 2021 at 8:34 am
Yes, I also thought about it, but the following example shows it doesn't matter - SQL Server implicitly converts NULL to the correct type, no?
DECLARE @t AS...
January 13, 2021 at 2:47 pm
I see! Thank you for the explanation, Jeffrey.
January 11, 2021 at 9:33 pm
Thank you, Jeffrey
Much appreciated. Will now read more to understand why adding only three tables significantly increased the result set - I am not well familiar with
Select t.n...
January 11, 2021 at 7:44 pm
Steve, Jeffrey
Thank you both for such a great help! May I ask couple of more questions, please:
January 11, 2021 at 7:16 pm
Thank you, Steve. It is really a great solution, yet I cannot use fnTally function in this case. Simply not allowed.
January 11, 2021 at 5:26 pm
Thank you, Mike01
When I run your example I only receive one line per type, as GROUP BY expected to behave, where what I need is sequences as in my expected...
January 11, 2021 at 2:11 pm
If you post screenshots of your DB connection manager settings and of the OLEDB source config, we should be able to work out what is going wrong.
Unfortunately, the error...
October 5, 2020 at 2:00 pm
Thank you for the replies. I have tried OLE DB Source, but it failed on preview. I do see the result if I run a simple SELECT myClumn...
October 5, 2020 at 1:54 pm
Thank you for the replies. I have tried OLE DB Source, but it failed on preview. I do see the result if I run a simple SELECT myClumn FROM myTable,...
October 5, 2020 at 1:27 pm
The solution for anyone, who might run into the same issue is to place double quotes on the element with the dot, so it works perfect for me now, thank...
September 30, 2020 at 3:12 pm
I can't keep on giving answers on moving goal posts. I have shown how you would do this, I will leave it to you to implement.
JSON_VALUE(v.value, '$.fields.System.State.newValue')
will not...
September 30, 2020 at 2:54 pm
Viewing 15 posts - 1 through 15 (of 221 total)