Going to save you some time here:

with SampleData as (

select

MsgText as SampleRec

from

dbo.Syslogd

where

MsgDate = dateadd(dd, -1, cast(getdate() as date)) and

MsgText like '%CALL_END%'

)

select

--sd.SampleRec,

--max(case ds.ItemNumber

--when...

I'd make sure that the table has the appropriate clustered index for one. And second, make the procedure serializable so that only one instance of the procedure can update...

Only one I can think of, upgrade to SQL Server 2012 and AlwaysOn.

Evil Kraig F (6/29/2012)

---

Lynn Pettis (6/29/2012)

---

Evil Kraig F (6/29/2012)

---

I may have just realized the problem. Thanks for the reminder Michael, I went off escaping and didn't really think through...

Here's the problem we have, we can't see from here what you see there. Running sp_who2 is just one thing to do. The other would be to look...

David Webb-200187 (6/29/2012)

---

This puts it all together with the like breaks (char(10)), but going through XML changes them to

Hmmmm... have to think on this a little more.

create table #txt1...

Probably, just realize you don't have a good backup and need to be sure you get one soon.

This advice is my own and there are no guarantees implied or explicit....

Looking to see if it may be blocked some how. There may be other processes associated with the backup as well.

Hard to say, we can't see from here what you can see there.

What does running sp_who2 show?

opc.three (6/29/2012)

---

I am curious to hear her...

Evil Kraig F (6/29/2012)

---

I may have just realized the problem. Thanks for the reminder Michael, I went off escaping and didn't really think through the allowable characters for the...

Another thin I would change is the where you are doing the search. syscomments if for backward compatiblity for SQL Server 2000. Instead of syscomments you should be...

Once the data is in the staging table, the following code can be run to populate the final target table:

insert into dbo.CDR (

call_status,

channel_num,

sipcall_ident,

trunk_num,

b_channel,

sipconf_id,

trunk_group_num,

endpoint_type,

call_originator,

source_IP,

destination_IP,

sourcephone_numtype,

sourcephone_numplan,

sourcephone_number,

sourcephone_nummap,

destphone_numtype,

destphone_numplan,

destphone_number,

destphone_nummap,

call_duration,

call_codec,

packet_intervall,

rtp_IP,

rtp_port,

call_release,

termination_reason,

fax_data,

packets_in,

packets_out,

packets_lost,

header_id,

rtp_id,

callsetup_time,

callsetup_date,

callconnect_time,

callconnect_date,

callrelease_time,

callrelease_date,

rtp_delay,

rtp_jitter,

localrtp_source,

remotertp_source,

redirect_reason,

redirect_number,

redirect_numplan

)

select

cast(call_status as nvarchar(255)) call_status,

...

Evil Kraig F (6/29/2012)

---

Lynn Pettis (6/29/2012)

---

Craig, feel free to jump in like you did with that wonderful explaination. Code wise, you may be right, we all...

Craig, feel free to jump in like you did with that wonderful explaination. Code wise, you may be right, we all code slightly differently, but if...