Yes, and HIT a...

Well @@DBTS can technically do what the OP asked. Of course that is only within the scope of a single database (no mention of scope in the original request),...

Greg J (1/21/2009)

---

the table structures for this data nugget are as of yet, undefined. Point taken on "not every second" needed, but we also wanted to do metrics along...

Yes, I have noticed that there is something wrong with the Google search...

toniupstny (1/21/2009)

---

The ms_foreach.. proc is an unofficial method and can be removed at the will of Bill et al. There are also cursors in the ms_foreach... procs,...

Here's one way to do it without the temp table or any loops:

Select callstart

, (Select count(*)

From YourTable t2

Where t2.callstart <= t1.callstart

And t2.callend >= t1.callstart) as OpenCalls

From (Select...

First, you do not need a record for every second, you only need a record for every distinct callstart.

Like this:

Select @@DBTS

Questions for multiple versions should go to the lower version....

You are right, this is generally true. And...

I have never used peer-to-peer replication, so I cannot help you there.

Well assuming that you have SQL 2000 (you're in a 2005 forum, by the way), then you can generate them one at a time in Query Analyzer:

Hit F8 to open...

Heh, maybe I shouldn't post after midnight. But sure, use it if it helps. 😛

Jeff Moden (1/20/2009)

---

Truer words never spoken... it's a pig and I was trying to name the pig. 🙂 I believe the label of "Procedural Mystery Code Requirement" may...

A couple of unrelated things that I noticed:

1) an Activated proc should not need WAITFOR (unless it is looping). It should still be OK the way it is though.

2)...