Must've indeed. Try this:

;WITH MyModules AS (

SELECT m.ModuleID, Caption, SourceName, MenuLevel, ParentID

FROM #Modules m

INNER JOIN #ModuleRight mr...

Worthy of mention, if you do opt to add a Calendar table, either of the proposed FUNCTIONs will make short work of populating it.

Any way you choose to accept it,...

I'm not seeing the same results as you. Try this:

CREATE TABLE #Modules

(

ModuleIdint,

Captionvarchar(20),

SourceNamevarchar(20),

MenuLevelint,

ParentIdint

)

insert into #Modules

Select 1, 'Test 1', null, 1, 0

UNION Select 2, 'Test 2', 'Form2', 2, 1

UNION Select...

Can...

ALZDBA (6/29/2012)

---

1)...

I learn something new everyday from reading this site and posting solutions to questions.

Vijay - I think we can be a little more succinct and avoid any unnecessary temporary tables like this:

;WITH MyModules AS (

SELECT m.ModuleID, Caption, SourceName, MenuLevel,...

Another, albeit awkward but likely method to achieve this is to convert the column containing 6-8 to a computed column like this:

SELECT GradeRange='''' + GradeRange

When you paste that result into...

An alternative to a Calendar table, is to use a FUNCTION to generate the calendar.

Like the one Jeff Moden gifted me with here: http://www.sqlservercentral.com/Forums/Topic1320527-392-2.aspx#bm1322829

Be sure to use his and not...

+1 to Chris for trying!

I guess now I'll need to check whether I'm using the right version of DelimitedSplit8K!

Madhivanan and Jason,

Thanks for your interest and I hope that you find something in the work that will serve you well.

And GPO - thanks for stopping by again. The...

CELKO (7/4/2012)

---

Beautiful piece of work! I have needed thius for along time and shodul drop it into one of my books.

A million years ago, DEC was a conpany that made...

Lynn Pettis (7/3/2012)

---

Steve Jones - SSC Editor (7/3/2012)

---

Lynn Pettis (7/3/2012)

---

Steve, I apologize for my latest rant to Mr Celko. I have tried to restrain myself since you asked me...

ChrisM@Work (7/4/2012)

---

dwain.c (7/4/2012)

---

I just made the most awesome discovery while using cascading CROSS APPLYs so I thought I'd post it here.

Did you know that inside the CROSS APPLY if you...

Apology accepted!

Still no joy on hitting the optimal solution though. It seems I'm short by one doublet and one triplet. My current results are:

1. 15 doublets (30 districts)

2....