j.heidrich (1/21/2014)

---

Many thanks for your anwers.

I tried the two different approaches from dwain.c with my sample table with 100k nvarchar(50) strings. On my machine with Win 8 64, SQL Server...

OK, so the purists will argue that LAG is overkill, and for them I offer this instead:

WITH SampleData AS

(

SELECT code=CAST('12333345566689333' AS NVARCHAR(4000))

UNION...

Just to be different, and seeing as how we are in the SQL 2012 forum which allows me to use LAG, I will offer this:

WITH SampleData AS

(

...

So you've posted DDL which is a good start:

And expected output in the pretty table you posted. ...

LAG/LEAD, while interesting, are...

rcnewcomb 53012 (1/20/2014)

---

I also keep track of how many times a stored procedure has been run. This comes in handy for performance tuning. I can look over the past year...

First of all, thanks to all for reading the article and providing feedback.

I have to agree with Charles in that error handling in SPs can be a bit tedious and...

I agree that you've done some very thorough testing here. Excellent work!

I wasn't sure how you...

I'm sure that this can be improved upon but it was fun while it lasted.

WITH DupItems AS

(

SELECT WONum, ItemCnt=MAX(ItemCnt)

FROM

...

Perhaps something like this might help?

CREATE FUNCTION [dbo].[ProperCase]

(

@MyStr ...

Jeff Moden (1/16/2014)

---

dwain.c (1/16/2014)

---

As for the 2012 code, I'm actually disappointed to see those results and wouldn't call it an "improvement" to the optimizer at all. It seems to...

I'm curious if there's any danger to doing something like this:

DECLARE @sql VARCHAR(MAX) =

(

SELECT 'DROP TABLE ' + STUFF(

(

...

My cat Grumpy will not be pleased that you left him out. 😀

Why can't you just add up the 7 days and show that as the Total?

Or do you need to update the Total column in the table?

It would be nice if...

I must say, I love the technique Jeff! Very simple, straightforward and clean with good performance. Nothing more straightforward comes immediately to mind (issues noted above aside).

Normally I...