Viewing 8 posts - 391 through 398 (of 398 total)
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...
April 18, 2012 at 2:13 pm
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...
April 18, 2012 at 1:46 pm
can someone tell me how to embedd an actual image?? here on this forum?
April 18, 2012 at 1:27 pm
Here's how it's supposed to look.
http://www.flickr.com/photos/54066173@N08/">
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...
April 18, 2012 at 1:26 pm
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.
April 18, 2012 at 1:10 pm
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...
April 18, 2012 at 10:13 am
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...
April 18, 2012 at 9:58 am
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...
April 18, 2012 at 4:17 am
Viewing 8 posts - 391 through 398 (of 398 total)