LOL! A 5 year old thread?

Well, since you brought it up, this is how I do it.

Logging and Error Handling for SQL Stored Procedures [/url]

Alternate approach:

CREATE TABLE #table_Data(

[idx] [int] IDENTITY(1,1) NOT NULL,

[crtDte] [datetime] NOT NULL

) ON [PRIMARY];

DECLARE @StartDT DATETIME = GETDATE();

INSERT INTO #table_Data

VALUES (@StartDT-3),(@StartDT-1)

,(DATEADD(minute, -10, @StartDT))

,(DATEADD(minute,...

WITH Alphas AS

(

SELECT a

FROM (VALUES('A'),('B'),('C'),('D')) a (a) -- use 22 letters

),

Numbers AS

(

SELECT n

...

Recursion is not needed here if this is really being done in SQL 2012.

SELECT MACHINE_NUMBER, VALUE, EVENT_DATE

FROM

(

...

Wayne West (4/21/2015)

---

Dwain, that first code worked perfect, the second one only has D/N/P/Y appearing for district 000, which may or may not work live. Since the first one...

There is a Definition of the Microsoft Excel method for its PERCENTILE function on the linked Wiki page.

This implements that definition (not checked for all cases) and seems to return...

I was afraid you were going to say that.

One of the issues I encountered...

Sean Grebey (4/20/2015)

---

Lol I feel like it was an easy question but I'm also...

Jeff Moden (4/20/2015)

---

dwain.c (4/20/2015)

---

Jeff Moden (4/20/2015)

---

Thanks...

Jeff Moden (4/20/2015)

---

Thanks for that link....

Too bad you're not in SQL 2012. It is not often that Itzik Ben-Gan writes an article with a name so close to your thread's title.

The Last non NULL...

In SQL 2012 there is a function PERCENTILE_CONT that will do this for you.

At PERCENTILE_CONT(0.5) this is the median. Which can be calculated like this:

An Even Faster Method of...

You were 90% of the way there:

CREATE PROCEDURE YourProcName

(

--DECLARE

@dtstart_time DATETIME ,

@dtend_time DATETIME

)

AS

BEGIN

SET NOCOUNT ON;

DECLARE @parts TABLE

...

I'm agreeing with twin.devil here. Just make filename a column in one permanent table.

With regards to your thread's subject:

The only stupid query questions are the ones you don't ask.