Please provide the expected output for the sample data you provided. Also, you may want to include a second PAT worth of data so we can understand what you...

NO, I did NOT say that!! 🙂 You should use TSQL as necessary...

See if this helps:

CREATE TABLE dbo.#responses (serial tinyint NOT NULL)

CREATE TABLE dbo.#otherdata2 (serial tinyint NOT NULL, variableid tinyint NOT NULL, TextVal varchar(10) NULL)

INSERT dbo.#responses VALUES (1)

INSERT dbo.#responses VALUES (2)

INSERT dbo.#otherdata2...

Let me try to put together a quickie demo to see if what I am thinking will work in this case. I have come across your situation before so...

One question: is the numeric value that indicates each "type" of value fixed? If so I think I can come up with something to get what you need in...

You want this one Sean?!? You are WELCOME to it!! 😛

Sean Lange (8/21/2013)

---

EAV...

Looks like some very ugly EAV crap..., er, design. 😀

BTW, I don't need (or want) any type of production data. Simple dummy stuff that matches requirements is best...

I would have appreciated a warning to take a deep breath and be sitting down before I opened up that file and saw the query therein!! :w00t:

erikd (8/21/2013)

---

Sean - yeah, I sort of figured. I was hoping there was a general rule for a situation like this. Assuming I'm just looking for direction and not a...

aykut canturk (8/21/2013)

---

dear friends,

I'm just confused about varchar and nvarchar types. I learned that nvarchar holds unicode character sets and varchar cannnot. varchar doubles the size. thats fine.

What I confused...

lisa.ogle (8/21/2013)

---

Not sure why but any suggestions?

Select Distinct

M.Memid,

M.Fullname,

E.enttype,

EK.planid,

Ek.Carriermemid HICN,

EK.effdate EffectiveDate,

BP.upid ContractPBP,

PA.CreateDate,

PA.Comment,

PA.[Source],

PA.CompleteDate

From dbo.Member M

Left Join dbo.Entity E

on E.entid=M.entityid

Join dbo.EnrollKeys Ek

on EK.Memid=M.Memid

Join dbo.BenefitPlan BP

on BP.Planid=EK.planID

...

Even IF your 2 queries are logically equivalent (which I am not going to bother to figure out), the optimizer is just like any other piece of software. It...

erikd (8/21/2013)

---

Hi,

A bit of a general question:

I have a query with 28 LEFT JOINS. 20 of them join one table to the original query in order to break information out...