spUploadedListDelete

CREATE procedure [dbo].[spUploadedListDelete]
(
    @LISTID int
)
with execute as owner
AS
BEGIN
set nocount on

declare @TABLENAME nvarchar(128);

set @TABLENAME = dbo.fnUloadedListBuildTableName(@LISTID);

if exists(select 1 from INFORMATION_SCHEMA.TABLES where (TABLE_NAME = @TABLENAME))
begin
exec ('drop table [' + @TABLENAME + ']');
end

delete BOSP
from dbo.backofficesystempeople BOSP
inner join dbo.EmailListUploadMasterList ELUML on ELUML.BB_XListRecordID = BOSP.BackOfficeRecordID
where BOSP.Backofficesystemid = 3 and ELUML.EmailListID = @LISTID

DELETE dbo.EmailListUploadMasterList WHERE EmaillistID = @LISTID
return 0;
END