Click here to Skip to main content
15,867,141 members
Home / Discussions / Database
   

Database

 
AnswerRe: OR in a JOIN Pin
Chris Meech6-Jun-12 4:30
Chris Meech6-Jun-12 4:30 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 5:55
mvePIEBALDconsult6-Jun-12 5:55 
GeneralRe: OR in a JOIN Pin
Chris Meech6-Jun-12 6:56
Chris Meech6-Jun-12 6:56 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 9:10
mvePIEBALDconsult6-Jun-12 9:10 
GeneralRe: OR in a JOIN Pin
Chris Meech6-Jun-12 10:07
Chris Meech6-Jun-12 10:07 
AnswerRe: OR in a JOIN Pin
Paul Conrad6-Jun-12 9:43
professionalPaul Conrad6-Jun-12 9:43 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 10:38
mvePIEBALDconsult6-Jun-12 10:38 
AnswerRe: OR in a JOIN Pin
Luc Pattyn7-Jun-12 4:33
sitebuilderLuc Pattyn7-Jun-12 4:33 
GeneralRe: OR in a JOIN Pin
Bernhard Hiller7-Jun-12 22:47
Bernhard Hiller7-Jun-12 22:47 
GeneralRe: OR in a JOIN Pin
Luc Pattyn8-Jun-12 2:22
sitebuilderLuc Pattyn8-Jun-12 2:22 
AnswerRe: OR in a JOIN Pin
Jörgen Andersson7-Jun-12 6:51
professionalJörgen Andersson7-Jun-12 6:51 
AnswerRe: OR in a JOIN Pin
Luc Pattyn7-Jun-12 7:23
sitebuilderLuc Pattyn7-Jun-12 7:23 
GeneralRe: OR in a JOIN Pin
Jörgen Andersson7-Jun-12 8:13
professionalJörgen Andersson7-Jun-12 8:13 
QuestionTransposing SQL Record Pin
Frank Lepkowski4-Jun-12 8:22
Frank Lepkowski4-Jun-12 8:22 
AnswerRe: Transposing SQL Record Pin
David Mujica4-Jun-12 9:56
David Mujica4-Jun-12 9:56 
GeneralRe: Transposing SQL Record Pin
FrankLepkowski4-Jun-12 11:04
FrankLepkowski4-Jun-12 11:04 
AnswerRe: Transposing SQL Record Pin
Jörgen Andersson4-Jun-12 11:22
professionalJörgen Andersson4-Jun-12 11:22 
AnswerRe: Transposing SQL Record Pin
Mycroft Holmes4-Jun-12 13:11
professionalMycroft Holmes4-Jun-12 13:11 
GeneralRe: Transposing SQL Record Pin
FrankLepkowski4-Jun-12 13:23
FrankLepkowski4-Jun-12 13:23 
GeneralRe: Transposing SQL Record Pin
Mycroft Holmes4-Jun-12 14:12
professionalMycroft Holmes4-Jun-12 14:12 
Then go with the view idea

SQL
SELECT  commonfields,
        Ing1Name AS fieldanme,
        Ing1Size,
        Ing1PRM,
        Ing1AcceptedUnderTol,
        Ing1SPCSample,
        Ing1TargetWgt,
        Ing1ActualWgt,
        Ing1PartialActualWgt,
        Ing1PreactWgt,
        Ing1SlowFeedTime,
        Ing1FastFeedTime
FROM    SomTable
UNION ALL
SELECT  commonfields,
        Ing2Name,
        Ing2Size,
        Ing2PRM,
        Ing2AcceptedUnderTol,
        Ing2SPCSample,
        Ing2TargetWgt,
        Ing2ActualWgt,
        Ing2PartialActualWgt,
        Ing2PreactWgt,
        Ing2SlowFeedTime,
        Ing2FastFeedTime
FROM    SomTable

Never underestimate the power of human stupidity
RAH

Questionsmall bank application Pin
mpkuena4-Jun-12 6:51
mpkuena4-Jun-12 6:51 
AnswerRe: small bank application Pin
Paul Conrad4-Jun-12 8:06
professionalPaul Conrad4-Jun-12 8:06 
AnswerRe: small bank application Pin
R. Giskard Reventlov4-Jun-12 8:43
R. Giskard Reventlov4-Jun-12 8:43 
JokeRe: small bank application Pin
Chris Meech4-Jun-12 8:58
Chris Meech4-Jun-12 8:58 
GeneralRe: small bank application Pin
thatraja6-Jun-12 8:46
professionalthatraja6-Jun-12 8:46 

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.