Query to sum total time

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Query to sum total time

Query to sum total time

Rate Topic

Display Mode

Topic Options

Author

Message

cagan

Posted Monday, January 10, 2011 8:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 21, 2012 3:34 PM
Points: 7, Visits: 27

I am having trouble writing a query that will some the total time for an event. I have 2 columns of data, Encounter_Code, Duration. I need the total unique number of Encounter_Code, My code for this part is Count(Encounter_Code) AS Total, and this is working, but when I try and sum the total duration of every event for one Encounter_Code I don't know where to start. Any suggestions?

Thanks

Post #1045333

Evil Kraig F

Posted Monday, January 10, 2011 9:42 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 10:09 PM
Points: 5,658, Visits: 6,100

Hey Cagan,

Welcome to SSC. It would be easier to help you if you check out the first link in my sig, which will walk you through proving some sample structure and data so that we could write code to show you want you want to do, as well as explaining what said code is doing.

In short, you need two separate statements. One doing the SELECT COUNT ( DISTINCT encounter_number) with no GROUP BY, and another doing a SELECT SUM( DATEDIFF()) FROM tbl GROUP BY Encounter_Number.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1045406

« Prev Topic | Next Topic »

Permissions