SELECT TOP 100 [Index]
,[Customer]
,[CustomerCode]
,[Type]
,[TypeCode]
,[Approved]
,[DecisionDate]
,[DecisionUser]
,[User]
,[Branch]
,[Dates]
,[Resend]
,[LockedBy]
,[LockedTime]
,[SSMA_TimeStamp]
FROM [SQLDB].[dbo].[Authorization]
Where [Customer]= 'MICHAEL MARIANNA'
*Then you should note down the index value of this record so you will use to delete it as below:
DELETE FROM [SQLDB].[dbo].[Authorization]
WHERE[index]='225972'
GO
