Click here to Skip to main content
15,567,448 members
Home / Discussions / Database
   

Database

 
AnswerRe: Edit SSRS report file Pin
Chris Quinn13-Feb-15 1:25
Chris Quinn13-Feb-15 1:25 
GeneralRe: Edit SSRS report file Pin
indian14313-Feb-15 14:36
indian14313-Feb-15 14:36 
QuestionMYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 3:28
KipkoechE12-Feb-15 3:28 
AnswerRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 4:26
mveRichard Deeming12-Feb-15 4:26 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:06
KipkoechE12-Feb-15 5:06 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:20
professionalGuyThiebaut12-Feb-15 5:20 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:27
KipkoechE12-Feb-15 5:27 
QuestionRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 5:33
professionalGuyThiebaut12-Feb-15 5:33 
GeneralRe: MYSQL RANKING IN A VIEW Pin
Richard Deeming12-Feb-15 5:34
mveRichard Deeming12-Feb-15 5:34 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 5:53
KipkoechE12-Feb-15 5:53 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:03
KipkoechE12-Feb-15 6:03 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:18
professionalGuyThiebaut12-Feb-15 6:18 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 6:23
KipkoechE12-Feb-15 6:23 
GeneralRe: MYSQL RANKING IN A VIEW Pin
GuyThiebaut12-Feb-15 6:28
professionalGuyThiebaut12-Feb-15 6:28 
GeneralRe: MYSQL RANKING IN A VIEW Pin
KipkoechE12-Feb-15 7:05
KipkoechE12-Feb-15 7:05 
QuestionAdd allowance to employee table is wrong or true according to my case Pin
ahmed_sa11-Feb-15 22:52
ahmed_sa11-Feb-15 22:52 
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
David Mujica12-Feb-15 4:49
David Mujica12-Feb-15 4:49 
Some things to consider in your design ...

How about a design like this:

employee Key
Allowance Code
Effective_Start_Date
Effective_End_Date
Allowance Rate

This may not be complete, but what it does for you is that it allows for many types of allowance codes to be associated with an employee, each allowance code has an effective date range with an associated rate. This also allows for 2 employee who have the same allowance code to be compensated differently.

You would then need another table which translates the Allowance Code to a description.

I use a similar approach when dealing with prices, you have the history of the prices over time ...

Just a thought.
Good luck. Thumbs Up | :thumbsup:
AnswerRe: Add allowance to employee table is wrong or true according to my case Pin
Mycroft Holmes12-Feb-15 13:01
professionalMycroft Holmes12-Feb-15 13:01 
QuestionTriggers Pin
Member 1116162511-Feb-15 20:19
Member 1116162511-Feb-15 20:19 
AnswerRe: Triggers Pin
Kornfeld Eliyahu Peter11-Feb-15 20:37
professionalKornfeld Eliyahu Peter11-Feb-15 20:37 
GeneralRe: Triggers Pin
John C Rayan12-Feb-15 4:32
professionalJohn C Rayan12-Feb-15 4:32 
QuestionRANKING IN VB.NET MYSQL Pin
KipkoechE10-Feb-15 23:27
KipkoechE10-Feb-15 23:27 
SuggestionRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 1:06
mveRichard MacCutchan11-Feb-15 1:06 
GeneralRe: RANKING IN VB.NET MYSQL Pin
KipkoechE11-Feb-15 2:32
KipkoechE11-Feb-15 2:32 
GeneralRe: RANKING IN VB.NET MYSQL Pin
Richard MacCutchan11-Feb-15 2:36
mveRichard MacCutchan11-Feb-15 2:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.