Click here to Skip to main content
15,883,535 members
Home / Discussions / Database
   

Database

 
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 
What a classic, this is the most basic of error in database design and now you have to deal with the issue.

Is the change in structure going to be a permanent change to the data structure or is it just to facilitate some reporting requirement?

I would go with the view solution if it is for reporting. A series (16 of them) of UNION queries would do the job but t would be ugly.
Never underestimate the power of human stupidity
RAH

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 
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 

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.