ColdCoffee (3/21/2012)

---

Another question to you, the start and end of the report times (the 2 vairables u have declared), what will the range be? is it a day or a...

Hi Mark!!

Thanks so much for this solution!! The formatting is no issue, and the OfflineTime is easily calculated. I'll be trying this out with some live data and...

Hi Dwayne

Thanks for the post. Your solution looks really good. Your calculation for machineID=1 is a little off though. The first record for machineID=1 and the second...

I've done this before in c#, but the current requirement is that it be in sql. I would have much preferred to do this in client code.

Thanks!! I'd love to see what you can come up with

Thanks Nils!! I'll look into those options. Right now all of my SQL Servers are 2005, but we may be moving to 2008 in the very near future.

-Justin

I'll take it from the lack of responses here that no one knows the answer to this question. 🙂

Does anyone at least have a hint or clue how this might...

I'd like to second Stephen Byrne's question on the first page of this thread. What would be the best way to report errors on specific insert/update/delete operations. Stephen...

Thanks Noel for the suggestion to use a CTP. I ended up modifying just my recursive stored procedure and this is what I came up with.

ALTER PROCEDURE [dbo].[DeleteQueueTree]

(

...

That was perfect, thanks for the help!!

That will count all of the like items in fieldB, but I want to count all of the items in fieldB which match a specific pattern. For example, "Pass_HW"...

Jeff, your cross tab code does not work in my production DB. @sql2 gets filled before it is done consuming all of the run statuses. I have attached...

Thanks for taking the time to look at this Jeff, I really appreciate it. Your example works for the small sample data set in this post, but it...

What I am looking for as the final result which will be displayed to the users of my app should look like this:

Feature Defered Error FAIL ...

Jeff, thanks for you response. Select top 10 from the view gives the following (in ms i believe):

[font="Courier New"]Time Statistics

Client processing time0

Total execution time968

...