I was afraid you will be using the nodes.

Yes, function is a bit of an issue here - has to be a model in Java at the end, so either view or table.

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

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

• This reply was modified 3 years, 1 month ago by  BOR15K.

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

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.

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

I see! Thank you for the explanation, Jeffrey.

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

Steve, Jeffrey

Thank you both for such a great help! May I ask couple of more questions, please:

1. The real data I have seen may have over 20,000 barcodes per order...

Thank you, Steve. It is really a great solution, yet I cannot use fnTally function in this case. Simply not allowed.

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

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

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

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