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, 3 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, 4 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