If a person insist in something it's always hard to change their mind.

What might be a slightly different strategy though:

Write a c.u.r.s.o.r *cough* in SQL Server and show that person,...

If you press F4 the properties window will open. There's a parameter "Schema" with ethe value "dbo". Change it to Category.

Then create your table and save it as ParentCategories. Finally,...

Would you mind sharing the reason and how you resolved it?

It might help others running into the same issue...

Did you use the table designer in Mnagement Studio?

If so, you'll need to change the schema in the properties window (F4).

Or, even better, use the SQL command CREATE TABLE in...

What happens if you use a unicode data type to query the data? Might be an issue with implicit conversion. Hard to tell without the actual execution plans and the...

Here's something to get you started:

SELECT

CAST(

(SELECT '' AS [Description], RCode, '' as Override

FROM #TAICR ICR

WHERE ICR.TAICID=IC.ID AND RCodes = 'Comment'

ORDER BY [XMLOrder]

FOR...

Depending on the process it might be more efficient to perform joins, apply filters and/or aggregate data on the "source server" (Server A), e.g. by writing a stored procedure on...

I second Erland's approach: create a sproc that will perform the tasks that need to be done and use one of the options described in the article he referenced.

We do...

"dbo" has two interpretations:

a) the object "dbo" is the default schema of a database and

b) the principal "dbo" is the default user when a database is created that will be...

Can you provide an example (rows in a table and hoe those should look in the XML you're looking for)?

Might help to "knock down" the language barrier.

Exclude/include values in a report usually is a scenario where...

There's only one absolute No-Go for me due to the technical side effects it can have: never ever prefix a stored procedure sp_ !

The other "strong" standard is not to...

something like tihs?

select

person.x.value('(./personId)[1]','varchar(max)') as personId,

person.x.value('(./name)[1]','varchar(max)') as name,

note.y.value('(./date)[1]','varchar(max)') as [date],

note.y.value('(./text)[1]','varchar(max)') as [text]

from @xml e

cross apply e.xmldata.nodes('organization/department/person') as person(x)

outer apply person.x.nodes('note') as note(y)

Just wondering: Why is a PK column refernced by more than one column of another table?

There are cases when it is...

Yep. 😀

If nothing else, at least I could promote one of RG's products 😛