It seems that the issue is around this

if ((Row.DefaultOrgUnitID == null))

A null comparison will always return false (check here: http://msdn.microsoft.com/en-us/library/edakx9da.aspx )

Try this for a workaround

http://msdn.microsoft.com/en-us/library/ms172138(v=vs.80).aspx

GilaMonster (1/8/2012)

---

...

I suspect that part of the problem is that the system can be gamed, companies specifically ticking criteria off in order to meet the requirements of the program rather...

We...

As Gail said, the exam is to test your understanding of what to use and not the intricate details. Also, if you have been doing this kind of work...

Night Fury

Thanks for pointing...

L' Eomot Inversé (1/8/2012)

---

SQL Kiwi (1/7/2012)

---

Ok so this is getting silly: that's four QotDs in a row that I have wrong, and I *knew* the answer to this one! ...

Toothless

SQL Kiwi (1/8/2012)

---

It's weird: it does the same thing in IE9 (which I very rarely open). Oh well, small irritation, it'll probably go...

Radio

Yes you can do that. This article shows how to do that as well.

http://technet.microsoft.com/en-us/library/ms140355.aspx

Here's another twist on the same script

USE MASTER

Go

SELECT cr.DatabaseName

,s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name

,s.nt_domain, s.nt_user_name, c.client_net_address, c.local_net_address

,cr.ObjName

,cr.Query

FROM sys.dm_exec_sessions as s

INNER JOIN sys.dm_exec_connections as c

ON c.session_id = s.session_id

CROSS APPLY (SELECT db_name(dbid) AS...

Nice script indeed.

Temp table method could work. Does your update statement have an adequate where clause?

Is there an index in place that fits the conditions of your queries?

There are several US based companies that provide this kind of service.

The first that comes to mind is http://ntirety.com/