Using the sample data posted, here is a simple query extracting out the values of the GName and FamName elements.

The sample code shows how namespaces are used in the XQuery....

Your XML nodes are qualified by namespaces. Therefore, you must specify the namespaces as part of your XQuery.

See Jacob Sebastian's article (one of a series on XML) here:

http://www.sqlservercentral.com/articles/XML/61333/

You can...

brd123 (3/26/2009)

---

Thanks for the replies. My largest column contains close to 900 bytes. I can change the ntext to varchar but then I get an error about placing...

Not in SQL Server 2005 SP3

1. Read the BOL as it describes the basic of full-text, architecture, etc.

2. See Hilary Cotter's nice articles at http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

3. Use MSDN for additional research. See: http://msdn.microsoft.com/en-us/library/ms345119.aspx

4. Search the...

Sorry, it is not supported. Even if the view is a 1:1 match on the table (i.e., no joins) it does not work. The problem is due to...

Steve Jones - Editor (3/26/2009)

---

I have edited the question to say SQL 2005. We don't necessarily have time to test and go through all questions on all platforms, and I...

Likewise....

See: Jacob Sebastian's Sales Order Workshop Part IV

http://www.sqlservercentral.com/articles/Stored+Procedures/2912/

BTW, Don't use OPENXML. Use XQuery

The magic trick is to shred it into one big flattened table using the CROSS APPLY operator.

For example (code snippit):

SELECT

x1.stage.value('@ID', 'uniqueidentifier'),

x2.activity.value('@ID', 'uniqueidentifier'),

...

It depends.

It prevents multiple round trips to the database server, particularly if the multiple result sets are related. For example, if the logic requires a complex lookup to get...

You can query the page size propeties via code and you don't have to parse the XML. See the following link which contains a VB.Net RS script:

http://www.developmentnow.com/g/115_2005_10_0_0_616192/Probs-running-script-to-fix-linked-report-page-settings.htm

Converted to C#

ReportService2005.Property[]...

I understand the requirement as I have a similar situation. I.e., we are a SaaS company and we have numerous customer databases that are all the same. So...

I had similar problems with Linked Reports. There is no property of "portrait" or "landscape". Everything is done by page size. See the following links to set...

Yes, you can create hierarchical nested XML (e.g., Master / detail) with elements and attributes with SQL Server 2005. The trick is to use sub-selects where you want the...