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

    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

    ETC...

    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
    Location
    Ohio
    Posts
    12,592
    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
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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