Thanks Grant, it does. Is it a good assumption that...

We utilize SSIS and the "Server Overview" articles written here (now I have to go look it up so I can post the link). A job fires off this package,...

A trigger would work. You could also just run a job every 1 or 2 minutes to check for the presence of data, and do it's work if it's there.

Hey gang - can I get your thoughts on using TFS to deploy database changes?

Thanks!

You might want to read my article that covers this at SQL Server Ranking Functions[/url]

Try any of Louis Davidson's books. He is extremely good (I had the opportunity to work with him over a decade ago - he is very sharp, and has only...

CirquedeSQLeil (11/4/2010)

---

Grant Fritchey (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that...

Chad Crawford (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that...

K. Brian Kelley (11/4/2010)

---

Here's where things get really nice. If you assign a permission at a scope level, such as GRANT EXECUTE ON SCHEMA::dbo TO ReportingUser, then any object contained...

Check out the SubString, PatIndex and CharIndex functions.

Others that may prove useful to this are Left, Right, and Reverse.

You are still building the tally table Row-By-Agonizing-Row (RBAR).

It would be better to do it in a set-based fashion, such as is described in the article that I referenced in...

I agree.

ceiling...

This...

Taking what GSquared and Jason suggested, try this out and see how it works for you.

SET @Seconds = DATEDIFF(second, @StartDate, @EndDate);

WITH CTE AS

(

SELECT TimeOfDay = DATEADD(second, N, @StartDate)

FROM...

You're welcome.

Sure, it can be done with a PIVOT. Actually, that is a pivot, it's just not using the PIVOT clause....