Would it gains us anytime to shrink the transaction log prior to the backup?

They are using ArcServe agent to backup it up

i actually just completed creating several diagrams. They have Foreign Keys and everything:). I need to find Visio then.

I think I have it narrowed down to this statement:

---- Return member

SELECT A.DownLineLevel

--,C.BumpUpDate

,CAST(CONVERT(NVARCHAR(MAX),A.ConsultantID)AS INT) as ConsultantID

,UPPER(RTRIM(A.ConsultantName)) AS ConsultantName

,C.EmailAddress

,D.Title AS AchievedTitle

,CONVERT(NVARCHAR(MAX),A.SponsorID) AS SponsorID

,A.SponsorName

,A.ConsultantXID

,A.SponsorXID

,ISNULL(Sum(A.AdjustedPartOneTotal ),0) AS YTD_Total

,Count(*) AS YTD_Orders

FROM DownLine AS...

I don't know if this will help but this is what I am getting back:

DownlineLevel, ConsultantID, Sum(Total)

03104.80

123104.80

130104.80

240104.80

165104.80

173104.80

289104.80

1102104.80

1112104.80

2127104.80

3131104.80

1142104.80

2244104.80

The issue is the Sum value should be differnt amounts and actually a majority...

The should only be broken by COnsultantID not SponsorID. The SponsorID is there because it is used to pull the name sponsor of the consultant which is in the same...

This worked like a champ. Thanks a lot.

The problem with that is it puts them all in sequencial order which is not right.

the way it works is that a top level consultant (level 0) has subordinate consultants...