You need another list variable, like @cols, but built with the ISNULL in it.

So, for example if @cols contains:

[col1],[col2]

Then @selectCols needs something like:

ISNULL([col1],'') as [col1], ISNULL([col2],'') as [col2]

and then use...

As I said, WE are guessing - you shouldn't be .

If you don't understand...

You haven't supplied enough information, but you just need to figure out the correct join.

My guess is that because sorels has costs in it that they might relate to items...

I only use SSMS 2012 - do you have a build for that?

Do you have any screen shots or description of what it does?

If you really want to stop bulk updates from triggering Lowell's code (please use his code - yours is broken)

...Just put

IF @@ROWCOUNT>1 RETURN

at the start of the trigger...

Funnily enough I submitted a QotD recently covering a very similar problem, so you will all get your points on that one...

As far as I understand it, the cause of...

I would guess that a rendering problem like that will be due to IE9.

Have you tried a different browser and/or compatibility mode toggling?

dwain.c (7/22/2013)

---

L' Eomot Inversé (7/22/2013)

---

Just as described, but if I'd realised who wrote it I would have made...

Hi Tobar,

If you would like to try out an addin for 2012, send me a PM with your email address.

If you post your query, it will be much easier to help.

You're welcome.

SELECT control_id, COUNT(*) AS total_count, SUM(CASE WHEN action_details like '%Fail%' THEN 1 ELSE 0 END) as error_count

FROM history

group by control_id order by control_id

Tobar (7/18/2013)

---

The functionality I would like is to be able to "right click" in the display panel and say "Lock display". When the session is closed, not just the display...

I don't believe you can use GETDATE() in that way as a default parameter value.

Try setting a default of NULL and replacing that NULL in your code with GETDATE()

It helps if you provide your data in a re-usable format , such as this:

with data(ParentItem,ChildItem,Qty)

as

(

select '2338-87468-00', '62338-77961-20', '45.333' union all

select '2338-87468-00', '62338-77961-18', '45.333' union all

select '2338-87468-00',...