Чтоб не посеять (:

select * from dbo.TransactionDay_view t
where t.TranUser like ‘%Безручко%’
–and (t.TranDesc = ‘Запрос на проход’ or t.TranDesc = ‘Фактический вход’)

/*
update TransLog
set TranDateTime = CONVERT(datetime, ‘09.14.2011 08:58:51’)
where ID_TRAN = *

update TransLog
set TranDateTime = CONVERT(datetime, ‘09.14.2011 08:58:52’)
where ID_TRAN = *
*/

Comments:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.