Yes, exactly. If OP needs more levels we need more info what...

eut.kop (11/26/2015)

---

I wish to have something similar (also the layout should reflect the hierarchical tree)

horror

| titolo 1

| titolo 2

fantascienza

...

itortu (11/25/2015)

---

The current output record for type Cash Management Services and sub type One Card is the one actual record, all the other records for type Cash Management Services, are...

Both output_desired.txt and current_output.txt show 16 rows and have the same projection on (RelationshipTypeName, RelationshipSubTypeName ). What's wrong?

And, depending on requirements if you need contacts with no relevant addresses too, change CROSS APPLY to OUTER APPLY.

Ok, you need to decide, which of possible relevant Addresses is first

SELECT C.ContactID, C.PostalName, Addresses.AddressID, Addresses.CompanyName

FROM Contacts C

CROSS APPLY(

SELECT TOP(1) *

FROM Addresses A

WHERE C.ContactID=A.ContactID AND A.CompanyName IS...

jon.clay 91459 (11/24/2015)

---

Hi all

Thanks for your continued help (I know that it's probably like pulling teeth!).

Attached are two text files showing the relevant table scripts as requested (I'm unable to...

Fill() method returns number of rows successfully added to or refreshed. So if you need to know exactly the number of rows fetch by Fill() (no matter if dt has...

OK try this. We just need remember leaf's parent, start generating results at the leaf level contrary to level+1 in previous script and adjust final product assignment.

CREATE TABLE...

Then original

SELECT 'BS004','Packaged RTD Coffee','BC03',6

will contradict the query result

BS004 BS004d01 Packaged RTD Coffee6

Is it...

UNION ALL should perfom better

...

select *

from t2

union all

select t1.*

from t1

join t2 on t1.updatedate > '2015-07-30' and t2.rn=t1.rn+1;

If i've got right

create table #test (id integer

,start datetime

,enddate datetime

,p1 integer

,p2 varchar(20)

,updatedate datetime)

insert into #test

values (3144187, '2015-07-01...

Using SQL generate a rowset containing all needed bcp commands and save it to a file.

Create vbscript kind of https://gallery.technet.microsoft.com/scriptcenter/32e0146a-83fc-4ee1-af7b-52a57d57466c to run commands from file in parallel using WScript.Shell's...

You have alredy used one of DVM above.

Conserning possible disk problems see scripts in http://www.databasejournal.com/features/mssql/finding-the-source-of-your-sql-server-io.html

Jack Corbett (11/18/2015)[hr

Putting the criteria in addition to the JOIN criteria in the WHERE clause in an OUTER JOIN vs in the ON clause results in a different...