linked server will always have that issue - what you need to do is to alleviate the problem.

when pulling data from Oracle to SQL one of the biggest issues is...

I assumed your company owned the code - should be easy to change it - and if not you can...

change the ID to be sequential - that will alleviate that issue.

both potentially - depending on your data that distinct may be processing results with thousands of duplicated values which require a sort to get the distinct.

exists will only see if...

possible way - but without a real execution plan of this with one of the "bad performance" queries we don't know if it is the best option

replace...

partially incorrect - reading the manual helps so do read the "Create table" statement on the manuals where you may learn something.

and having (max) data inrow is in some cases...

issue is not sql but with your code and project - dataadapter.Fill for some reason has been given the wrong database to connect to - that is what you need...

good to know how this is supposed to be used.

from what I know of Tableau using a SP will not work as they can't be joined as part of a...

does that code work when searching for submission ID 1000

output I get (based on the supplied input) is not quite what was mentioned above as being required

10004
10005
15001000
4NULL
54
12004

you sure that function is correct? you have

(@Exclude_For_Trans_Type_27 IS NULL AND (@Sample_Include_For_TType_27IS NULL OR T.Auto_ID = 27)))

but the variable isn't defined on the code  you supplied.

and how is the original...

• This reply was modified 4 years, 5 months ago by frederico_fonseca.

there may be a possible way to simplify this on your case - but depends on your data.

if there is only one and never more than 1 possible top level...

so if I got it correctly if a user "searches" for submission id 1500 then 4, 5, 1000, 1100, 1200 should be returned as being related - and on this...

If this is more than finding descendants and ascendants then a simple query will not be enough.

if you also need siblings (and/or descendants of ascendants / ascendants of descendants) then...

it is internet access issue - you may need to speak with your network/system admins to allow that server the required access to the internet to do this install.

It may...

see below.

cases below based on the code you supplied - will need to be adjusted 

see all comments below.

As your destination server is rather week using the...