SELECT query with CASE condition and SUM()

by 
Select SUM(CASE When CPayment="Cash" Then CAmount Else 0 End ) as CashPaymentAmount,
       SUM(CASE When CPayment="Check" Then CAmount Else 0 End ) as CheckPaymentAmount
from TableOrderPayment
Where ( CPayment="Cash" Or CPayment="Check" ) AND CDate<=SYSDATETIME() and CStatus="Active";

More Related Contents:

  1. How do I perform an IF…THEN in an SQL SELECT?
  2. Can I use CASE statement in a JOIN condition?
  3. “CASE” statement within “WHERE” clause in SQL Server 2008
  4. OR is not supported with CASE Statement in SQL Server
  5. Case in Select Statement
  6. Dynamic order direction
  7. SUM total time in SQL Server [duplicate]
  8. Max sal to print base on manager_id
  9. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  10. sql server 2008 management studio not checking the syntax of my query
  11. Conversion failed when converting date and/or time from character string while inserting datetime
  12. Create a date from day month and year with T-SQL
  13. How should I pass a table name into a stored proc?
  14. Get the last inserted row ID (with SQL statement) [duplicate]
  15. Get the week start date and week end date from week number
  16. conditional unique constraint
  17. SELECT FOR UPDATE with SQL Server
  18. How to group by month from Date field using sql
  19. Why is my t-sql left join not working?
  20. How to get the numeric part from a string using T-SQL?
  21. SQL Server Update Trigger, Get Only modified fields
  22. Grouped string aggregation / LISTAGG for SQL Server
  23. Curly braces in T-SQL
  24. SQL Server SELECT LAST N Rows
  25. update columns values with column of another table based on condition [duplicate]
  26. Find min and max for subsets of consecutive rows – gaps and islands
  27. The transaction log for the database is full
  28. Should I use the CASCADE DELETE rule? [duplicate]
  29. Why is RAND() not producing random numbers?
  30. SQL, How to Concatenate results?

Leave a Comment