Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Programming / SQL

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
can TIME values be aggregated?03 Sep 2010 03:58 GMT5
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
Subquery returned more than 1 value02 Sep 2010 21:11 GMT4
When I run this query:
update a set a.[UPC] = b.[IDSCE], a.[AltDescription] =  b.[IDESC],
a.
[Weight] = b.[IMNNWU],
How to get 2 Max values?01 Sep 2010 23:02 GMT4
I have following 2 tables (T1, T2) and rows:
T1 (Column: Id)
----
1
Left() function?01 Sep 2010 07:52 GMT14
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, I have a problem with your book "Analytics & OLAP in SQL"31 Aug 2010 16:57 GMT13
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.
Execution plan31 Aug 2010 09:00 GMT21
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
Using tempdb as a users default database31 Aug 2010 08:53 GMT4
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,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.