![]() |
I have a table that has some duplicates. I can count the distinct records to get the Total Volume. When I try to Sum when the
27 Aug 2016
| 1 comment
,
|
![]() |
Please forgive me if this is a basic question, but I have found myself responsible for creating SQL reports which is not my forte. Any help will be greatly appreciated!
16 Feb 2016
| 19 comments
,
|
![]() |
I am trying to perform a sum based on multiple values in a table.
24 Apr 2015
| 9 comments
,
|
![]() |
I have the following CASE WHEN statement in my query and would like to get a count of each "category", so output would look something like this:
16 Feb 2015
| 10 comments
,
|
![]() |
I have an audit table that I am creating a view for so I can create some reporting for. In the original table, ther serials are separated by a comma and are all in one comlumn. Here is an example:
13 Aug 2014
,
|
![]() |
I have a column that counts the amounts of serial numbers in a column. This column can have multiple serials separated by a comma.
09 Jul 2014
| 4 comments
,
|
![]() |
Hello -
02 Jul 2014
| 3 comments
,
|
![]() |
I'm adding up totals within a database and would like to see how the totals change over different time periods. I'm using this code: <code> Select Sum(CASE WHEN Offer_1 = 'Y' THEN 1 ELSE 0 END) as Offer1, Sum(CASE WHEN Offer_2 = 'Y' THEN 1 ELSE 0 END) as Offer2,
13 Sep 2011
| 5 comments
,
|