Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Green Bay

    Unanswered: Taking EAV create Dimension Table

    I have a result set as follow

    Jobid, ClassId, ClassValue
    1 GroupName Joes Auto
    1 EffDate 1/1/6
    1 Userid XYZ1234
    2 GroupName Sams Eatery
    2 EffDate 2/1/6
    2 UserID ABC0987


    I need

    Jobid GroupName EffDate Userid
    1 Joes Auto 1/1/6 xyz1234
    2 Sams Eatery 2/1/6 abc0987

    I can manipulate this in a pivot table for reporting however I need this to be a table for reporting by filterable searchable information. What can I do short of defining each field with case logic, or union queries.

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    If you are going to use EAV, you have to resign yourself to CASE statements and UNION queries. You are trading efficiency and simplicity for flexibility.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts