kiril.lazarov.77 (5/14/2015)

---

Thank you so much for your help.

I'd appreciate if you could show me how to overcome the issue when there are +2 missing records. So if there is...

WayneS (5/14/2015)

---

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when...

Hi again. Forgot to mention something.

ID/Category 2/Y was quite problematic because there was no data for 2015-05-11. You can see where I used LEAD to pull that data...

You can try this but I won't guarantee it will work with your real data.

WITH DistinctDates AS

(

SELECT [Date]

FROM @T

...

tom.w.brannon (5/13/2015)

---

Sorry. I thought I was replying to Dwain's posted answer rather than making a general post. The first answer posted by Phil Parkin works with a tweak....

Which one?

WITH example (LID, BoxCount) AS

(

SELECT 1, 2

UNION ALL SELECT 1, 2

UNION ALL SELECT 1, 2

...

Perhaps this will work too?

with data as (

select 1 as A, 1 as B, '2015-01-01' as DTE union

select 1 as A, 1 as B, '2015-01-02' as DTE union

select 1 as...

Alan.B (5/12/2015)

---

I love this article Dwain. Very good work as always. 5 stars from me. I particularly enjoy how your hierarchies example - very clever.

I do want to add...

Gary Harding (5/12/2015)

---

I've hit a few problems in the past using scalar UDFs in CHECK constraints.

The main one is that the constraint didn't always fire.

If the column(s) passed into the...

Oh yes. I'm simply reporting here how these things can be done.

Other than the notation I made above from Paul White, I can't report on any of the dangers...

Nathan Davis-411378 (5/11/2015)

---

Do check constraints using UDFs have the same potential issues with different transaction isolation levels? (If not, then I assume that a scalar udf in a check...

Before anyone gets the chance to call me on this point, I ran across this bit of information after submitting this article, provided by Paul White in his blog:

"Any reference...

Hi again Serge! I wanted to confirm your findings and see just how much the data in play causes timing differences. So I built my own test harness,...