Stefan Krzywicki (5/30/2013)

---

Lynn Pettis (5/30/2013)

---

Anyone else get a PM like this?

patricio.honore (5/30/2013)

---

I would like to display x amount of views (50) as a report and display which views that have...

Anyone else get a PM like this?

patricio.honore (5/30/2013)

---

I would like to display x amount of views (50) as a report and display which views that have not been accessed and...

It may help to know what the function does and how it is used, can you post some code?

Okay, rereading everything. The first record that is counted starts the 60 minute window, subsequent records that are overlapping do not extend the window.

This correct?

Reran my code and in looking at the results from MM code I have to ask why the last row is being counted when it overlaps time wise with the...

rrn 62873 (5/30/2013)

---

Sean Lange (5/29/2013)

---

dan-572483 (5/28/2013)

---

How about in a WHERE EXISTS clause?

According the the Querying SQL2012 exam prep book, a SELECT * inside an EXISTS clause returns true or false...

Scratch, something happened here need to work it again.

Tweaked mine so that it returns the same results as Eugene's. Having a different set of data with other possibilities helped. Again, run the following in an empty...

shrsan (5/29/2013)

---

Hi,

Am trying to give dynamic date to SP that would be first of every month. 5/01/2013 for this month can any one help me with the sql expression? i...

Maybe this (be sure to run it in an empty database first as I drop the table you created):

CREATE TABLE [dbo].[la_test_endcall](

[pmd_patient_id] [bigint] NOT NULL,

[endcallcd] [int] NOT NULL,

[eventid] [bigint] NOT NULL,

[createdat]...

What is the result set you are looking for based n the sample data provided.

A guess, the oldest file was locked or in use for some reason when the delete was attempted. If that delete fails it isn't retried later. I think...

You might check out EMC. There was a company here in town that developed something like this iirc and EMC bought the company a few years ago. I...

CheeseheadDBA (5/29/2013)

---

Your original suggestion works great when the parameter passed in returns no results - which was my original question that you've successfully answered. I was just providing more...

I'd start here: http://msdn.microsoft.com/en-us/library/bb933866(v=sql.100).aspx.