Yes, there is. If you want working code, you know the drill: please provide DDL and sample data in the form of UPDATE statements.

In case it helps others, here is a formatted version.

<Employees>
<Person>
<ID>1000</ID>
<minor>yes</minor>
</Person>
<Person>
<ID>1001</ID>
<minor>yes</minor>
</Person>
<Person>
<ID>1002</ID>
<minor>yes</minor>
</Person>
<Person>
<ID>1003</ID>
<minor>no</minor>
</Person>
</Employees>

Thnaks and sorry for not adding this

So in this example I would want Black 2 and red 1

<Data> <Others> <members> <Name>adf</Name> <Color>red</Minor> </members> <members> <Name>adf</Name> <Color>black</Minor> </members> <members> <Name>adf</Name>...

Hi

How do I find a count of a specific value in XML?

data.value('count(/SampleXML/Colors/*)', 'int') finds all

so say Black in [1] and Red in [2] and Black in [3]

How do I...

What sort of help do you want?

Hi all,

I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail.

I need to create one more SQL...

Phil,

The caller is the same for another packages that are running ok, in the connection string it has a username and password with sysadmin privileges to connect to the...

If you look at the Overview page of the All Executions report, you will see at the top right a property called 'Caller'.

Can you confirm that the user mentioned here...

Phil, the SET RESULTS SETS is outside of the procedure and used to re-define the output of the stored procedure. I just learned that today as I have never...

The important clause is WITH RESULT SETS, not SET RESULT SETS, and if your data source stored proc is returning data from a temp table, its presence is mandatory, to...

Regarding this

A OLEDB source with an stored procedure with RESULT SETS specified

I just want to check. Is 'WITH RESULT SETS' within the stored proc itself, or do you have

EXEC PROC...

You can filter out services which are not set to start automatically by referencing the ServiceStartMode enum. That might be the closest you can get to 'in stopped state...

What does your script do?

Use XP_DIRTREE instead?

Check here for some ideas.

It sounds like you need to introduce a queueing system. The execution of the proc needs to be decoupled from when the web service triggers.

Your web service adds entries to...

OK, so can you change the process which triggers the execution of the proc so that it executes only one instance at a time?