DBA

ALTER PROCEDURE [dbo].[WZ_ACCOUNT_DELETE]
	@in_CustomerID int
AS
BEGIN
	SET NOCOUNT ON;

	-- success
	select 0 as ResultCode

	delete from dbo.UsersChars where CustomerID=@in_CustomerID
	delete from dbo.UsersData where CustomerID=@in_CustomerID
	delete from dbo.UsersInventory where CustomerID=@in_CustomerID

	update dbo.Accounts set AccountStatus=999 where CustomerID=@in_CustomerID

	return
END






----------------------------------
SELECT * FROM [dbo].[UsersChars] WHERE [LastUpdateDate] <= '2015-08-29 19:15:15'
SELECT * FROM [dbo].[Accounts] WHERE [lastlogindate] <= '2015-08-29 19:15:15'

    delete from dbo.UsersChars where CustomerID=@in_CustomerID
    delete from dbo.UsersData where CustomerID=@in_CustomerID
    delete from dbo.UsersInventory where CustomerID=@in_CustomerID