CELKO (2/2/2015)

---

>> I need some help building a query. I have a table with 4 columns and need to try and put the times together. <<

And thanks to your bad manners, we have no DDL! The ASCII picture you did post has every column wrong. The temporal model is also wrong; a (start_timestamp, end_timestamp) interval pair is never split over multiple rows. And we use ISO-8601 temporal format, not that silly local dialect you had. You used AM-PM in the 21-st century! You failed to use ISO-8601 dates!

>> There are some inconsistencies with this, and I'm hoping to exclude them. Here is a sample table: <<

So you admit to making us work with garbage data! So polite of you! This is the idiom for temporal data, I am not going to your job for you; give us the data and a spec, and we will help you.

CREATE TABLE Garbage

(emp_id CHAR(1) NOT NULL,

event_type SMALLINT NOT NULL -– bad choice of data type

CHECK (event_type IN (1,2)),

in_something_timestamp DATETIME2(0) NOT NULL,

out_something_timestamp DATETIME2(0), -- null is still active

CHECK (in_something_timestamp < out_something_timestamp)

);

>> Basically what I need to do is take the time from rows with non_relational_function_flg 1 and match it with non_relational_function_flg 2 so I can get a total time of the clock in. <<

NO! They are part of a single interval data type.

> I'm basically trying to get totals for each Clock In-Out type. I hope I made some sense with this. <<

No, but it tells us that you never read a single book on SQL, Data modeling or RDBMS. The INTERVAL data type is a fundamental concept. Please stop programming until you have the fundamental concepts; you are dangerous to your employer.

Did your boss do this to you? You can only fail. It is time to quit and update the resume.