Click here to Skip to main content
14,934,046 members
Home / Discussions / Database
   

Database

 
QuestionWant a query for for finding total number of non defected items. Pin
VishwaKL19-Mar-13 23:07
MemberVishwaKL19-Mar-13 23:07 
AnswerRe: Want a query for for finding total number of non defected items. Pin
Corporal Agarn20-Mar-13 1:03
professionalCorporal Agarn20-Mar-13 1:03 
GeneralRe: Want a query for for finding total number of non defected items. Pin
VishwaKL20-Mar-13 18:05
MemberVishwaKL20-Mar-13 18:05 
GeneralRe: Want a query for for finding total number of non defected items. Pin
Mycroft Holmes20-Mar-13 18:58
professionalMycroft Holmes20-Mar-13 18:58 
QuestionMS Sql normalization Pin
Per Söderlund19-Mar-13 21:40
MemberPer Söderlund19-Mar-13 21:40 
AnswerRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 0:14
professionalJörgen Andersson20-Mar-13 0:14 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 0:20
MemberPer Söderlund20-Mar-13 0:20 
AnswerRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 1:38
professionalEddy Vluggen20-Mar-13 1:38 
AnswerRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 2:34
professionalJörgen Andersson20-Mar-13 2:34 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 3:01
MemberPer Söderlund20-Mar-13 3:01 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 4:07
professionalJörgen Andersson20-Mar-13 4:07 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 4:38
MemberPer Söderlund20-Mar-13 4:38 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 4:45
professionalJörgen Andersson20-Mar-13 4:45 
GeneralRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 11:51
MemberPer Söderlund20-Mar-13 11:51 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 21:24
professionalJörgen Andersson20-Mar-13 21:24 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 10:48
MemberPer Söderlund22-Mar-13 10:48 
GeneralRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 8:14
professionalEddy Vluggen20-Mar-13 8:14 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 9:49
professionalJörgen Andersson20-Mar-13 9:49 
GeneralRe: MS Sql normalization Pin
Eddy Vluggen20-Mar-13 12:19
professionalEddy Vluggen20-Mar-13 12:19 
QuestionRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 9:57
professionalJörgen Andersson20-Mar-13 9:57 
AnswerRe: MS Sql normalization Pin
Per Söderlund20-Mar-13 11:44
MemberPer Söderlund20-Mar-13 11: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 21:33
professionalJörgen Andersson20-Mar-13 21:33 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 10:59
MemberPer Söderlund22-Mar-13 10:59 
Questionlinked server Pin
rocksonedmond19-Mar-13 5:45
Memberrocksonedmond19-Mar-13 5:45 
SuggestionRe: linked server Pin
Maciej Los19-Mar-13 7:39
mveMaciej Los19-Mar-13 7: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.