Sean Lange (6/14/2016)

---

Luis Cazares (6/14/2016)

---

Sometimes I just want to post RTFA(rticle).

People are given answers with an article that explains the solution, but won't bother reading and keep posting saying...

Thanks for the feedback!

davidlester.home (6/14/2016)

---

I did eventually get this to work, though it makes little sense. It turns out that dropping all the indexes on the table was the answer. With indexes the...

Except for Period 1, you're choosing the max version per period (which is easy, see below). Why is this? What are...

This batch looks horrendously overcomplicated for what it's doing. Why can't you...

Jeff Moden (6/13/2016)

---

patrickmcginnis59 10839 (6/13/2016)

---

Jeff Moden (5/25/2016)

---

krypto69 (5/25/2016)

---

Hi,

I have a pretty simple update statement:

UPDATE eligibility

SET primary_plan = 0

FROM temp_eligibility e

WHERE eligibility.eligibility_id = e.eligibility_id

This statement is updating around 7 million rows....

Y.B. (6/13/2016)

---

That was a great article Gail! Thanks for sharing, It's one of those subtle things most probably learn the hard way.

So with that in mind here is update...

Y.B. (6/13/2016)

---

Maybe something like this would be better suited...

IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)

UPDATE SomeTable SET SomeText = @SomeText

ELSE

INSERT INTO SomeTable VALUES (@ID, @SomeText)

EDIT: Although this...

The two queries use different filters on the IDENTITY_MAP table. The first query (database sem5) uses

d.Name like '%New Denmark%' in the FROM list and

d.Name like '%New Dmark%' in...

That's the ticket! Nice job.

durga.palepu (6/13/2016)

---

Thanks for the quick response!!

However this solution is not serving the purpose.

meanwhile I have tried and my solution is as followed, the problem with solution is unique record(s) from...

There are some amazing dev sessions and I really wanted to go, but it would have meant buying the time off, and being so close...

It's a curious expression isn't it. Never used in US or UK English, it seems to...

Nice one, Luis 😎

If you don't like the PIVOT operator, you could use a cross tab query instead:

SELECT TOP(50)

tf.formid,

tf.formdate,

x.*

FROM tbl_forms tf

CROSS APPLY (

SELECT

[field-0-1] = MAX(CASE WHEN tff.filtertype = 0 AND tff.id...