Bob Hovious (12/31/2008)

---

You're welcome, Jason, and Happy New Year. 😀

While you are doing your homework on FOR XML, be sure to look up nested queries in conjunction with PATH....

Bob Hovious (12/31/2008)

---

Hey Jason,

After Matt's comment in your other post, I realized that there was a much better way.... using SELECT/FOR XML. The query at the...

Here's my not so elegant working solution:

element Name

{

if ( empty(sql:column("PhyFName") cast as xs:string? ))

then...

Cleanliness. The example I gave was very simplified. The actual data has lots of fields where one of...

BINGO!

Found the process that was blocking it and KILLed it! Looks like it was some old mail merge connection or something.

Thanks so much!

Jay

Alan (8/4/2008)

---

If your are on a domain the easiest is to create an account DOMAIN\[This task user] and if possible avoid mixed mode. Security is much easier to maintain this...

btw... Thanks for the superfast replies, guys!

Jay

Alan (8/4/2008)

---

This probably is an issue with what user the agent is running under Local Service this user will not be recognized by the other machine and the operation will...

That KB article looks to be...

Intriguing.

Thanks for your insight. I ended up doing things a little differently:

Rather than generating a number and matching that to a serial number for a particular record, I decided to simply select...