davoscollective (11/5/2013)

---

Great article, thanks for sharing. I've used similar constructs for flexible SSRS reports. I learned a few nice tricks, I particularly like the @debug and the line numbers, very...

Jeff Moden (11/5/2013)

---

I assure you, it's just words from some serious pent up frustration...

For what it's worth, I'm in favor of a selective culling of the gene pool. 😛

Jeff Moden (11/4/2013)

---

dwain.c (11/4/2013)

---

Jeff Moden (11/4/2013)

---

You're using NVARCHAR(MAX) for a housenumber???? In SQL Server 2008???? Why?????

You probably don't release it but you cannot rebuild a...

Jeff Moden (11/4/2013)

---

You're using NVARCHAR(MAX) for a housenumber???? In SQL Server 2008???? Why?????

You probably don't release it but you cannot rebuild a clustered index in...

The RIGHT JOIN to the...

I can't get to the SQL Fiddle page but I can say that the BETWEEN clause suggested in the below query is not a suggested best practice when evaluating for...

Keith Tate (11/4/2013)

---

Is this a homework assignment? The people here are usually not going to do your homework for you, but if you make an attempt at doing the work...

Here are 2 ways that are essentially identical:

WITH SampleData (houseno) AS

(

SELECT '3-13-1'

UNION ALL SELECT '3-13-3/a'

UNION ALL SELECT '3-13-3/b'

...

Sheet1 (referenced as Sheet1$) is the default name for a worksheet in Excel.

Are you sure that you did not rename that worksheet to something else?

Try moving HAVING to after GROUP BY.

I'd have to say that's about the least work I ever had to apply to a forum question to get a thank you.

But you're welcome!

Depending on what you want to retrieve from the selected row, you may want to consider doing it like this:

SELECT DocumentNum, LineNum, VersionNum, CustomerNum

FROM

(

SELECT DocumentNum, LineNum,...

Perhaps something like this:

WITH SampleData (cust_string) AS

(

SELECT '11-12 Midwest Plumbers 099'

)

SELECT cust_string, EffectiveYears, CustNo

,CustName=SUBSTRING(

cust_string

...

Not sure if this is still helpful but here's a pretty straightforward way to convert YYYYMM to a DATETIME:

DECLARE @YYYYMM VARCHAR(6) = '201203';

SELECT CAST(STUFF(@YYYYMM + '-01', 5, 1, '-') AS...