SQL --- date fields as two seperate columns from the same table based on criteria from a seperate field
Posted on 2011-03-08
I have a table that holds three columns that are critical to my SQL eporting.
The first field is RPTKEY(unique identifier of the records), next is the EVTDATE. The last is the ACTION.
Is there a way to do a join or a union (not sure what is appropriate) so I can run a report that would show the ACTION across the top and the associated EVTDATE for that ACTION below with the RPTKEY as the value along has the row header.
The linkage would be the RPTKEY for both the other values.
Hope this makes sense.