create table #Haba (xz varchar(max))
go

BULK INSERT #Haba
   FROM 'C:\log.log'
   WITH 
      (
		CODEPAGE = 'ACP',
        fieldterminator='/n'
      )

select * from #Haba
where xz like '%NEW_PICK_LIST%'
go

drop table #Haba
go

(17 row(s) affected)
xz
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2013-06-22T14:32:12.243 887331072: NEW_PICK_LIST: Создан пик-лист: 45722627 пик-деталь: 49619598 причина: [suppressing] [rcn] [205012] выдача: [R] статус: [O] приоритет: 90 из ячейки: 3649 в ячейку: 4664708 транзитная группа: 0 операция: CTN_FROM_CNT

(1 row(s) affected)

create table #Haba (xz varchar(max))
go

BULK INSERT #Haba
   FROM 'C:\log.log'
   WITH 
      (
		CODEPAGE = 'ACP'
      )

;with cte as (
select 
	row_number() over(order by xz) as id, 
	cast('<row><a>'+replace(xz , ' ', '</a><a>')+'</a></row>' as xml) as xz
from #Haba
where xz like '%NEW_PICK_LIST%')

select cte.id , a.xz1, a.xz2, a.xz3
from cte
cross apply 
(
select 
	t.c.value('a[1]/text()[1]', 'datetime') as xz1,
	t.c.value('a[6]/text()[1]', 'varchar(10)') as xz2,
	t.c.value('a[16]/text()[1]', 'varchar(10)') as xz3

from cte.xz.nodes('/row') as t(c)
) a

go

drop table #Haba
go

(17 row(s) affected)
id                   xz1                     xz2        xz3
-------------------- ----------------------- ---------- ----------
1                    2013-06-22 14:32:12.243 45722627   [O]

(1 row(s) affected)