hi lynn can u please try to help me

in that proc

...

plz watch the out put of both which i asked

anthony.green that was different concept and this was a different concept

in that concept i will provide parameter @memberid but...

thanks

lynn pettis,

anthony.green,

cap.hector

for your help

if u have time means

plz have look on this question

http://www.sqlservercentral.com/Forums/Topic1322880-391-1.aspx

and give some idea related to this

hi lynn pettis i think now u understand my concept

for example in web application if the sure want to view details or records from the table for a particular period of time ...

dmy format

for example

INSERT INTO [tblProductInfo] ([ProducttId],[ProjectId],[SaleMemberId],[SaleClosedPrice],[SaleDate])

value(1,1,1,1000,'1-04-2012')

(2,1,2,500,'04-06-2012')

...

ok Lynn Pettis no problem i will try complete my task of my own

hi Lynn Pettis did u get any idea about the mlm tree formation if u get any idea means just forward to...

in the out put column i have to get this value

commisson

60

10

...

sorry nothing else if a member sold a product means he will receive 6% comission

for...

the commission will be place depen upon closed price

from the closed price of the sale only the commission...

in final u just mentioned

CAST(REPLICATE(' | ', LevelNum - 1) + MemberName AS VARCHAR(100)) AS MemberName,

[Commission] = CASE WHEN LevelNum = 1 THEN 6 ELSE 2 END

i need ...