Click here to Skip to main content
15,215,859 members
   

Database

 
AnswerRe: SSRS Pin
Richard MacCutchan23-Mar-13 1:37
mveRichard MacCutchan23-Mar-13 1:37 
Questiontwo phase commit in sql Pin
Soiraian22-Mar-13 23:22
MemberSoiraian22-Mar-13 23:22 
AnswerRe: two phase commit in sql Pin
Mycroft Holmes23-Mar-13 13:36
professionalMycroft Holmes23-Mar-13 13:36 
QuestionOLAP cube question (a) Edit Dimension and (b) Delete Partitiion Pin
devvvy21-Mar-13 16:07
Memberdevvvy21-Mar-13 16:07 
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 
Great design - what happens when you want to add a new check!

You need to add the values of the 32 checks (presumably booleans where 1= positive) if it = 32 then the program passes andything els the program fails.

Select *
From (Select C1 + C2+C3+... as checktotal, Program from table) as SubQuery
where checktotal = 32

Never underestimate the power of human stupidity
RAH

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 

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.