begin transaction

IF OBJECT_ID('tempdb..#NEWNODES') IS NOT NULL DROP TABLE #NEWNODES
CREATE    TABLE #NEWNODES
    (
    MEMBNODEID INT
    )
insert into #NEWNODES
    (MEMBNODEID)
select NODEID
from dbo.cmsMember

--delete all MEMBER contentVersions
delete from [cmsContentVersion]
where VersionId
    in (
    select versionId
    from cmsPropertyData
    where contentnodeid
        in (select MEMBNODEID from #NEWNODES)
    )

--DELETE MEMBER CONTENT
delete  FROM [dbo].[cmsContent]
where [nodeId]
        in (select MEMBNODEID from #NEWNODES)

--delete MEMBER property data
delete  from cmsPropertyData
where contentnodeid
    in (select MEMBNODEID from #NEWNODES)

--delete member type asignments
truncate table [dbo].[cmsMemberType]

--DELETE MEMBER GROUP ASIGNMENTS
truncate table dbo.cmsMember2MemberGroup

--DELETE MEMBERS
truncate table dbo.cmsMember

--DELETE MEMBER NODES
delete from dbo.umbracoNode
where id
    in (select MEMBNODEID from #NEWNODES)

delete from [dbo].[umbracoNode]
where [nodeObjectType]='366E63B9-880F-4E13-A61C-98069B029728 '

--If you run this an get no errors then exicute a commit transaction