Try something like:

declare @x varchar(2000)

set @x='<Emp>

<Details>

<D N="Id" V="1235" />

<D N="Des" V="SW" />

<D N="name" V="AAA" />

<D N="name" V="BBB" />

<D N="name" V="CCC" />

<D N="name" V="DDD" />

</Details>

</Emp>'

;with XMLCTE as (select...

You can use the MAP toolkit to detect them:

http://blogs.technet.com/b/mapblog/archive/2012/11/08/discovering-sql-server-using-the-map-toolkit-8-0.aspx

While the order of closing is wrong, I might also point out that you aren't FETCHING the next DB inside of the loop, so you're pulling one DB, cycling through...

Jeff Moden (12/10/2013)

---

+1 to that....

Perhaps it's me but the primary flaw I noticed is that this is an attempt to use a de facto individual ranking system to measure performance in a team...

Jeff Moden (11/22/2013)

---

David Burrows (11/21/2013)

---

WHAT :exclamationmark: Are you a bad VB6 programmer now

And after everything you said about CLR sheesh :rolleyes:

p.s....

I'm not involved in monitoring jobs anymore, but our ops folks use an enterprise scheduler tool called JAMS to run and monitor all SQL jobs.

http://www.jamsscheduler.com/%5B/url%5D

They seem to be fairly...

Are you SURE nothing changed in the code?

The likely culprit looks to be here:

DECLARE cursorlpn CURSOR FOR

select AccountID from Addresses

where country = 'HR';

I'm making a giant assumption, but how...

Eric M Russell (11/12/2013)

---

Tom Bakerman (11/12/2013)

---

Jeff Moden (11/12/2013)

---

Oddly enough, I believe that's part of the problem with delivered software, today. ...

openQuery() should also allow you to push the execution onto the remote server (which would be registered as a linked server). This does then become a rather large dynamic SQL...

Tom John-342103 (11/7/2013)

---

Still, the concept of delivery good-enough (if that is what "a little bit clunky" means) is valid and correct since good-enough today is better than perfection a year...

It's looking for ProductDescription nodes that have one or more features nodes as children. For those ProductDescription nodes it returns the content of the Summary element.

I kind of get what you're going for, but it kind of looks like some pieces are missing. For one thing - you would usually have a reorder/restock level...

blasto_max (10/30/2013)

---

Matt Miller (#4) (10/30/2013)

---

Two ways to do this:

1. the SSIS route - use the flat file connector to make SSIS aware of the generic content. then use a...

Two ways to do this:

1. the SSIS route - use the flat file connector to make SSIS aware of the generic content. then use a conditional split based on...