use VirtualTransferAdvisor

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

update FinancialSets
set
    YearlyStudentProfileId = null
from
    FinancialSets fs
    join Students s on
        fs.StudentId = s.StudentId
where
    s.UserName like @userName

delete YearlyStudentProfiles
from
    YearlyStudentProfiles ysp
    join FinancialSets fs on
        ysp.FinancialSetId = fs.FinancialSetId
    join Students s on
        fs.StudentId = s.StudentId
where
    s.UserName like @userName

delete FinancialFactors
from
    FinancialFactors ff
    join FinancialSets fs on
        ff.FinancialSetId = fs.FinancialSetId
    join Students s on
        fs.StudentId = s.StudentId
where
    s.UserName like @userName

delete InformationalFinancialFactors
from
    InformationalFinancialFactors iff
    join FinancialSets fs on
        iff.FinancialSetId = fs.FinancialSetId
    join Students s on
        fs.StudentId = s.StudentId
where
    s.UserName like @userName

delete StudentLoanPayoffs
from
    StudentLoanPayoffs slp
    join Students s on
        slp.StudentId = s.StudentId
where
    s.UserName like @userName

delete FinancialSets
from
    FinancialSets fs
    join Students s on
        fs.StudentId = s.StudentId
where
    s.UserName like @userName

update Students
set
    StudentProfileId = null
where
    UserName like @userName

delete StudentDisclaimerSignOffs
from
    StudentDisclaimerSignOffs dso
    join Students s on
        dso.StudentId = s.StudentId
where
    s.UserName like @userName

delete StudentProfiles
from
    StudentProfiles sp
    join Students s on
        sp.StudentId = s.StudentId
where
    s.UserName like @userName

delete AcademicProfiles
from
    AcademicProfiles ap
    join Students s on
        ap.StudentId = s.StudentId
where
    s.UserName like @userName

delete Students where UserName like @userName