like this only i transfer data lynn for the first table

insert into [dbo].[tblSpace] (MemberId, AdSpaceName, TotalBlocks, PaymentType)

SELECT

...

for example

here i inserted five value form the source table for example iam start in from the of the first table to...

thanks lynn it was working fine thanks a lot

sorry no thanks i just found the solution when i select system database

hi saggi

follow this step mentioned in the website i hope it help u

...

thanks

Jeff Moden,

Lynn Pettis

for giving new idea to me

i used your function and i solved my problem

declare @temptable2 table (MainCategory varchar(200),SecondLevelCategory varchar(200),ThirdLevelCategory varchar(200) )

;WITH Cte AS (

select

distinct...

i used this way

Create table #temptable2 (firstlevel varchar(200),ThirdLevel varchar(8000) ) ;

insert into #temptable2 (firstlevel,ThirdLevel ) VALUES ('count1','serv,dan,ton');

insert into #temptable2 (firstlevel,ThirdLevel ) VALUES ('count2','wers,tdan,tondrer,fhhgj,tern') ;

WITH Cte AS (

...

J Livingston SQL your proc was working fine and i am not finding exact member level of that...

this is question which u asked

Level Payout%

X-3 2% --The person below reports to this person and this person gets 2% of the sale...

hi

J Livingston

sorry for the twodays i was admitted in a hospital due to an injury on my right leg now only i came...

thanks lynn pettis

...

i just tried like this

;WITH MemberAndParent

AS (

SELECT m.MemberID, m.Name AS MemberName, r.ParentId

FROM tblMembers m

LEFT JOIN

tblMembersRelation r

ON r.MemberID = m.MemberID

),

Hierarchy

AS (

SELECT ParentId, MemberID, 0 AS LevelNum, MemberName, CAST(MemberName AS VARCHAR(1000))...

can any one plz try to help me