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...

sathiyan00 (10/8/2013)

---

but even this is also taking more time for 25K records.

with Improved SQL 8K “CSV Splitter” Function its taking around 25 sec

with xml its taking around 30sec

with substring its...