I'm just going to make my final argument against using the LAG function here, in this case.

What if you start getting data at 30 min intervals? The LAG (and LEAD...

Careful with LAG its only looking at the previous record for the 3 hr window. Your data could be confusing and given your dataset Eirikur solution does work, ...

In your article you quote I see this under ²

Changing the edition of a SQL Server 2012 failover cluster is limited. The following scenarios are not supported for SQL Server...

Please note that the configuration manager alias section is for that computer only it is not an alias for remote incoming connections as the GUI and naming might suggest. ...

duddu.venkataramana (7/5/2016)

---

Hi team,

I am currently working on weather data to see if there is rain in past 3 hours. I have data for 10 years.

The sample data is presented...

PJ_SQL (7/5/2016)

---

I have column with data such as

EQ181

TX 116-3860

How do I split the above in two different columns?

ColA ColB

EQ 181

TX ...

SilentMike (5/20/2016)

---

Thanks Ness but I don't think that solves my problem. The user has the exact same permissions (member of db_datareader only) on another database on the same instance and...

Quinn-793124 (7/1/2016)

---

Hi,

How do you determine of SQL Server 2008 I am on so I can get the same level at 20014 so I don't lose functionality and compatible...

orlando.ramon (7/1/2016)

---

If I have an AD user defined as an SQL LOGIN (AD\john.doe) with sysadmin privilege and is a member of an AD GROUP that is also an SQL SERVER...

Rachel Lee-244397 (7/7/2014)

---

Hi, not trying to hijack this post, but I have a question I cannot seem to find the answer to.

When a user is a member of multiple AD...

homebrew01 (6/28/2016)

---

I want a simple result set from a stored procedure to display in RS.

So when my SP runs

SELECT JOB_NUM, STATE FROM JOBS WHERE STATE_CODE IN ('CA', 'NY')

The rows...

homebrew01 (6/28/2016)

---

I believe I have the state code worked out. Thanks for all the help.

Now working on the lack of results.

The records selected in the stored procedure's SELECT JOB,...

homebrew01 (6/27/2016)

---

BUT ....... Now RS seems to handle the parameters in a select list differently if there's 1 chosen or multiples.

If I select just sate CA, I get good...

Alan.B (6/24/2016)

---

If it's a multi-select then SSRS passes the SSRS parameter values as a comma delimited string.

If user selects CA then 'CA' is passed to the stored proc. If...

E McNeill (6/27/2016)

---

My company has a Quality control program that utilizes MS Access to store quality control data. The computer that runs the quality control is a component computer...