Can time values be aggregated?  I'm putting together a summary report
that will need to show the sum time that something happened.
(Employee breaks, for instance.)  If break times for 3 employees were
"01:00:00", "00:15:00", and "00:12:30" in length, how do I aggregate

When I run this query:
update a set a.[UPC] = b.[IDSCE], a.[AltDescription] =  b.[IDESC],
a.
[Weight] = b.[IMNNWU],

I have following 2 tables (T1, T2) and rows:
T1 (Column: Id)
----
1

I’m trying to create a view. Within the criteria I need to get just the left
character of a field. In Access this is really simple and the SQL is user
friendly and very powerful. Is this even possible with SQL Server?

CELKO, your Analytics & OLAP in SQL book arrived last week and I
started reading it today.  Unfortunately, pages 13 through 60 are
missing.  Could you possibly replace it for me, or perhaps send me a
PDF of the missing pages?  I need to read it sooner rather than later.

I have simple select statement:
SELECT d.ID, d.name
FROM dbo.table1 t1 INNER JOIN dbo.table2 t2 ON t1.up_id=t2.up_id
INNER JOIN dbo.table3 t3 ON t2.ID=t3.ID

I would like to ask what people think of using Tembdb as a users
default database.
I ask this because, when the instance is re-started tempdb is
recreated and any user accounts in there are lost,