First, you have run my code as is, correct? I need the exact error message you are getting when it fails.

rjbirkett (6/30/2012)

---

Still fails. Try removing the data from the callconnect_datetime segment and just filling it full of the same number of spaces and run it again. I get...

sivag (6/30/2012)

---

...

Here is my code and it works with my small set of data.

drop table dbo.CDRStaging;

go

with SampleData as (

select

MsgText as SampleRec

from

dbo.Syslogd

where

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

I can't find it, but I thought you had posted the CREATE TABLE statement for the table dbo.CDR. Can you post it again?

Nevermind, I found it.

rjbirkett (6/30/2012)

---

Lynn,

I have been reading up on this all day. I'm not the only one asking this question. It appears that for some, the WHILE loop is the...

rjbirkett (6/30/2012)

---

So, after another few hours of reading and just trying to get something to work, I still hit a brick wall. I'm sure that I am running the...

Hard to say without...

sivag (6/29/2012)

---

anthony.green that was different concept and this was a different concept

in that concept i will provide parameter @memberid ...

Not creating the Tree Graph, but I was able to create the following based on the posts above.

/****** Object: Table [dbo].[tblMembers] Script Date: 06/30/2012 03:43:43 ******/

IF...

First, I thought you should know I used BOL to help me write the following code. I hope it helps you with what you are trying to do.

/****** Object:...

Is the second datetime the only one that can be blank (or null)?

nchar, nvarchar, and nvarchar are supported, text and ntext have been depreciated.

I will look into it. As for the SQL Server Community, you will find it unique among communities. We are willing to share our knowledge and experience freely.

I would be carefully with triggers. If the write to dbo.CDR failed for some reason, the write of the record to dbo.Syslogd would rolled back as well.

The question I...