Personally (if at all possible, I don't know the systems you are working with) I would look at making the stored procedure Rpt_ItemWhereUsedSpTest output what you want in the first...

Tom,

Allow me to help you out a little here, you forgot your xml tags...

<?xml version="1.0"?>

<Tom>

<Action="Rant">

<Subject="ProgrammingFoolishness">

L' Eomot Inversé (10/18/2011)

---

Good interesting question.

Just shows...

I guessed it would be different due to some kind of precision thing - I now understand why that is the case.

Not sure where this will come in handy for...

Cheers 🙂

Wrey! that worked thanks 🙂

I'm still confused as to why doing a BACKUP makes it immeidiately ask to be RESTOREd?!?

strange. I think I need to do some reading on the...

ok thanks I shall have to read up on tail logs, so how do I tell it to stop recovering?

Chris Umbaugh (10/11/2011)

---

I also had never heard of EXCEPT and INTERSECT and learned a lot from this QOD. I even had an opportunity to employ INTERSECT in a QA query...

Absolutely. I would normally include...

wware (10/11/2011)

---

I honestly never heard of EXCEPT or INTERSECT before either. Seeing them today for the first time, they work exactly as I'd expect them to. I can...

I'm very glad to see that so far no-one has answered '3' 😀

thanks.

as for union all, it makes no odds for the purpose of this example or if you're trying to get...

thanks, I hadnt either. I discovered it during a brain fart moment - I couldn't workout how to do...

vk-kirov - thanks for your excellent explanation - much better than mine 🙂

LOL that would mean that my colleagues could...

Steve Jones - SSC Editor (9/23/2011)

---

This is why I think everyone should have to do C that writes code. Not that sysadmins necessarily need to, but devs/DBAs do. I think...