YOU'RE RIGHT. That 1 next to WA_Consumer under <30 days was errant. There were many errors. I'm removing and updating attachment.

OK, highlevel, better explained.

There are two things this...

There's my attachment. Bingo. Thanks Carpal.

Lyn, I've already provided the DDL, which is what I think you're asking me to do. If I could create a query that provided...

can someone tell me how to embedd an actual image?? here on this forum?

Here's how it's supposed to look.

http://www.flickr.com/photos/54066173@N08/

You'll see when you create the table using the DDL, that based on the dates of the transitions, two case_id (220, 230) took over 30...

thank you very much. That's it.

I just realized I need to update the image on the link as it isn't correct, entirely!!! wait.

and then I scrapped my table and re - ran DDL because I had a new column to add, and same thing. When I refreshed database, however, and ran select...

ok dwain.c

results of SELECT CAST(0 AS DATETIME) are:

1900-01-01 00:00:00.000

Anyway, I deleted the table and reran the DDL. **then refreshed the database** and then ran select. This time the date...

Thanks both.

I did that and the insert part executed, but the results in the table were unexpected.

Insert

insert into Case_Review

values

(220, 1, 'Proposed', '2012-04-17 12:17'),

(220, 2, 'Proposed', '2012-04-17 14:05'),

(220, 3, 'Proposed', '2012-04-18...