Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Most efficient way to store this example data in sql server or some other object

Posted on 2012-03-30
3
Medium Priority
?
332 Views
Last Modified: 2012-03-31
I have Earnings_Code that is dependent on the Employment_Type, and Job_Code.

The earnings code are not all treated the same.  There is a group of codes, that have will are determined on weekly hours and number of weeks.  There is a group of code that are determined on different criteria.  I have attached a file of what one record for a person might look like.

In our office we discussed how we might represent this data so that it would be easy to modify ie not tons of conditional if statements.

There were two model:  represent the data as an object with properties of the different scenario or use a set up table and provide a function to grab the data.

Any input would be greatly appreciated.

Nigluc
0
Comment
Question by:Lucia
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
OCDan earned 2000 total points
ID: 37789386
No file attached mate?

How many rules are there for how earning codes are treated?
Is there some logic to the earning codes that mean by looking at the code you can work out (without just remembering) how it should be treated.
0
 

Author Comment

by:Lucia
ID: 37789995
PossibleRecordRepresentation.xlsxHi,

sorry end of day and I thought I attached it .

---Yes there is logic to the codes .  I have an example attached. The logic is different depending for the different earning codes.  

Thank you,
Nigluc
0
 

Author Closing Comment

by:Lucia
ID: 37790782
Thanks for answering.  We are writing a custom bolton to an application.  I looked at the existing earnings code table and the earnings code are determined based on payment type.
So I will save the data in a similar manner.

Nigluc
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Simple Linear Regression
Introduction to Processes

879 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question