What about the undo button?

steve.jacobs (11/20/2013)

---

All:

I thought I had put in the answer "the format indicated in the question is a determination of my regional \ language settings (en-us \ short datetime: M\d\yyyy h:mm:ss...

arkiboys (11/20/2013)

---

yayomayn (11/20/2013)

---

Could be any number of reasons. Is the dev server less powerful than the production one? Are the dev server reports looking at the same database location as...

You cannot use windowing functions (SQL Server 2012), and it is possible set-based solutions are not linearly scalable (in the sense that they get slower and slower...

I've...

Which version of SQL Server?

Is it possible to post some sample data and desired output?

sunil.mvs (11/20/2013)

---

Result as not expected

BusnameBusType(No column name)(No column name)

A AC ...

The intention of the question is very good and it is a nice question, but there are some minor flaws.

I was tempted to select "None of the above", as with...

SELECT

Busname

,BusType

,MIN(StartDateKey)

,CASE WHEN MAX(ISNULL(EndDateKey,99991231)) = 99991231

THEN NULL

ELSE MAX(EndDateKey)

END

FROM @temp

GROUP BY Busname, BusType

Concatenating Row Values in Transact-SQL[/url]

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1515541-21-1.aspx

This one will probably be a good start:

SQL Server 2012 Query Performance Tuning

You'll need to add it yourself. SQL Server is not a magic box where everything rolls out exactly how...

Setting Time-out Values for Report and Shared Dataset Processing (SSRS)