XML Select "TYPE=" or Version=""

How can I take my code below and when there's no OrganizationalType return this

<OrganizationalType Type="NOType"/>

Instead of this
<OrganizationalType />

Select blah...blah...blah...,
debtOrganizationalType 'Debtors/Names/IndividualName/OrganizationalType'  
from  
   research.dbo.r_data_ucc where debtLastName Like 'B%'  
for xml path('Record'

Open in new window

Larry Brister

Asked: 2011-03-04

Advertise Here

1 Solution

LVL 15

derekkrommCommented: 2011-03-04

Select blah...blah...blah...,
isnull(debtOrganizationalType, 'NOType') 'Debtors/Names/IndividualName/OrganizationalType'
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'

Larry Bristersr. DeveloperAuthor Commented: 2011-03-04

derekkromm
That returns
<OrganizationalType>NOType</OrganizationalType>

I need
<OrganizationalType Type="NOType"/>

LVL 15

derekkrommCommented: 2011-03-04

isnull(debtOrganizationalType, 'NOType') 'Debtors/Names/IndividualName/OrganizationalType/@Type'

Larry Bristersr. DeveloperAuthor Commented: 2011-03-04

YEAH!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

XML Select "TYPE=" or Version=""

Join & Write a Comment Already a member? Login.

Featured Post