Cool thanks Manual, that almost has it, except for the Last parent, parent 3, the parent shows up after the child, so its:

Child 3, 1

Parent 3, 3

need it

Parent 3,...

sorry luis and everyone, here it is below:

create table #InformationStuff

(

ID int,

ParentID int,

DescriptionInfo varchar(200)

)

insert into #InformationStuff(ID,ParentID,DescriptionInfo)

values(1,null,Parent1)

insert into #InformationStuff(ID,ParentID,DescriptionInfo)

values(2,null,Parent2)

insert into...

Jason, thank you, and no prob, any help or assistance would be great, no matter how long it takes, if anything, you and everyone on this forum have been a...

Jason... DANG exactly!!!

except i think you have this part as well, IF the part such as an example: for the scooter, if you dont have enough scooters to meet the...

THANK YOU JAYANTH!

yup that worked 🙂 you da man 🙂

thank you both again for your help, i found this article that helped me the rest of the way:

http://sqlblog.com/blogs/alberto_ferrari/archive/2011/02/15/powerpivot-and-parent-child-hierarchies.aspx

hope it helps others as well. but thank you again both of...

thank you serg-52, and jeff.

thanks to you both I am all that close to getting my objective done.

now that I have the query I want it, or maybe I do,...

sorry about that,

let me start with this:

create table #table_name

(

partnum varchar(10),

Mpartnum varchar(20),

typecode varchar(1000)

)

insert into #table_name(partnum,Mpartnum,typecode)

values('bike10','tires2','P')

insert into #table_name(partnum,Mpartnum,typecode)

values('bike10','Handle','P')

insert into #table_name(partnum,Mpartnum,typecode)

values('tires2','plastic','P')

insert into #table_name(partnum,Mpartnum,typecode)

values('plastic',' ','M')

;WITH info

as

(

select *

,0 as [Level]

,Cast(Mpartnum as...

OK I found my problem, however definitely need your guys help, so here is the correct code:

;WITH Info

as

(

select distinct pm.company,jh.ProjectID,pm.PartNum,p.PartDescription,pm.MtlPartNum

,COALESCE(pq.OnHandQty,0.00) OnHandQty

,COALESCE(od.OrderQty,0.00) OrderQty

,SUM(jm.RequiredQty) RequiredQty,p.TypeCode

,0 as [Level]

,Cast(pm.Partnum as Varchar(255)) as [Path]

from erp.PartMtl...

Yes they are very small, but very frequent, so, any help or answers to my question? what do you think?

thanks in advanced 🙂

Cool sorry for the confusion, yes page not page file, also one other question in regards to heaps and clustered index, the difference between the clustered pages and heap pages...

Just a quick update/correction, the url above doesnt work when you remove the ssrs server, however this does:

http://sgisqlprod02/Reports_SGI_REPORTS/Pages/%3Ca%20href=%22http://www.treasury.gov/ofac/downloads/t11sdn.pdf#Khan, Farhan"></a>

so if you remove from http://sgisqlprod02 all the way to %20href=%22, then...

Solved problem, what i did was instead of CTE used a temp table then I queried.

Thank you anyways 🙂

Hello,

I am getting close, but my query will not show the First Names from new customers table, what it will show is "FirstName" all the rows, which i want to...

sorry all, my fault, yes i definitly want to say dwain solved the problem, when i did it, i was doing it on the same table X(, again my fault,...