Thank you Steve for this article, very good job indeed.

😎

Another quick solution, details in the comment

😎

CREATE PROCEDURE dbo.USP_LIST_TABLE_AS_EAV

(

@DB_NAME SYSNAME = N''

,@SCHEMA_NAME...

Not too bad twin.devil but there is still room for improvement

😎

Test harness

USE tempdb;

GO

SET NOCOUNT ON;

--/*

IF OBJECT_ID(N'dbo.ExchangeRate') IS NOT NULL DROP TABLE dbo.ExchangeRate;

CREATE TABLE dbo.ExchangeRate

(

...

Alvin Ramard (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this...

Luis Cazares (12/28/2015)

---

It seems like your code can be rewritten like this

SELECT *

FROM TblMain m

Where EXISTS ( SELECT 1

...

I think Jeff has a pint point here with the anti XML and SSIS garlic, keep it around your neck and you will stay healthy:-D

😎

Something tells me that things have...

Phil Parkin (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously...

GilaMonster (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

The set based code implies a hash aggregation while the loops can utilize stream aggregation as there is effectively no partitioning in each loop's execution. Makes quite...

Phil Parkin (12/29/2015)

---

Grant Fritchey (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence...

Tom Staab (12/29/2015)

---

Eirikur, I completely agree about the month formatting. That kind of thing is definitely not preferable. It was only done to try to make the output the same...

GilaMonster (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review...

GilaMonster (12/29/2015)

---

BrainDonor (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical...

Tom Staab (12/29/2015)

---

Thanks for the response, Eirikur. You are correct that I missed the TRUNCATE with the set solution. I'll look into correcting that later today. Regarding your 3 points...

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review and the lack...

djj (12/28/2015)

---

Ed Wagner (12/25/2015)

---

Brandie Tarvin (12/25/2015)

---

I'm genuinely curious how you manage that when all the hotels...