This works:

DECLARE @XmlTable TABLE (ID INT NOT NULL, XMLDATA XML)

INSERT INTO @XmlTable VALUES(1,

'<updateProfilesRequest xmlns="http://www.fictivewebsite.nl/ops/updateProfiles/v1.0">

<updateProfile >

<fullRelation>

<initials>J. M. C.</initials>

<lastName>Fictive_last_name</lastName>

<gender>Female</gender>

<phoneNumber>

<areaCode>0184</areaCode>

<number>617896</number>

</phoneNumber>

</fullRelation>

</updateProfile>

</updateProfilesRequest>');

WITH XMLNAMESPACES(DEFAULT 'http://www.fictivewebsite.nl/ops/updateProfiles/v1.0')

SELECT

Initials = XmlData.value('(/updateProfilesRequest/updateProfile/fullRelation/initials)[1]', 'varchar(25)'),

Gender = XmlData.value('(/updateProfilesRequest/updateProfile/fullRelation/gender)[1]', 'varchar(25)'),

PhoneArea = XmlData.value('(/updateProfilesRequest/updateProfile/fullRelation/phoneNumber/areaCode)[1]',...

Just wondering if anyone else has a suggestion for this problem.

post a few rows of the table you are querying along with the results of your query

TryingToLearn (12/4/2014)

---

I am looking for clarification of the connection manager underthe data source tab of job step properties in SQL server agent. I have attached a picture of a currently...

Here's a partial solution:

selectCountryId = ctr.value('for $i in . return count(../*[. << $i]) + 1', 'int'),

CityId = c.value('for $i in . return count(../*[. << $i]) + 1', 'int'),

Country = CTR.value('Name[1]','varchar(6)'),...

see here:

http://www.codeproject.com/Questions/194609/What-does-Integrated-Security-SSPI-means-in-the-Co

Welsh Corgi (12/4/2014)

---

Is upgrading from SQL Server 2008 R2 and 2005 to SQL Server 2014 better then going to 2012?

I know that 2014 is at RTM but their are CU's...

I think Jack simply meant do whatever it takes to satisfy the customer request. You don't need to worry about the vendor's product.

Logon to the ReportManager and add the sources to the report.

if you run the select part of your query on the mysql instance, does it work?

-- I have a one table like

declare @t1 table (Part int,Cat int)

insert into @t1(Part, cat) values

(1,101),

(2,102),

(3,103),

(4,104),

(5,105),

(6,106),

(7,107),

(8,108),

(9,109),

(10,110)

-- and other table like

declare @t2 table (Part int, Cat int,Qty int)

insert into @t2(Part, Cat,...

Is your stored procedure producing 3 result sets with one call, or do you call the sp 3 times with different parameters to produce the 3 result sets?

Note that...

Package parameters are read-only. (makes sense, really, you can't 'pass them back' to the caller -- there's no mechanism for that). What you can do is define a variable...

How? Sequences do not allow apha-numeric data. They can only be of these types:

tinyint - Range...

Clustered refers to the fact that the whole table is in index order. So the data is clustered according to its index.