Click here to Skip to main content
12,502,116 members (51,240 online)
   

Database

 
AnswerRe: Do I need a pivot Query? Pin
Mycroft Holmes16-Jan-13 19:36
memberMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? Pin
GREG_DORIANcod17-Jan-13 1:59
memberGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? Pin
Jörgen Andersson21-Jan-13 8:58
memberJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type Pin
Richard.Berry10015-Jan-13 21:38
memberRichard.Berry10015-Jan-13 21:38 
Hi

How can I get the total number of two types of transaction between two dates per user

Example data:

User TransactionType MovementDate
Avril RECP 2012/01/04
Pat RECP 2012/01/09
Pat SRET 2012/01/09

What I would like is the following:

User Recipts Returns
Avril 1 0
Pat 1 1


This is where I was heading, but as soon as I put in a where clause to limit the date range I get an Error " Incorrect column expression: 'SUM(CASE WHEN stkhistm.transaction_type = 'RECP Then 1 else 0 end)'
SELECT SUM(CASE WHEN stkhstm.transaction_type = 'RECP' then 1 else 0 end) , SUM(CASE WHEN stkhstm.transaction_type = 'SRET' then 1 else 0 end)  
FROM vektron.scheme.stkhstm stkhstm
WHERE stkhstm.movement_date>=[?] 

AnswerRe: Totals of each transaction type Pin
Mycroft Holmes15-Jan-13 22:57
memberMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 0:36
memberRichard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type Pin
PIEBALDconsult16-Jan-13 3:42
memberPIEBALDconsult16-Jan-13 3:42 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 5:36
memberRichard.Berry10016-Jan-13 5:36 
QuestionCustomize color coding in SQL editor window Pin
biop.codeproject15-Jan-13 20:04
memberbiop.codeproject15-Jan-13 20:04 
AnswerRe: Customize color coding in SQL editor window Pin
Mycroft Holmes15-Jan-13 22:51
memberMycroft Holmes15-Jan-13 22:51 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160919.1 | Last Updated 25 Sep 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid