You can get the result you need: the specific method depends on specifically what you need to do. If you can provide sample values and the desired results, we...

For anything less than 24 hours, you can do this:

SELECT

CONVERT(varchar(8), DATEADD(SECOND, DATEDIFF(SECOND, segstart, segstop), 0), 8)

FROM (

SELECT CAST('20130906 09:28:00' AS datetime) AS...

Just list the column names that are being inserted into the new table; you don't have to supply all columns. For example, see below; naturally your specific column names...

SELECT *

FROM dbo.tablename

WHERE Customer IN (

SELECT Customer

FROM dbo.tablename

GROUP BY Customer

HAVING COUNT(DISTINCT Contract) > 1

...

UPDATE CurrMonth

SET [PrevPerc] = PrevMonth.[CurrPerc]

FROM #Month CurrMonth

INNER JOIN #Month PrevMonth ON

PrevMonth.[DEPARTMENT] = CurrMonth.DEPARTMENT AND

PrevMonth.[YEAR] = CurrMonth.[YEAR] - CASE WHEN CurrMonth.[MONTH] =...

I wouldn't use PARSENAME here because of potential side effects, for example, periods (.) in the data or brackets ([]) around a piece of data. The code below should...

Yeah, it wasn't intended to be used that way, so my guess is it wouldn't work all that well for that. Even performance could become a real issue at...

Something like this may do it for you:

SELECT

tn.ID, tn.Status, tn.Description, tn.[Project Number],

ColNames.ColName

FROM dbo.tablename tn

INNER JOIN (

SELECT 'FreeText01'...

Grant Fritchey (9/4/2013)

---

ScottPletcher (9/4/2013)

---

I admit, this is my pet peeve in physical table design. Identity as clus key is ridiculously over-, and, thus improperly, used. So I get...

Grant Fritchey (9/4/2013)

---

ScottPletcher (9/4/2013)

---

I'd disagree...

I'd disagree even with that;...

Are schema names specified on the tables in the query? If not, what are the default schemas of the two users running the queries?

@DaveDB:

You're quite right. There's no genuinely good reason for the "default" clustering key to be an identity column. Many people just do it by rote, without thinking about...

SELECT

[Database],

MAX(CASE WHEN MONTH(ReportDate) = 01 THEN Size END) AS Jan,

MAX(CASE WHEN MONTH(ReportDate) = 02 THEN Size END) AS...

Patti Johnson (9/4/2013)

---

Thank you so much for your help. I've been digging and digging so I appreciate your time.

IF DATABASEPROPERTYEX('archer', 'Status') = 'ONLINE'

AND EXISTS(SELECT 1 FROM sys.database_mirroring WHERE...