Groups > comp.databases.ms-sqlserver > #965

Re: Help for XML data type in ms-sqlserver

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Help for XML data type in ms-sqlserver
Date	2012-04-09 23:31 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA030EF44F38ADYazorman@127.0.0.1> (permalink)
References	<19738bce-58dd-477f-a1f2-a87edd2064b7@p6g2000yqi.googlegroups.com> <XnsA030D96067AF5Yazorman@127.0.0.1> <08cbb43e-4193-4305-b6b2-a1a1320ab65b@w17g2000yqe.googlegroups.com>

Show all headers | View raw

Ender Karada? (enkaradag@gmail.com) writes:
> actually ive already done something like that before ive written that
> post. (using OPENXML)

OPENXML is legacy, although it has to be admitted that it sometimes 
performs better than the newer xml type methods. But since the type methods 
does not require the call to sp_xml_prepare/removedocument, I prefer
them over OPENXML.

> 1) .... where/on xxx.DOCUMENTNO=yyy.DOCUMENTNO disturbs me /i dont
> know why/
> 
> 2) my actual purpose here is; what if our xml contains more than one
> invoice data?

Guess what? My solution is aimed to handle that situation. And that's 
why get this join that disturbs you. Try it!

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-09 10:35 -0700
  Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-09 21:22 +0200
    Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-09 13:32 -0700
      Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-09 23:31 +0200
        Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-09 14:59 -0700
          Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-10 22:14 +0200
            Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-10 15:40 -0700
              Re: Help for XML data type in ms-sqlserver Erland Sommarskog <esquel@sommarskog.se> - 2012-04-11 07:34 +0000
                Re: Help for XML data type in ms-sqlserver Ender Karadağ <enkaradag@gmail.com> - 2012-04-19 10:51 -0700

csiph-web