Click here to Skip to main content
       

Database

 
AnswerRe: sql server PinmemberRichard Deeming18-Jan-13 1:37 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 2:13 
GeneralRe: sql server PinmemberRichard Deeming18-Jan-13 2:18 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 2:22 
GeneralRe: sql server PinmemberPIEBALDconsult18-Jan-13 14:36 
AnswerRe: sql server PinmemberPIEBALDconsult18-Jan-13 4:04 
GeneralRe: sql server PinmemberShameel22-Jan-13 4:31 
QuestionDo I need a pivot Query? PinmemberGREG_DORIANcod16-Jan-13 10:09 
this is my original query:

INVOICE NC_DOC NC_VALUE ND_DOC ND_VALUE RC_DOC RC_VALUE
40842 137 130130 140 60000 3 130130
40842 137 130130 141 85060 3 130130
40842 138 -130130 140 60000 3 130130
40842 138 -130130 141 85060 3 130130
40842 139 190130 140 60000 3 130130

 
BUT Now i need some query like this
 
doctype numberDoc doc_value
NC_DOC 137 130130
NC_DOC 138 -130130
NC_DOC 139 190130
ND_DOC 140 60000
ND_DOC 141 85060
RC_DOC 3 130130

AnswerRe: Do I need a pivot Query? PinmemberMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? PinmemberGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? PinmemberJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type PinmemberRichard.Berry10015-Jan-13 21:38 
AnswerRe: Totals of each transaction type PinmemberMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type PinmemberPIEBALDconsult16-Jan-13 3:42 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 5:36 
QuestionCustomize color coding in SQL editor window [modified] Pinmemberbiop.codeproject15-Jan-13 20:04 
AnswerRe: Customize color coding in SQL editor window PinmemberMycroft Holmes15-Jan-13 22:51 
GeneralMessage Removed Pinmemberbiop.codeproject16-Jan-13 19:26 
GeneralRe: Customize color coding in SQL editor window PinmemberMycroft Holmes16-Jan-13 19:34 
GeneralRe: Customize color coding in SQL editor window PinmemberShameel22-Jan-13 4:41 
Questionquery.. Pinmembervishal.v.patil14-Jan-13 17:49 
AnswerRe: query.. PinmemberMycroft Holmes14-Jan-13 17:54 
GeneralRe: query.. Pinmembervishal.v.patil14-Jan-13 18:21 
GeneralRe: query.. PinmemberBlue_Boy15-Jan-13 3:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 16 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid