I would almost certainly do this using Union All instead of Joins.

select Col1, Col2, Col3

from TableA

union all

select Col1, Col2, Col3

from TableB

union all

... and so on through the tables...

You can add...

I would definitely include scheduled downtime as downtime.

If backup servers, etc., can keep things up for customers/employees/etc., then it's not downtime for the database, which is what really matters. ...

You're welcome.

Yes, it's currently defined as adequate to know that a change was made. What happens if a row is changed five times in two minutes by four different people?

I'm...

Like Gail, I'd be inclined to split the triggers up. SQL Server will want to have execution plans for them, and multiple internal branches generally result in expensive plans....

;WITH MaxDates (OrderID, MaxDate) AS

(SELECT OrderID, MAX(OrderDate)

FROM MyTable

GROUP BY OrderID)

SELECT T1.*

FROM MyTable AS T1

LEFT JOIN CTE

ON T1.OrderID = CTE.OrderID

AND T1.OrderDate = CTE.MaxDate

WHERE CTE.OrderID IS NULL;

The "CTE" (Common Table Expression) picks...

select EmpID, min(Date)

from MyTable

group by EmpID;

Does that do what you need?

What's the "max order date"? Is that a column in a table? A variable? An input parameter?

You can, but it's not necessarily going to benefit you. The 1-file-per-CPU thing is more of an urban legend than a valid solution, in many/most cases.

Check this for details:...

You have to change to Ragged Right instead of Fixed Width. Fixed Width is for mainframe output, which doesn't use row delimiters.

SSIS does this easily. You specify which sheet to export to in your Excel Destination object in a Data Flow definition.

On the question about Query Designer, no. Microsoft pretty routinely hides their code.

It wouldn't be that hard to take an execution plan and turn it into a query in...

You can break up queries like that by doing the IsNumeric query to populate a temp table, then doing the rest of the action on the temp table, or by...

Brandie Tarvin (1/27/2011)

---

Is anyone here a member of itSMF?

If so, what are your thoughts on the organization?

My employer is sponsoring membership and I'm trying to figure out whether it's worth...

GilaMonster (1/26/2011)

---

Wasn't the snow. I missed most of it too,...