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

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

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

Hello Dwain,

maybe you can help me answer my other question, which might solve the problem, i am going to make a temp table, then insert the records I want from...

Hello everyone

thanks dwain for the correction, however I have tried what you have and came up with the same results for example:

if i do the rowid = row_Number() etc., but...

Hello Lynn,

thank you for the fast reply, sadly i removed the Go part and now it says:

"An error occured while the query design method was being saved. Incorrect Syntax Near...