Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Dynamic SQL, functions, stored procs - What are best practices?

    Further investigation has shown a couple of things.

    First, I started experimenting with querying all of the values from CN=Partitions,CN=Configuration,DC=domain,DC=com and storing them in a temp table, however of the values...

  • RE: Querying XML stored as NVARCHAR

    Thank you, SSCrazy, for the reply - it sent me in the right direction. I think I found a much easier way to tackle the problem, though:

    CAST (o.[data] AS XML).value...

  • RE: Querying XML stored as NVARCHAR

    Matt Miller (#4) (2/25/2010)


    Try:

    CAST (o.[data] AS XML).value ('(/Operation/Initiator/@dn)[1]', 'nvarchar(255)') AS xmlChangeHistory

    Hello, Matt.

    Unfortunately I did already try that. See:

    EnigmaticSoul (2/25/2010)


    FYI, yes, I've also tried "value ('(/Operation/Initiator/@dn)[1]'", but that doesn't work any...

Viewing 3 posts - 1 through 4 (of 4 total)