#DateForumTypeThreadPost
527 Aug 2016 @ 09:44 PDTDatabaseTopicSum distinct records in a table with duplicates 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 CompTia Code is B92 and run distinct is still count...
413 Aug 2014 @ 02:32 PDTDatabaseTopicsumming serial numbers in a single column with out using an external function.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: ...
311 Jul 2014 @ 07:03 PDTDatabaseReplyCreating a TotalThanks Dieter. Totally forget about Grouping by the initiator. :)
211 Jul 2014 @ 01:34 PDTDatabaseReplyCreating a TotalI tried that. I get the error:   Selected non-aggregate values must be part of the associated group.   If you try to group by a Date or the a person id, you get the same ...
109 Jul 2014 @ 09:16 PDTDatabaseTopicCreating a TotalI have a column that counts the amounts of serial numbers in a column. This column can have multiple serials separated by a comma. Here is the SQL to create this column: (char_length(serial_numbe...