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 />
<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'
Who is Participating?
LVL 15
isnull(debtOrganizationalT
Select blah...blah...blah...,
isnull(debtOrganizationalT
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'
isnull(debtOrganizationalT
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
