Re: How to write a view to de-normalize the table rows?

mullin wrote:
> i have the following table structure with sample data
>
> TranxID RowID Table Description NewValue
> OldValue
> 1000 1 Table1 IDX 1
> 1000 1 Table1 MAPPING A
> B
> 1000 2 Table1 IDX 2
> 1000 2 Table1 MAPPING X
> Y
> 1000 1 Table2 IDX 1
> 1000 1 Table2 MAPPING C
> D
> 2000 1 Table1 IDX 1
> 2000 1 Table1 MAPPING B
> U
>
> i want to write a view to group them into the following structure
>
> TranxID RowID Tb1_IDX_New Tb1_IDX_Old Tb1_MAPPING_New Tb1_MAPPING_Old
> Tb2_IDX_New Tb2_IDX_Old Tb2_MAPPING_New Tb2_MAPPING_Old
> 1000 1 1 A B
> 1 C D
> 1000 2 2 X Y
> 2000 1 1 B U

Then by all means do so.

I'm sorry but is there a question in here somewhere? Or do you expect someone to do your work for you and also have to figure out the business rules too.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)