Click here to Skip to main content
15,917,618 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: small bank application Pin
thatraja4-Jun-12 17:11
professionalthatraja4-Jun-12 17:11 
GeneralRe: small bank application Pin
Paul Conrad4-Jun-12 17:12
professionalPaul Conrad4-Jun-12 17:12 
GeneralRe: small bank application Pin
thatraja6-Jun-12 8:48
professionalthatraja6-Jun-12 8:48 
AnswerRe: small bank application Pin
vvashishta4-Jun-12 22:03
vvashishta4-Jun-12 22:03 
AnswerRe: small bank application Pin
jschell5-Jun-12 8:31
jschell5-Jun-12 8:31 
Questionviewing members in a role Pin
Danzy832-Jun-12 5:30
Danzy832-Jun-12 5:30 
AnswerRe: viewing members in a role Pin
David Mujica4-Jun-12 3:35
David Mujica4-Jun-12 3:35 
AnswerRe: viewing members in a role Pin
vvashishta4-Jun-12 22:04
vvashishta4-Jun-12 22:04 
NewsSQL Server-Oracle-Linked Server on 64 bit machine Pin
vanikanc30-May-12 9:56
vanikanc30-May-12 9:56 
GeneralRe: SQL Server-Oracle-Linked Server on 64 bit machine Pin
jschell31-May-12 7:18
jschell31-May-12 7:18 
GeneralRe: SQL Server-Oracle-Linked Server on 64 bit machine Pin
vanikanc1-Jun-12 2:41
vanikanc1-Jun-12 2:41 
GeneralRe: SQL Server-Oracle-Linked Server on 64 bit machine Pin
jschell1-Jun-12 3:36
jschell1-Jun-12 3: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.