CRECREATE VIEW dbo.vw_sms_del
AS
SELECT     dbo.tmsg_sms.msg_status
FROM         dbo.tEsmeQueues INNER JOIN
                      dbo.tmsg_sms ON dbo.tEsmeQueues.id_queue = dbo.tmsg_sms.queue_id
WHERE     (dbo.tmsg_sms.msg_status =  100000 ) AND (dbo.tmsg_sms.livetime >  0 ) AND (DATEDIFF([minute], dbo.tmsg_sms.msg_date, GETDATE()) 
                      > dbo.tmsg_sms.livetime) OR
                      (dbo.tmsg_sms.msg_status =  100000 ) AND (dbo.tEsmeQueues.queue_state =  0 )

GO