Unlimited

That seems correct. Have you tried it?

Just a small changes based on preferences. I prefer to make the FROM clause as simple as possible, that's why I use CTEs instead of derived tables (same thing different...

Are you sure that you're querying the tables correctly?

You don't have alias for your tables and that might be causing to use the incorrect columns on what should be a...

You forgot the commas and to put brackets around your column names.

You can use a method called cross tabs (or the pivot operator) which is explained in here:

http://www.sqlservercentral.com/articles/T-SQL/63681/

Here's an example based on your greatly posted sample data.

SELECT ComputerID,

...

Just because this thread was revived after 9 years, I'd like to make a few suggestions.

Use parametrized dynamic sql and always define precision and scale for your types. In 2000,...

Sugar

Snargables (8/12/2016)

---

I didn’t mean not log at all. I just don’t want it to use one continuous transaction to load 2.5 billion records. SSIS is doing it in batches freeing...

ChrisM@Work (8/12/2016)

---

Steve Jones - SSC Editor (8/11/2016)

---

...

Part of the process noted that we have a few "how to post code, how to ask a question, how to format code" articles....

Jeff Moden (8/11/2016)

---

Luis Cazares (8/11/2016)

---

Everything that changes data in a database writes to trans log.

You might have some options to copy the table, but answer Eirikur's questions so we can...

What happens if you don't convert to time? Maybe you have some very long running process or transactions that were left open.

Check the following article for the best options on doing this in 2008 and previous versions.

http://www.sqlservercentral.com/articles/T-SQL/68467/

If by any chance you're on 2012 or a more recent version, a simpler option...

SQLTestUser (8/11/2016)

---

Result For Hour

XXX38532962 which makes no sense as i just want to figure out how much time they spent, i.e. total time on the system in a way that...

You're adding too many minutes. If that's correct, then cast as bigint before aggregating. If not, correct the formula.

SELECT UserID, Hours = SUM(CAST( DATEDIFF(MINUTE, '0:00:00', LogDatetime) AS bigint))

FROM dbo.TLog...