This will produce a 5x5 square of 5, 5-letter words that read the same across as down.

WITH UNIQUEnTuples (n, Tuples) AS

(

SELECT 1, CAST(strcol AS VARCHAR(max))

...

Hope that's not a pun with Easter being nearly upon us.

standardbluecaboose (3/27/2015)

---

s o b a

o l l...

CELKO (3/31/2015)

---

LOL! Remember the quote: "OS/JCL makes sense after you have studied it...

You beat me to it.

I would have gone with the CROSS APPLY TOP method as this is SQL 2008 instead of the self-JOIN.

Phil Parkin (3/31/2015)

---

You've been here long enough to know that you need to post DDL, consumable data and desired results to get a working solution.

See the first link in my...

Not 100% sure I understand what you are trying to do, but I'm assuming your orders always have either one line or two.

Not one of the cleverest solutions I've ever...

sql-lover (3/31/2015)

---

Luis Cazares (3/31/2015)

---

As previously said, you can use a cross apply.

I'm leaving both options. Note that the join needs to calculate all the values before joining and that's why...

ScottPletcher (3/31/2015)

---

CELKO (3/31/2015)

---

.

No. The human eye reads certain words as a single unit called a bouma. The keywords in...

I see you have start and end dates on your relationships.

If you add a new row for an existing relationship, what are the rules regarding the dates?

How is the current...

I believe that this is relational division with remainder:

High Performance Relational Division in SQL Server [/url]

Perhaps like this?

WITH AllCombos AS

(

SELECT ID, KeyName, OrdNo

FROM #left_table

CROSS JOIN

(

...

I'd have to go with something similar to Rafal here but no need for two GROUP BYs:

WITH SampleData AS

(

SELECT ItemID=1, ParentID=NULL, Name='Package A', QtyAvailable=10

...

You can try this. Had to make some assumptions around Jeff's excellent questions.

declare @EmployeeStatus TABLE (

[EmployeeID] [int] NOT NULL,

[EmployeeStatus] [varchar](24) NOT NULL,

[EffectiveDate] [date] NOT NULL

)

INSERT INTO @EmployeeStatus VALUES (11,...

Peter Heller (3/29/2015)

---

Compliments on your article.

If you defined the EffectiveEndDT as DiscontinuedDT your queries would not have to use Isnull. It would be sargable and make the query...

Divide and conquer is what I did in the deja vu link, so if Jeff's right (and he usually is), it might work better for you.