Ok, this may not be the best or cleanest... but is the best I could do quickly:

;

WITH bt_rank (

ID

,TECH_MODE_ID

,begin_time

,newGroup

)

AS (

SELECT id

,tech_mode_id

,begin_time

,RANK() OVER (

ORDER BY begin_time

) - RANK() OVER (

PARTITION BY...

Lynn, I think I have seen you do something like this before. Like a nested bunch of different rank functions? Hmm...

You understand why that is not working, right? Because you want the TECH_MODE_ID to be ranked differently if something occurred between the same one. You are going to have...

Can you post what you have tried already? I'd love to help, but I'm not just going to do it for you if you know how the functions work (I...

No worries 🙂 Just easier to keep the whole story together, even if it is more reading. I am certainly not an expert in analyzing these waits, but I'm sure...

Click on the SQL Know-It-All in my signature and you will see that my most recent (although not that recent) post explains the different rank functions.

Ok, so you know what you need to do... Now what is the question? Have you tried anything?

Can you post the wait types and query that you used to get them (the same spreadsheet from the other post the query I'm guessing is from Dave Pinal)....

Hi, thanks for posting the DDL. However, I don't know what your question is or what logic you are trying to query on.

Please don't cross post. Address replies to this thread http://www.sqlservercentral.com/Forums/Topic1310604-391-1.aspx

michaeljharper (6/13/2012)

---

Hi guys, I've configured my router and firewalls so that I can connect to my SQL server from any computer in my home network, how do I access it...

Varun R (6/13/2012)

---

GilaMonster, That is a very good question. We are doing a kind of data ware housing , here we are creating set of tables for reports.After running this...

So, I use C#. The report page uses this class:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class someClassName : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs...

SQLKnowItAll (6/13/2012)

---

I create an SQL Authentication user (something like reportUser) and use those credentials for the reports. The website controls which individual's logins get to view which reports, but...

I create an SQL Authentication user (something like reportUser) and use those credentials for the reports. The website controls which individual's logins get to view which reports, but all...