Drum rolls with chocolate. Very few redundant words in all those posts.

Probably the best tool for this is a dynamic cross-tab. Jeff Moden has an excellent article here[/url]. If after reading the article you are still having difficulty, post back.

Dwain, I thought some of that code looked familiar - didn't we mess...

Steve Jones - SSC Editor (12/2/2013)

---

L' Eomot Inversé (11/24/2013)

---

I think the idea of "Core TSQL" isn't unreasonable, but no set of knowlege which is just about T-SQL and not about...

Here's the simplest way. Without further information it's unlikely to be the best.

-- I have an Employee table with Columns:

DROP TABLE #Employee

CREATE TABLE #Employee (EmpID INT IDENTITY(1,1), FirstName VARCHAR(100), MiddleName...

This is likely to be an expensive process whatever you do. What's the purpose?

Jeff Moden (11/29/2013)

---

Not that many people would notice but you can get the code to be almost a third faster by eliminating the (-1) subtraction. Last but not least,...

Jeff Moden (12/1/2013)

---

ChrisM@Work (11/26/2013)

---

Jeff Moden (11/25/2013)

---

To be honest... learning to read minds and to anticipate "what's...

Note that you don't need CTE N6:

DECLARE @startdate DATE, @enddate DATE

SET @startdate = '00010101'

SET @enddate = '99990101';

with

N0 as (SELECT 1 as n UNION ALL SELECT 1) -- 2...

Run the following code, query by query. If you're still unsure, post back.

WITH

N0 as (SELECT 1 as n UNION ALL SELECT 1) -- 2 rows

,N1 as (SELECT 1...

Jeff Moden (11/26/2013)

As a bit of a sidebar, I especially like the one about "make it work, make it fast, make it pretty" except you left off the 4th item...

Jeff Moden (11/25/2013)

---

To be honest... learning to read minds and to anticipate "what's coming" by keeping...

If your hierarchy is likely to remain consistent then this may be more efficient than a rCTE:

DROP TABLE #Entity

CREATE TABLE #Entity (EntityId INT, EntityTypeId INT, Description VARCHAR(100), ParentEntityId INT)

INSERT INTO...

Lynn Pettis (11/20/2013)

---

You should also make sure you understand how...

Here's a simple islands'n'gaps solution as suggested by Koen:

DROP table #temp

CREATE table #temp (SysKey int ,BusName varchar(9) ,BusType varchar(6) ,StartDateKey int ,EndDatekey int )

Insert into #temp (SysKey ,BusName,BusType,StartDateKey,EndDatekey)

Select...