use VirtualTransferAdvisor

-- Change this user name (or pattern) to the one you want to delete
declare @userName varchar(50) = 'host'

declare @studentId int

select @studentId = StudentId
from
    Students
where
    UserName = @userName

update FinancialSets
set
    YearlyStudentProfileId = null
from
    FinancialSets fs
where
    fs.StudentId = @studentId

delete YearlyStudentProfiles
from
    YearlyStudentProfiles ysp
    join FinancialSets fs on
        ysp.FinancialSetId = fs.FinancialSetId
where
    fs.StudentId = @studentId

delete FinancialFactors
from
    FinancialFactors ff
    join FinancialSets fs on
        ff.FinancialSetId = fs.FinancialSetId
where
    fs.StudentId = @studentId

delete InformationalFinancialFactors
from
    InformationalFinancialFactors iff
    join FinancialSets fs on
        iff.FinancialSetId = fs.FinancialSetId
where
    fs.StudentId = @studentId

delete StudentLoanPayoffs
where
    StudentId = @studentId

delete StudentMonthlyBudgets
where
    StudentId = @studentId

delete FinancialSetCompletionDetails
from
    FinancialSetCompletionDetails fscd
    join FinancialSets fs on
        fscd.FinancialSetId = fs.FinancialSetId
where
    fs.StudentId = @studentId

delete FinancialSets
where
    StudentId = @studentId

delete StudentDisclaimerSignOffs
where
    StudentId = @studentId

update Students
set
    StudentProfileId = null
where
    UserName like @userName

delete StudentProfiles
where
    StudentId = @studentId

delete AcademicProfiles
where
    StudentId = @studentId

delete Students where UserName like @userName