Click here to Skip to main content
14,360,121 members
   

Database

 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 12:51
memberPer Söderlund20-Mar-13 12:51 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 22:24
protectorJörgen Andersson20-Mar-13 22:24 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 11:48
memberPer Söderlund22-Mar-13 11:48 
GeneralRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 9:14
mveEddy Vluggen20-Mar-13 9:14 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 10:49
protectorJörgen Andersson20-Mar-13 10:49 
GeneralRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 13:19
mveEddy Vluggen20-Mar-13 13:19 
QuestionRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 10:57
protectorJörgen Andersson20-Mar-13 10:57 
AnswerRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 12:44
memberPer Söderlund20-Mar-13 12:44 
Quote:
I would rather create a Sheet table with a status column, and let the production table and the control_measures table refer to it instead.

I wasnt clear in my explanation but that was what i meant on how to solve the normalization.


Quote:
Why do you move the "Sheets" to a new table, it's still the same entity, isn't it?

I will try to explain.
The production table stores shifttime and orders.
So a new record will be added on new shifts or new order.

When they are producing the final product, they also measure,controls and package sheets in stacks.
So instead of having sheets stored over order/shift I want to store it on each stack.
(One record for each stack in control_measures which is related to their shifts production table).
Storing sheets in control_measures gives higher "resolution" and better data to serve to our customers.
But only possible when producing the final product.
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 22:33
protectorJörgen Andersson20-Mar-13 22:33 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 11:59
memberPer Söderlund22-Mar-13 11:59 
Questionlinked server Pin
rocksonedmond19-Mar-13 6:45
memberrocksonedmond19-Mar-13 6:45 
SuggestionRe: linked server Pin
Maciej Los19-Mar-13 8:39
protectorMaciej Los19-Mar-13 8:39 
AnswerRe: linked server Pin
RedDk22-Mar-13 9:23
memberRedDk22-Mar-13 9:23 
QuestionThreading and insert/update issues. Pin
mjackson1118-Mar-13 19:06
membermjackson1118-Mar-13 19:06 
AnswerRe: Threading and insert/update issues. Pin
Mycroft Holmes18-Mar-13 20:33
memberMycroft Holmes18-Mar-13 20:33 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 4:53
membermjackson1119-Mar-13 4:53 
AnswerRe: Threading and insert/update issues. Pin
PIEBALDconsult19-Mar-13 5:10
protectorPIEBALDconsult19-Mar-13 5:10 
AnswerRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 6:17
professionalGuyThiebaut19-Mar-13 6:17 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 6:58
membermjackson1119-Mar-13 6:58 
GeneralRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 7:07
professionalGuyThiebaut19-Mar-13 7:07 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:18
memberkalula17-Mar-13 15:18 
AnswerRe: how did i add calender to my site Pin
NotPolitcallyCorrect17-Mar-13 15:22
memberNotPolitcallyCorrect17-Mar-13 15:22 
AnswerRe: how did i add calender to my site Pin
Mycroft Holmes17-Mar-13 20:57
memberMycroft Holmes17-Mar-13 20:57 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:16
memberkalula17-Mar-13 15:16 
AnswerRe: how did i add calender to my site Pin
thatraja4-Oct-13 21:39
protectorthatraja4-Oct-13 21:39 

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.