SQL Server Configuration Manager does not list databases, as far as I can see. So what do you mean by this:

The SQL Configuration Managers shows them as stopped

?

Thanks, Grant. To be honest, I'd probably have...

I...

Is there anything obviously different about this report, when compared with other reports which are working OK?

Scott and as1981, thank you for taking the time to respond.

These responses at least suggest that I did not miss anything obvious.

Unless I have misunderstood, CDC does not achieve what...

• This reply was modified 4 years, 10 months ago by Phil Parkin.

MaryWard, this is a SQL Server forum. Moving data to Excel and processing it there is a really bad idea!

One problem I have seen before with SSIS and VCSs is that people sometimes make changes which affect the project file (eg, add or remove parameters, add or remove packages)...

• This reply was modified 4 years, 10 months ago by Phil Parkin. Reason: Added clarification

What makes you think that this is a TFS issue?

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating...

OK, that is enough.

My previous 'yes' answer does depend on there being a link (eg, PersonId) between all of the rows which are associated. If there is no link between the different rows,...

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...