var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
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.
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.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors