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

Destination Table has only 3 Indexes,

One Column store Index

is this a clustered or non clustered columnstore?

and how many rows on that table - you did mention that source table had...

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

more details required - DDL for source table and destination table please - including ALL indexes (and triggers on destination if applicable)

And please do post the powershell script - at...

and is destination using fast load? and does destination table have any indexes? and is the destination database in full , bulk or simple recovery mode?

also, and this is something...

using the bulk insert option works fine (in SQL 2016)

the openrowset I didn't manage to make it work - but didn't spend too much time on it either.

            
May 31, 2021 at 6:06 pm
            
#3890288

            
            
                                                
        

can you post a sample file so we can try it?

and what happens if you change the following to nvarchar - with (SourceFile varchar(100), [Comment-dan] varchar(100)) as hygg

kick off the install as an administrator explicitly - right click and "run as administrator"