declare @Delete int, @Update int, @Insert int

DELETE FROM [dbo].[DATA_EWT]

WHERE [ETYPE_EWT] = 'CopyRequested'

select @Delete = @@ROWCOUNT

DELETE FROM [dbo].[DATA_EWT]

WHERE [ETYPE_EWT] = 'AdditionalIntrestType'

select @Delete = @@ROWCOUNT

INSERT INTO [dbo].[DATA_EWT]

([ETYPE_EWT]

,[KEY_MTD]

,[VALUE_MTD])

VALUES

('AdditionalIntrestType','entity','Entity')

select @insert = @@ROWCOUNT

INSERT INTO [dbo].[DATA_EWT]

([ETYPE_EWT]

,[KEY_MTD]

,[VALUE_MTD])

VALUES

('AdditionalIntrestType','individual','Individual')

select @insert = @@ROWCOUNT

UPDATE [dbo].[DATA_EWT]

SET [KEY_MTD] = 'DirectBill'

,[VALUE_MTD] = 'Direct Bill'

WHERE [ETYPE_EWT] = 'TypesOfBill' and [KEY_MTD] = 'Direct'

select @update = @@ROWCOUNT

UPDATE [dbo].[DATA_EWT]

SET [KEY_MTD] = 10

WHERE [ETYPE_EWT] = 'ApplicationStatus' AND [VALUE_MTD] = 'Application Completed'

select @Update = @@ROWCOUNT

DELETE FROM [dbo].[DATA_EWT]

WHERE [ETYPE_EWT] = 'ApplicationStatus' AND [VALUE_MTD] = 'Application Declined'

select @Delete = @@ROWCOUNT

INSERT INTO [dbo].[DATA_EWT]

([ETYPE_EWT]

,[KEY_MTD]

,[VALUE_MTD])

VALUES

('ApplicationStatus'

,11

,'Application Declined')

select @Insert = @@ROWCOUNT

print cast(@Update as varchar(6)) + ' Row(s) Updated'

print cast(@Delete as varchar(6)) + ' Row(s) Deleted'

print cast(@Insert as varchar(6)) + ' Row(s) Inserted'