KEEPNULLS will keep any NULL value as in what would be in column C here ... "A,B,,D"

But your data has a value, and that value is the word "NULL".

I do...

A few notes/comments/questions:

1. Is this for a trigger, it appears so?

2. Where do the other variables get set? @ptFlagIndicator1Var, @ptFlagIndicator2Var, etc...

3. The "simple update" at the end IS relevant to...

Can you post your "other" actions. There may be a way to solve your problem without a cursor.

Try thinking "SET BASED" and apply the select/update to the result set of...

Lookup PIVOT in BOL. It will get you part way.

You can still use the pivot summing on an irrelevant column, and ignore it.

ARGH!

You would be much better off moving this out of the trigger.

As in .....

Have your trigger insert the PK values for the updated records into another table along with a...

That's what I've ended up doing. Although to be dynamic is taking some more work.

Craig Farrell (3/24/2011)

---

CELKO (3/24/2011)

---

<snip>

SELECT A.column_a, A.column_b

FROM TableA AS A

LEFT OUTER JOIN

Flagged_Records AS FR

...

Modify my previous script to use a temp table instead of a table variable, and it will work.

I think I've found a Question of the day to submit. 🙂

OK, So this is not a complete answer. But it now has me asking WTF?

The code below SHOULD work, at least from what I can see it should. You'll see...

EVERYONE thinks I'm...

Tara-1044200 (3/18/2011)

---

I had a server where in disks were pulled out by the network team and on one of those disks tempdb was sitting. Now i can not strt the...

change it to ..... ORDER BY gpm.GMPI)

What makes them unique?

Can you post sample data/DDL scripts?

It's much easier to assist if I have sample data.